vzdog
Technical User
- Apr 8, 2008
- 33
Ok. Completely non-user. Have trouble with even recording amacro for sign but here goes.
I am trying to create a Macro that pulls data from an excel spreadsheet 1 line at a time, data could be row 1 thru xxxxx until blank.
I need it to do several things:
Open Extra session
Login
select a destination
login
then read row 1 in the excel sheet (ie 001-01)
take that and attach the following SET-PMMODE-T1::"insert row 1 digits":g;
paste in to the extra session
hit enter
then go back to the excel sheet and do it all over again until row is empty or blank.
To make it just a little more complicated
after several rows in excel of 001-01 etc it could change to vt1-007-2-4 so then I would need the SET-PMMODE-T1::"insert row 1 digits":g; to instead be SET-PMMODE-VT1::"insert row 1 digits":g;
Make any sense to anyone?
When all is said and done I would like to be able to schedule this to run at night or early am....but that's another issue.
Thanks in advance for your patients and guidence.
I am trying to create a Macro that pulls data from an excel spreadsheet 1 line at a time, data could be row 1 thru xxxxx until blank.
I need it to do several things:
Open Extra session
Login
select a destination
login
then read row 1 in the excel sheet (ie 001-01)
take that and attach the following SET-PMMODE-T1::"insert row 1 digits":g;
paste in to the extra session
hit enter
then go back to the excel sheet and do it all over again until row is empty or blank.
To make it just a little more complicated
after several rows in excel of 001-01 etc it could change to vt1-007-2-4 so then I would need the SET-PMMODE-T1::"insert row 1 digits":g; to instead be SET-PMMODE-VT1::"insert row 1 digits":g;
Make any sense to anyone?
When all is said and done I would like to be able to schedule this to run at night or early am....but that's another issue.
Thanks in advance for your patients and guidence.
