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.

 

[Arcticwarrio]

can you post your code?

 

[01's]

can you post your code?

hi,
I am posting partial code. Lats line in orange is where error throws.....

Sub Copy_IR_Resolved_files()

Dim datasheet As Worksheet
Dim wksheet As Worksheet
Dim ws_count As Integer

Do
IR_resolved = Application.GetOpenFilename(FileFilter:="Excel Files (*.xlsx), *.xlsx", Title:="Please select IR resolved file")
If (IR_resolved <> False) Then GoTo D
MsgBox ("Please select IR resolved file for correct tool run")
Loop While (IR_resolved = False)
D:
Workbooks.Open Filename:=IR_resolved

 

[Arcticwarrio]

im using XL2000 and it works ok on mine when i change xlsx to xls.

can anyone else with 2007 confirm this.

 

[Sektor]

If (IR_resolved <> [B][COLOR="Red"]"[/COLOR][/B]False[COLOR="red"][B]"[/B][/COLOR]) Then GoTo D

 

[Ruddles]

I am quite sure my codes are perfect.

So it was working perfectly and then it suddenly stopped working, yes?

Had anything just changed immediately before that, like a new version of Office or something like that?

 

[01's]

So it was working perfectly and then it suddenly stopped working, yes?

Had anything just changed immediately before that, like a new version of Office or something like that?

As I said in my query above that it works fine now too but with little adjustment - I need to resave all files as ".xlsx"

This problem has been there since beginning.

 

[Ruddles]

I am quite sure my codes are perfect.

This problem has been there since beginning.

I'm pleased you found a solution on your first visit to this forum.

 

[01's]

I'm pleased you found a solution on your first visit to this forum.

am still waiting for a solution!!!

 

[Arcticwarrio]

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