Help please with this code. Thanks

[mopey12345]

Dim wb as Workbook
Set wb = Workbooks("C:\Users\Homeusers\Desktop\Payroll\Recall.xlsm")

The file is in the folder, spelling correct but returns Subscript error. Any help appreciated. Thanks Phil

 

[Fluff]

If the file open?

 

[mopey12345]

If the file open?

Hi, Thanks for replying, the file is closed. I am trying to make a menu in a userform to open different workbooks in a shared folder. Thanks Phil

 

[Fluff]

In that case you will need to use

Set wb = Workbooks.Open("C:\Users\Homeusers\Desktop\Payroll\Recall.xlsm")

 

[mopey12345]

In that case you will need to use

Set wb = Workbooks.Open("C:\Users\Homeusers\Desktop\Payroll\Recall.xlsm")

Thanks so much for your help. May I also ask. The "File in Use" notification doesn't work from the menu, but does if opened directly in the shared folder. Any thoughts. Thanks

 

[Fluff]

Don't think that ever shows when opening the file via VBA.

 

[mopey12345]

Don't think that ever shows when opening the file via VBA.

Thanks again for prompt response.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[mopey12345]

You're welcome & thanks for the feedback.

No problem. Been a stumbling block for a few hours so a big help. I wonder if I could write my own "File in Use" message based on the code I had. Then I would know it wasn't open if it returned the subscript error?

 

[Fluff]

You can check to see if the file is read only, but as that's a different question you would need a new thread.