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

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.

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

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

--
__________________________________
HTH

Bob

"kiwiwaldo" wrote in message
...
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.

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

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

"Bob Phillips" wrote:

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

--
__________________________________
HTH

Bob

"kiwiwaldo" wrote in message
...
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.

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

Then look at GetSaveAsFilename.

--
__________________________________
HTH

Bob

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

"Bob Phillips" wrote:

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

--
__________________________________
HTH

Bob

"kiwiwaldo" wrote in message
...
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.