Hi all, i have written some code, the idea is to format a spreadsheet that i receive every month so that it is in an acceptable format for me to copy and paste the info from this one excel file containing 7 sheets of information, into 7 seperate excel files to then be imported into access.
My code goes into error after i have formatted it, this happens when it gets to the part where i ask it to navigate to the seperate excel file and open the file.
I have checked the code by running through it with F8 and if i tap F8 all the way through my code it works sucesfully, its only when i leave it to its own devices that it cant seem to perform the action of opening my workbook (that i want to transfer the code into) quick enough before the next action (pasting) kicks in.
ITS ALL SOOOOOO CONFUSING!
any ideas please, or am i just being dumb?
Bookmarks