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

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.
 
B

Bob Phillips

Look at GetOpenFilename in VBA help, you can browse for the file rather than
type in the name.
 
K

kiwiwaldo

Thanks Bob, but I need to change the file name each time the macro runs from
the "saveas" dialog box. Any ideas?
 

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

Macro Pause during Dialog Box data entry 6
Can you pause a macro in excel to input data and continue? 1
Pause Macro, take action, then continue 2
pausing a "save as" macro 1
Can a macro pause for a data entry before finishing? 4
Is there a way of pausing a macro 2
Funcitonality to pause macro?! 13
Macro to pause for user input in dialog box 1

Top