03-24-2009, 01:34 AM
i got it to work by getting window handles
each one gets a different handle so u can have 1 file on, while running 2 seperate macros on 2 spreadsheets, one to copy and replace data
and the other one gets the text and puts into new file organizing nicely
without interfering with each other
pretty neat
each one gets a different handle so u can have 1 file on, while running 2 seperate macros on 2 spreadsheets, one to copy and replace data
and the other one gets the text and puts into new file organizing nicely
without interfering with each other
pretty neat