Using a Variable in the Workbooks.Open code

  • Thread starter Thread starter Phatchef24
  • Start date Start date
P

Phatchef24

Hey Ron,

I gave that a shot and I couldn't get it to work. Does the variabl
have to be set as a Range? When I tried it, excel gave me an error o
"inexpected end of statement". I guess the extra " " was throwing i
off
 
You can use a string also

Sub test2()
Dim Myvar As String
Myvar = "yourworkbookname"
Workbooks.Open Filename:="\\Jelle\shareddocs\" & Myvar & ".xls"
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Workbooks.Open() error handling 3
Save As and new workbook new name used in existing code 8
Error Opening Workbook 3
Use external file variable in formula 2
Using only variables to reference a range 2
Workbooks.Open Filename 1
Using Wildcard on Workbooks.Open 1
File name extension 2

Back
Top