Excel 2003 - Save as dialog box

V

VBA Noob

Hi,

Using code I would like to open the save as dialog box, change the
path to which it saves and ideally change the save as type to PDF and
use the ThisWorkbook.Name

So far I've managed to open the dialog with the below but not sure how
to do the changing the path and file ext or if even possible for 2003.

Application.Dialogs(xlDialogSaveAs).Show

Any help would be appreciated

Danny
 
J

Jim Cone

As far as I know, Excel 2003 has no ability to save files as a pdf.
The following saves the file in the specified folder, as a template (.xlt), under the name of
Danny...

Application.Dialogs(xlDialogSaveAs).Show Arg1:="D:\Icons\Arrows\Danny", Arg2:=17 'template
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Data Rows add-in: Custom Shading, Deleting, Inserting)




"VBA Noob" <[email protected]>
wrote in message
news:fc6b158b-2ef9-46bd-a0a3-5306aac62762@bl1g2000vbb.googlegroups.com...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Task Information Dialog Box not making duration changes to task 0
macOS Office365 Word 0
Make changes in the outlook file save as type using C# 0
Insert Multiple Fields without Dialog closing between each... 0
Word OLE to check spelling in text box 1
Help needed with 'Save As' dialog 5
Macro Code for bringing up Save As dialog box and changing file Type 0
Another Question about Save As Dialog box 3

Top