Help needed guys please. Object failed

[hpoolsteve]

Just a quick one for you guys. Im not very clued up with VB.

I use a report that worked fine for ages. Then moved to a newer version of excel and now i get this error:

Workbooks.Open Filename:= _
"M:\SHARED\despatch\Despatch Reports\Tubes Report\Tubes Report.xls", ReadOnly:=True

The drive mapping is correct. The file is there.

Just not sure what its asking me to do.

The guru who used to deal with has retired

Thanks

[mdmackillop]

Check the file extension. It may be xlsx, xlsm or other

[hpoolsteve]

The file extension that its trying to open is .xls

[Aflatoon]

What is the exact error message?

[hpoolsteve]

Run Time error 1004
Method 'open' of object 'workbooks' failed.

Then the debug line is as above that i pasted

[GTO]

Run Time error 1004
Method 'open' of object 'workbooks' failed.

Then the debug line is as above that i pasted

In a new/junk workbook, try:

Sub example()
  
  MsgBox IIf(Len(Dir("M:\SHARED\despatch\Despatch Reports\Tubes Report\Tubes Report.xls", vbNormal)) > 0, "Exists", "Doesn't")
  
End Sub

If it says it exists, I would suggest stepping thru your code and ensuring which line is causing the error.

Mark

[hpoolsteve]

It does say exist, when i create a dummy macro with that code

[GTO]

Okay, then create a junk copy of your workbook, place a break-point (F9) some lines ahead of the line of code you posted, then step-thru the code with the F8 key. What line hiccups?