Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Save As Type in Save as dialog box
Hello
I was hoping anyone would be able to help me with this situation I require code that when it is ran the Save as Dialog Box opens with a preset filename and the Save Type is Excel Workbook. The problem i'm having is i have linked this workbook to a product called GoldMine, and in order for that to work the workbook must be saved as a template. However when running the Save as dialog box it stays as a template so when the user will save this, it will be a template not a workbook. Can anyone help with this I currently am using the code InvoiceNumber = Worksheets("main").Range("j12").Value Filename = "Invoice " & InvoiceNumber Application.Dialogs(xlDialogSaveAs).Show (Filename) So i can get the filename to pull through, i just cant, or dont know how to change the file type Any help would be greatly appreciated Thanks Phill |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save as dialog | Excel Discussion (Misc queries) | |||
how to get disk icon on save button of save as dialog like 2000 | Excel Discussion (Misc queries) | |||
changing the order shown in the save type menu | Setting up and Configuration of Excel | |||
Save As Dialog | Excel Programming | |||
Save As Dialog | Excel Programming |