| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a new file with a macro
I have set up a query that retreives information from a MS Access dbase. I
then need to save that information as a tab delimited text file to be imported into a diferent program. Is there a way, when recording a macro, to have it pause for you to enter a file name, or better yet have it use one of the tables cell information as the file name? Such as, cell A5 is a last name. could the macro be recorded to saved that table as a text file with the value of cell A5 being the name of the file? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007: Saving a file with a Macro | Excel Discussion (Misc queries) | |||
| Saving a file while recording a macro | Excel Discussion (Misc queries) | |||
| How to code on Macro on saving and closing a file? | Excel Worksheet Functions | |||
| Saving a text file macro | Excel Discussion (Misc queries) | |||
| Macro Help for Saving a file | Excel Worksheet Functions | |||
![Mike[_36_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
