Using Workbook.Open to open an excel file with a variable path

**walt737** · 02-27-2019, 06:36 AM

I have a sub to open several workbooks, copy/paste data, and then close them. The files are on a shared folder and I want anyone on my team to be able to run this macro with little to no prompts. If possible I'd like to avoid using the GetOpenFilename Method. Is there some code that will allow the macro to open these files regardless of where the shared folder is mapped to?

Example

 Workbooks.Open ("Q:\Static Folder\Static subfolder\Static filename.xlsx")

**Phuocam** · 02-27-2019, 06:49 AM

Try

Workbooks.Open (ThisWorkbook.Path & "\" & "Static filename.xlsx")

**walt737** · 02-27-2019, 01:01 PM

Thanks! Works perfectly.

Using Workbook.Open to open an excel file with a variable path

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Using Workbook.Open to open an excel file with a variable path

Re: Using Workbook.Open to open an excel file with a variable path

Re: Using Workbook.Open to open an excel file with a variable path

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Open workbook if not already open then close same file if was not already open

VBA open file with variable name with a variable file path.

Macro to open specified file path with variable date

[SOLVED] I want to set ThisWorkbook.Path inside a variable in order to open a file.

How to copy values from one OPEN workbook (with variable file name) to another

Macro to open a workbook from an unknown file path

Open Word file form Excel using VBA and file path

Bookmarks

Bookmarks

Posting Permissions