I tried copying your code exactly and I am still having problems. I can extract the excel file from a regular folder, but it gives me the error message when I try to extract from a zip folder.
The frustrating part is this worked fine for me a few months ago and then suddenly stopped around Christmas. I am wondering if a setting has changed on my computer or Access references....
ChrisSpencer
Last Activity: Mar 2 '10, 08:39 PM
Joined: Feb 12 '10
Location:
-
Extracting an Excel file from a zip folder using Access VBA
I had the following line of code working to extract an Excel lfile from a temp.zip folder, but it stopped working about 2 months ago.
Set oApp = CreateObject("S hell.Applicatio n")
oApp.Namespace( ZipFilePath).Co pyHere (ZipFilePath & "temp.zip\" & ExcelFileName)
The error message is "The file exists". Can anyone suggest why this would suddenly stop working? I am not sure what...
No activity results to display
Leave a comment: