Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As File Type
Hi there, I have written a macro to copy a worksheet from an Excel spreadshee into a new workbook. I then wish to save this wookbook as a CSV file. The problem is that I want the Save As box to appear for the user, bu I want to to default automatically to CSV in the file type drop down. The location and name of where the file is being saved depends on th user, the only constant is that the file must be CSV. Can anyone help? Thanks Ma -- swedish ma ----------------------------------------------------------------------- swedish max's Profile: http://www.excelforum.com/member.php...fo&userid=2440 View this thread: http://www.excelforum.com/showthread.php?threadid=51815 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As File Type
Max,
Check out the GetSaveAsFilename method. NickHK "swedish max" wrote in message ... Hi there, I have written a macro to copy a worksheet from an Excel spreadsheet into a new workbook. I then wish to save this wookbook as a CSV file. The problem is that I want the Save As box to appear for the user, but I want to to default automatically to CSV in the file type drop down. The location and name of where the file is being saved depends on the user, the only constant is that the file must be CSV. Can anyone help? Thanks Max -- swedish max ------------------------------------------------------------------------ swedish max's Profile: http://www.excelforum.com/member.php...o&userid=24408 View this thread: http://www.excelforum.com/showthread...hreadid=518157 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As File Type
Dim fileSaveName fileSaveName = Application.GetSaveAsFilename( _ fileFilter:="CSV Files (*.csv), *.csv") If fileSaveName < False Then ActiveWorkbook.SaveAs fileSaveName End If -- HTH Bob Phillips (remove nothere from email address if mailing direct) "swedish max" wrote in message ... Hi there, I have written a macro to copy a worksheet from an Excel spreadsheet into a new workbook. I then wish to save this wookbook as a CSV file. The problem is that I want the Save As box to appear for the user, but I want to to default automatically to CSV in the file type drop down. The location and name of where the file is being saved depends on the user, the only constant is that the file must be CSV. Can anyone help? Thanks Max -- swedish max ------------------------------------------------------------------------ swedish max's Profile: http://www.excelforum.com/member.php...o&userid=24408 View this thread: http://www.excelforum.com/showthread...hreadid=518157 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make a .XLTM template file default to save as .XLSM type? | Excel Discussion (Misc queries) | |||
Attempting to save a file type blocked by registry policy setting | Excel Discussion (Misc queries) | |||
How do you save an excel file to be read as IBM-type text file ? | Excel Worksheet Functions | |||
default save as file type does not work | Excel Discussion (Misc queries) | |||
why cant i see .csv as save file type | Excel Discussion (Misc queries) |