| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem- Recording macros for "file save" and "File open"
i am trying to write a macro that has the following steps:
1- copies certain text from a worksheet cell 2- opens the "file-open" dialogue box 3- opens the "rename" function on the selected file 4- pastes (using rightclick menue) the copied text into the "file name" field on the "file-open" tree. problem: when i record these kestrokes and the stop the recorder and review the macor in VB. steps 2-4 dont show up a all. please help me. thanks  --- Message posted from http://www.ExcelForum.com/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem- Recording macros for "file save" and "File open"
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 | Excel Discussion (Misc queries) | |||
| Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Excel Discussion (Misc queries) | |||
| Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Setting up and Configuration of Excel | |||
| Disabling "SAVE AS" option under "File" | Excel Discussion (Misc queries) | |||
| How can I get "File Close" to prompt me to "Save Changes" ?? | Excel Programming | |||
Hybrid Mode
