it is a text file created from a C++ application. i was tying to open it as WorkBook.Open.
Anyways i reverted back and put a DoEvents before the paste - seems to work.
thank you
stevie500
thanks for the help.
i tried reordering the sequence of events - didn't work!
so i've gone for your other option but am having difficulty when i try to delimit the file. i need it to be dilimmited by commas and tabs. the parameter of open only has an option for 1 item, and the textToColumns...
Hi, can someone urgently help me.
i'm copying data from 1 book to the other by copying all the data from the selected file, opening a new book, select cell A1 then paste my data. This is succesful apart from on 2 pc's.
In debug mode after the error message if i proceed it still works!!
Does...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.