Macro to open the save as dialogue box

**Skumby** · 05-18-2015, 11:11 PM

I have our timesheets in Excel. To make it easier for our CEO to approve them I would like to have a button linked to Macro.

At a Minimum I would like it to open the Save As dialogue box with the file type changed to PDF, the save location changed to a specific spot.

Ideally it would be great if it could do the following

1. Save As PDF
2. In a specific spot
3. with "B2 - A12" as the file name, and
4. Either automatically place the CEO's Dynamic Approved Stamp on the document (Including name, date and time) or at least open the PDF so she can stamp it. TEMPLATE - Timesheet.xlsm

**humdingaling** · 05-19-2015, 01:31 AM

so you want to save as PDF in specific spot? or would you want to save the file in specific spot?

filename = B2 and A12?

A12 is a date and "/" is not allowed in system naming
do you want to delete the / or replace with -

**humdingaling** · 05-19-2015, 01:39 AM

try this

Please Login or Register  to view this content.

change both drive and path to suit your setup
i did both pdf and excel
just delete whichever you don't want or leave if you want both

**Skumby** · 05-19-2015, 02:33 AM

That is awesome, thank you! I just need it to open the PDF once saved so the CEO can stamp it authorised then close it. The excel documents are located in a very different spot to where they are being saved so it will save a lot of time if it opens, she stamps it, saves it again and closes it.

**humdingaling** · 05-19-2015, 02:39 AM

change
OpenAfterPublish:=true

**Skumby** · 05-19-2015, 02:56 AM

You are a legend! Thank you!!

**humdingaling** · 05-19-2015, 02:58 AM

not a problem

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Macro to open the save as dialogue box

LinkBack

Thread Tools

Rate This Thread

Display

Macro to open the save as dialogue box

Re: Macro to open the save as dialogue box

Re: Macro to open the save as dialogue box

Re: Macro to open the save as dialogue box

Re: Macro to open the save as dialogue box

Re: Macro to open the save as dialogue box

Re: Macro to open the save as dialogue box

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA - Open Save As dialogue box - to save named range

Command button to open Save As dialogue box for new spreadsheet and copy data.

Macro Save As .xlsx dialogue box

VBA/Macro Code needed to open 'Save As' dialogue box and set the file type to CSV

[SOLVED] VBA code to 'click' Open in the Open or Save dialogue box on a webpage?

Bookmarks

Bookmarks

Posting Permissions