jordanburch
Active Member
- Joined
- Jun 10, 2016
- Messages
- 440
- Office Version
- 2016
Hey everyone
I have the following path.
Workbooks.Open ("K:\SHARED\TRANSFER\Enterprise Wide Suspense Initiative\Source Files\CRIS\" & ThisWorkbook.Worksheets("Variables").Range("A4").Value & "\" & Left(ThisWorkbook.Worksheets("Variables").Range("A1").Value, 6) & "\" & "*.xlsx")
The path looks just fine and works on a different month, however this month it just says it cant find that file and shows it with the above path and the *.xlsx like the file should be named *.xlsx vs the acutal file name. Its the only file inside that path and I want it to open that file and just put the * it seemed to work before but now it doesnt that I tried it in a new month. Any ideas?
I have the following path.
Workbooks.Open ("K:\SHARED\TRANSFER\Enterprise Wide Suspense Initiative\Source Files\CRIS\" & ThisWorkbook.Worksheets("Variables").Range("A4").Value & "\" & Left(ThisWorkbook.Worksheets("Variables").Range("A1").Value, 6) & "\" & "*.xlsx")
The path looks just fine and works on a different month, however this month it just says it cant find that file and shows it with the above path and the *.xlsx like the file should be named *.xlsx vs the acutal file name. Its the only file inside that path and I want it to open that file and just put the * it seemed to work before but now it doesnt that I tried it in a new month. Any ideas?