Hi All,
I'm trying to open a zip csv file from VBA but keep getting error '1004' for method open of object workbooks failed. I've tried everything and nothing seems to fix or get around it.
I can manually open the file fine, so the file definitely exists and is not corrupt etc. I've triple checked the path/name string is correct in VBA and it is.
I'm using Excel 2010. Any ideas????
Thanks!
You'll have to post what code you have or attach the workbook so we can review.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks