|
Post by Trey on Jun 19, 2021 17:14:14 GMT
Use Case: I've got a table, and I'd like to loop through each row in the table, running a macro for each iteration. Each iteration, I want to update the variables using the values of the row for that iteration.
How do I pass a new set of variables on each macro run? Ideally, I'd like to call the macro from the command line with a new set of variables for that macro iteration.
|
|
|
Post by philranger on Jun 19, 2021 23:54:35 GMT
Hello,
I often treat table elements from MS-Word or Excel. I place my cursor in the first cell, do a ctrl-c, paste in a notepad to get rid of the formatting and recopy, then do my treatment and paste to my destination. I then do a keypress tab to move to the next cell in the source table.
You could also get your data from a file, but since I never did that I can’t help much.
Let us know!
|
|
|
Post by zeak on Jun 23, 2021 3:22:09 GMT
Hi Trey & Phil,
I am also keen for this as most of my work in in Excel, the main problem is when trying to copy from Excel sometimes it copies as a picture format and therefore cannot be pasted as text.
I've been trying to work the over way around also, copy something from another source and paste in Excel.
|
|
|
Post by philranger on Jun 24, 2021 15:02:43 GMT
Hello
To copy from excel or word, i first paste to a notepad to get rid of the formatting, then ctrl-x from there. Slow and cumbersome but works.
Saving your excel file as a coma delimited (csv if I remember) may allow you to take calues directly from that file.
Microsoft ain’t gonna make it easy for you!
|
|