workbooks as input to VBA tool not working properly

[01's]

Hi Guys,

I use 5 workbooks as inputs to a VBA tool. I receive these files zipped in mail from a team mate.When I unzip the files to a folder and use directly as input it throws error in line - "Workbooks.Open Filename:=<workbook name>". But when I open all 5 files and resave them in same ".xlsx" format and then use them as inputs; the tool works very fine.
Also I get error "excel found unreadable content...." when I open the workbooks for the first time after unzipping. Can anyone pls guide.
I am quite sure my codes are perfect.

 

[01's]

instead of just extracting the files from the zip folder you could just open them all then save them where you want them :D

Hmmmm yes I am doing that....ya thats the only solution possible as of now it seems......Thanks all guys for your super quick replies today. I am happy with the responses in this forum
Cheers!!! !!!!!