 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / July 2007split not working
Okay, maybe I've just benn staring at it too long. Why doesn't this work? Doesn't matter whether I put a space after the comma or not. End result is the entire string winds in s_array(0). Any clue? Dim s_array As Variant dim s_types as string s_types = "18FC,36FC, 72FC" s_array = Split(s_types, ",")  Signature------- Say it loud http://tinyurl.com/39rhxa > Okay, maybe I've just benn staring at it too long. Why doesn't this > work? Doesn't matter whether I put a space after the comma or not. End [quoted text clipped - 4 lines] > s_types = "18FC,36FC, 72FC" > s_array = Split(s_types, ",") Never mind. figured it out. needed vba.split. Not sure what I was calling! Signature------- Say it loud http://tinyurl.com/39rhxa >> Okay, maybe I've just benn staring at it too long. Why doesn't this >> work? Doesn't matter whether I put a space after the comma or not. End [quoted text clipped - 7 lines] > Never mind. figured it out. needed vba.split. Not sure what I was > calling! I guess you have a function called Split in your project? Or possibly you have set a reference to another library in Tools References, and that library which has a Split function in it. SignatureRegards Jonathan West - Word MVP www.intelligentdocuments.co.uk Please reply to the newsgroup |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.