Opening Variable File Names

  • Thread starter Thread starter simoncohen
  • Start date Start date
S

simoncohen

I need to write a Macro to ask for an input number (say 123) and the
open a series of workbooks based on this input - e.g. AA123.xls
AB123.xls. Can anybody please suggest some code to enable this. Thank
 
ans= Inputbox("Please supply file id")
If ans <> "" Then
Workbooks.Open Filename:= "AA" & ans & ".xls"
End if

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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

remove two letters when searching 1
VBA insert column with two workbooks open 1
Open workbook using VBA but don't run macros 1
Userform Save data To Worksheet & File 1
Ask user a file name 1
select new wkbk when name varies 4
User defined menu stops working when workbook saved with a newname??? 4
Run code from another workbook 7

Back
Top