How to Open file in VBA thats NOT in my C drive, but in my P drive?

[mfische]

I used this line:

Workbooks.Open ("C:\Timesheet_stuff\February.xlsx")

And it opens up that file...
However, when I try to open up that same file that's in my P: drive (personal drive) it says it cant find it..

Workbooks.Open ("P:\Timesheet_stuff\February.xlsx")



Does anybody know of issues with opening up workbooks outside of the C: drive? This makes no sense..

 

[AkaTrouble]

is the P:\ drive a network drive this could mean you don't currently have connection

you could try these commands in the code ( yes i know 2 lines instead of one)

chdir (P:\Timesheet_stuff\)

Workbooks.Open ("February.xlsx")

 

[mfische]

Thanks! That got it to work. Final code is now:

ChDir "P:\Timesheet_stuff"

Workbooks.Open ("February")