Hi Tony,
Thanks for reply. It's a routin task - I have to open 160 files. The error msg shows:"Run-time error '1004'".
I want to know the reason and if there is a possible solution with VBA.
Thank you again.
Eugene
Hi,
I'm trying to use VBA code to open a file (say "file1') generated by JDE. The code is simple:
"Workbooks.Open file1"
When I excute it, there is a error msg:" Method 'open' of object 'Workbooks' failed".
If I open it manually, it shows "Excel found unreadable content in file1. Do you want...
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.