| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User prompt for CSV format
Hello,
I have a code that I would like to change so it can prompt the user to select the directory and file name. However, it must be in CSV format and the file will close. ChDir "I:\GP Finance\WAP09" ActiveWorkbook.SaveAs Filename:="I:\GP Finance\WAP09\PBGCAN Test.csv", _ FileFormat:=xlCSV, CreateBackup:=False ActiveWindow.Close Thanks for your help. MrRJ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If prompt for user data | Excel Discussion (Misc queries) | |||
| Prompt user for input | Excel Programming | |||
| Prompt user to select a printer using a checkbox within a user | Excel Programming | |||
| save prompt for user exit, but no save prompt for batch import? | Excel Discussion (Misc queries) | |||
| Help with user prompt | Excel Discussion (Misc queries) | |||
Threaded Mode
