file prompt

  • Thread starter Thread starter larry hensel
  • Start date Start date
L

larry hensel

my macro calls a file to be copied into the spreadsheet.

Workbooks.Open Filename:= _
"C:\Documents and Settings\lhensel\My
Documents\data file.xls"
Sheets("ITEM370").Select
Sheets("ITEM370").Move Before:=Workbooks("macro
file").Sheets(1)

the data file name is sometims different and the sheet
sometimes changes too. is their a way to prompt for a
filename?

thanks,

larry
 
Have a look at
Application.GetOpenFileName

this shows the standard Excel File open dialog.
 
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

Run macro from active workbook whose name keeps changing 20
Open four Wbooks, copy four columns from each to Master Wbook 16
Similar Book to Book Code, one works other does not 11
Excel to PDF or XPS boilerplate routines 3
Don't want to hard-code file name in macro 3
opening csv files 9
Variable file name in copy macro 4
Macro for all Excel Workbooks to print to PDF 2

Back
Top