can I write an Excel macro to pause for data entry then continue?

  • Thread starter Thread starter kiwiwaldo
  • Start date Start date
K

kiwiwaldo

I want to create a macro that will choose the MS document printer, which
opens the file, save as dialog box, then go to a folder across anetwork,
pause so I can type the file name, then save, go back to a specific cell in
the worksheet. Any ideas? Thanks.
 
Look at GetOpenFilename in VBA help, you can browse for the file rather than
type in the name.
 
Thanks Bob, but I need to change the file name each time the macro runs from
the "saveas" dialog box. Any ideas?
 
Back
Top