Run-time Error '1004' - Method 'Open' of object 'Workbooks' failed

[Fean]

Hi,

I have an debug which i dont understand. A error Run-time Error '1004' - Method 'Open' of object 'Workbooks' failed
On my pc its runs smoothly.. another person gets this run time error?

Set WbData = Application.Workbooks.Open(Filename:=(FName))

I have always used this code for opening excel files and suddenly it stops working on another pc's? Kind of very crucial to open a file..

Any ideas?

Dim WbMacro As WorkbookDim WbData As Workbook
Dim FName As String
Dim bValidBook As Boolean
Dim supL As String
Dim EntNr As String
Dim StrFilename As String
Dim Datum As String
Dim Pass As String
Set WbMacro = ThisWorkbook
Dim SubTotal As String
    Application.ScreenUpdating = False
        
Do Until Sheets("Do not delete").Cells(1, 4) = "x" 'Or bErrFound
   
      
    FName = Sheets("Macro").Cells(7, 3) 'MasterFile
    bValidBook = True
       
   Set WbData = Application.Workbooks.Open(Filename:=(FName)) 'open file '<------ HERE I GET A DEBUG
     
     WbMacro.Sheets("Do not delete").Cells(1, 4).Copy 'Entity

etc..

[Paul_Hossler]

What's in

Sheets("Macro").Cells(7, 3)

Text, formula, error, etc.?

[mdmackillop]

Correct this

Dim WbMacro As WorkbookDim WbData As Workbook

[Fean]

What's in

Sheets("Macro").Cells(7, 3)

Text, formula, error, etc.?

C:\Datafile4.xlsm
That is hardcoded. The user has to fill in the path/location of their datafile. This datafile will be generated for many entities.

I might think something is wrong with the properties of this file.

[Fean]

Correct this

Dim WbMacro As WorkbookDim WbData As Workbook

ye.. you got a point. That an copy paste error;-)

[GTO]

Hi,

I have an debug which i dont understand. A error Run-time Error '1004' - Method 'Open' of object 'Workbooks' failed
On my pc its runs smoothly.. another person gets this run time error?

Set WbData = Application.Workbooks.Open(Filename:=(FName))

I have always used this code for opening excel files and suddenly it stops working on another pc's? Kind of very crucial to open a file..

C:\Datafile4.xlsm
That is hardcoded. The user has to fill in the path/location of their datafile. This datafile will be generated for many entities.

I might think something is wrong with the properties of this file.

If the exact same file (presumably stored on a network drive) opens on one PC but not another, I would wonder what the difference is between the two. Do both have the same OS and version of Excel?

Meanwhile, I would try ditching these parenthesis: Set WbData = Application.Workbooks.Open(Filename:= (FName))

[mdmackillop]

Modern Windows don't like you messing around on the root directory. You can't save there by code for example. Try another location to see if that is an issue.