-
Pasting from Clipboard into range of fields?
I would like to be able to copy 8 cells in 1 row from an Excel spreadsheet (manually) and using a window button paste that data (numbers ranging from 0.00 to 999) into a range of 8 fields on the window of the current main file. I was thinking I might use a list as an intermediary (easier to code) but I can’t seem to find any relevant commands other than Paste from clipboard which does not seem to be delimiter smart. What might be the options? TIA, Allan.
-
1 Reply
-
You could paste the clipboard into a character variable and then parse the string into a list using a Carriage Return as delimiter.
The code should look something like this:
Paste from clipboard charVar1
Do listVar.$define(charVar1)
Repeat
Calculate charVar2 as strtok(‘charVar1’,chr(13))
Do listVar.$add(charVar2)
Until charVar2=”
Log in to reply.
