OberonPlace.com Forums  

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

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

Hi
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.

nic

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

Code:
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
  #3  
Old 18-04-2016, 10:20
nic nic is offline
Member
 
Join Date: May 2009
Posts: 90
Default

Thanks Shark - really appreciate your help.
nic
Reply With Quote
Reply


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 23:10.


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