Hello,
I am using the following code to transfer battery testing data from .csv files into a .xlsm file.
It gets what I need done but, if I select "Cancel" from the input file box it creates a Run-time error '1004': 'False.xlsx' could not be found.........
What do I need to add to my code to stop this?
Please Login or Register to view this content.
Last edited by XxCMoneyxX; 04-15-2013 at 03:23 PM.
Please Login or Register to view this content.
Thanks for the speedy reply.
The error remains unfortunately. I am rather new in the VBA world so I posted my code again with your suggestion to make sure I am not making a rookie mistake.
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by shg; 04-15-2013 at 03:16 PM.
Entia non sunt multiplicanda sine necessitate
My apologies... change "False.xlsx" to just "False"
No apology needed.
I changed it to "False" but I now am getting a Run-time error '91' Object variable or With block variable not set
I just tried the
But that creates a 1004 error again.Please Login or Register to view this content.
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
That did it!!
Thanks everyone for your input.Please Login or Register to view this content.
Take care.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks