OberonPlace.com Forums  

Go Back   OberonPlace.com Forums > Developer Forums > VBA > CorelDRAW/Corel DESIGNER VBA

Thread Tools Search this Thread Display Modes
Old 17-04-2016, 04:56
nic nic is offline
Join Date: May 2009
Posts: 90
Default Split string to values

Im using excel to get rgb values for colouring objects and would like to find a way of using coreldraw's VBA to convert a string with values in the format "127, 23, 250" (ie a string containing 3 numbers separated by 2 commas) to 3 separate variables each containing a numerical value.

Help appreciated.


Last edited by nic; 17-04-2016 at 05:01.
Reply With Quote
Old 18-04-2016, 06:51
shark shark is offline
Senior Member
Join Date: Aug 2010
Location: Russia, Belgorod
Posts: 146

Private Sub TestSplit()
Dim Test As Variant
    Test = Split("127, 23, 250", ",")
End Sub
After this code Test(0) contains 127, Test(1)=23 and test(2)=250
Reply With Quote
Old 18-04-2016, 10:20
nic nic is offline
Join Date: May 2009
Posts: 90

Thanks Shark - really appreciate your help.
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
string in form runflacruiser CorelDRAW/Corel DESIGNER VBA 1 23-09-2009 01:31
WebBrowser class string Keefster CorelDRAW/Corel DESIGNER VBA 1 09-04-2009 12:26
Page Size String ddonnahoe CorelDRAW/Corel DESIGNER VBA 3 15-12-2006 14:21
Randomising a text string knowbodynow CorelDRAW/Corel DESIGNER VBA 3 07-05-2006 07:15
how can we get string from... olympiatr CorelDRAW/Corel DESIGNER VBA 2 04-11-2004 02:39

All times are GMT -5. The time now is 06:02.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright © 2011, Oberonplace.com