| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Macro: Pause & ask user: "Are you sure you want to continue? | Excel Discussion (Misc queries) | |||
| PAUSE EXCEL MACRO FOR INPUT OF DATA VARIABLE | Excel Discussion (Misc queries) | |||
| Can you pause a macro in excel to input data and continue? | Excel Discussion (Misc queries) | |||
| Macro Pause during Dialog Box data entry | Excel Discussion (Misc queries) | |||
| is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
Linear Mode
