Cannot access workbook using full path of the file

[kylefoley76]

When I use the following code everything works:

Dim wb As String
wb = "xlwings_temp2.xlsx"
Workbooks(wb).Activate
Application.ScreenUpdating = True
Workbooks(wb).Save

But I'm going to be moving files around and accessing this subroutine from other folders so I need to use the full path but I cannot get it to work. I already looked up the full path using the locals window. So when I put in:

Dim wb As String
wb = "/Users/kylefoley/PycharmProjects/inference_engine2/inference2/proofs/other/xlwings_temp2.xlsx"
Workbooks(wb).Activate
Application.ScreenUpdating = True
Workbooks(wb).Save

That failed. I also tried:

Dim pt As String, cd As Workbook
pt = "/Users/kylefoley/PycharmProjects/inference_engine2/inference2/proofs/other/xlwings_temp2.xlsx"
Workbooks.Open FileName:=pt
Set wb = Application.Workbooks(pt)
Application.ScreenUpdating = True
wb.Save

But that failed too. I'm getting a subscript out of range error whenever I use the long string. The following image will demonstrate that I'm using the correct string. I know mrexcel does not like linking to 3rd party sites but I have no way to posting a screenshot other than the following.

https://ibb.co/mHzaoz

 

[Fluff]

Try

Dim pt As String, Wb As Workbook
pt = "/Users/kylefoley/PycharmProjects/inference_engine2/inference2/proofs/other/xlwings_temp2.xlsx"
Set Wb = Workbooks.Open(Filename:=pt)

 

[Jack in the UK]

That path is not the full path, what you have there is known and UNC

Try hardcode (hardcode) the full path etc and see if that is better assumes you have rightful access (privileges to the network share)

or change the UNC to "\\........ not "\......



jiuk

 

[Fluff]

@jiuk
Those are MAC paths, not PC paths.

 

[Jack in the UK]

Hey Fluff

Don't worry I am going rather slightly crazy these days, too much work on so many different systems and hardware!

 

[kylefoley76]

Problem solved. It turns out that Excel does not need the full path of the file in order to activate it. As long as the file is open, it will activate that file no matter what file it is in. I'm guessing that it only needs the full path in order to open a file.

 

[RoryA]

I'm guessing that it only needs the full path in order to open a file.

That's correct. You can only have one file open with a given name, so the path would be unnecessary.