
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
I am looking for some help to create some code to create and assign values to a number of variables - such as A1, A2, A3 ....An, where n is a variable number depending on the circumstances of external data.
I have done this in the very long distant past, but I have forgotten and/or lost the knack or coding technique, although I think that it used the (read) or (set) functions.
I have to extract strings from a command and quote delimited file from Excel on a per line basis (e.g. "text1", "text2", "text3") and subsequently assign A1 to "text1", A2 to "text2" etc but the number of strings is variable - depending on the project.
Can someone please help me get started.
Thanks
George in New Zealand
Solved! Go to Solution.