getting back to excel

[Guest]

i am trying to write a macro to make my job a little easier and i have to
copy data from excel and put it into a powerterm emulator and i can get it to
do just that. the problem is getting back to the excel spreadsheet that i am
getting my data from. i have to copy data one cell at a time and get back to
excel to do it again. right now the macro copies the data and puts it into
powerterm and performs the task. i want it to then go back to the excel
spreadsheet that is open. i am a rookie at VB so i don't know alot and this
may just be a simple problem. if anyone can give me the syntax to get back
to excel, i would really appreciate it. until then..... ALT+TAB for me.
thanx.

 

[Bob Phillips]

Alton,

I think we would need to see your code and a bit of detail of what/how you
do it.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Glen Mettler]

Try a "For" loop - something like this?

For i = 1 to number_of_cells
select excel sheet
select cell
copy
select powerterm
paste data
next


paste data

 

[Guest]

alright. i'll get the code tonight when i go to work and post it in the
morning.