Save as dialogue box

**stevecontracts** · 03-01-2010, 07:28 AM

Hi Guys
Im trying to use a button that will save 3 sheets as pdf

the sheets i need are named

ready
opening
access

i want it to select the sheets then preselect the pdf but only to bring the dialogue box as i need to save these to different locations

thanks in advance

**rwgrietveld** · 03-01-2010, 07:40 AM

How about this:

Please Login or Register  to view this content.

**stevecontracts** · 03-01-2010, 07:52 AM

IM GETTING RUN TIME ERROR 424
OBJECT REQUIRED

AND ITS HIGHLIGHTING THIS TEXT

Please Login or Register  to view this content.

**stevecontracts** · 03-01-2010, 08:22 AM

im not getting that to work either

in an ideal world i would like it to select the three sheets
open up the dialogue box
save it as forms
then select pdf

then select the destination folder based on whats in a2
the folder is destination \\myserver\job_file
then it needs to find the folder based on the number in a2 and save it into a sub folder in that folder

all a bit confusing but i know it can be done
just cant do it

**stevecontracts** · 03-01-2010, 08:46 AM

Attached sheet

**Marcol** · 03-01-2010, 09:07 AM

What's the point in posting a password protected (VBA) workbook(TRIAL.xlsm)?

**stevecontracts** · 03-01-2010, 10:12 AM

Damn

sorry obviously i forgot about that
apologies

here is new one

**stevecontracts** · 03-01-2010, 11:53 AM

bump bump bump

**stevecontracts** · 03-02-2010, 06:52 AM

if anyone could help with this it would be much aprpeciated

**stevecontracts** · 03-02-2010, 07:06 AM

Please close

**teylyn** · 03-02-2010, 09:11 AM

stevecontracts,

- do not start another thread for the same question.
- mind your language in this forum
- do not bump your post after a mere couple of hours. Bump max every 24 hours. We are all unpaid volunteers, putting in our time when we find it. We all have lives to live and jobs to to, too.
- consider providing more information about the issue rather than stomping you foot.

Your duplicate post was closed by another moderator. Feel free to build on the advice and suggestions you have received in this thread.

thanks

**stevecontracts** · 03-02-2010, 09:15 AM

i moved it to the programming section as i thought it may be more appropriate there

**stevecontracts** · 03-02-2010, 05:20 PM

bump bump bump

**teylyn** · 03-02-2010, 06:30 PM

stevecontracts,

you had better change your attitude. Rather than bumping your thread again after 8 hours, despite having been advised by me not to bump more than once in a 24 hr period, you may want to consider giving more information about your problem than tossing your toys.

By the way: Every post to a thread will bump it up the list. So your post #12 is already a bump, even if it does not have that word.

**teylyn** · 03-02-2010, 06:49 PM

stevecontracts, I will give you some time to cool off. I was polite and friendly. You were impatient and impertinent. Giving negative reputation to a moderator for being reminded of the forum rules shows a lot about your maturity, or rather lack thereof.

Save as dialogue box

LinkBack

Thread Tools

Rate This Thread

Display

Save as dialogue box

Re: Save as dialogue box

Re: Save as dialogue box

Re: Save as dialogue box

Re: Save as dialogue box

Re: Save as dialogue box

Re: Save as dialogue box

Re: Save as dialogue box

Re: Save as dialogue box

Re: Save as dialogue box

Re: Save as dialogue box

Re: Save as dialogue box

Re: Save as dialogue box

Re: Save as dialogue box

Re: Save as dialogue box

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions