Select Range and Save As PDF? On a mac

**thequiff** · 11-01-2013, 03:12 PM

This is what I have taken

Please Login or Register  to view this content.

From herehttp://code.msdn.microsoft.com/offic...ta-to-07bb5550

And this is what I edited it to

I get a compile error and syntax error?

Any ideas please?

Please Login or Register  to view this content.

**BeachRock** · 11-02-2013, 02:52 AM

Hello thequiff,

I'm not sure if there is a difference for this between Windows and Mac versions for this but, I use the following to export a sheet to a pdf file and save it automatically with a filename from combination of the data entered in two different cells on two different sheets. Modify the sheet names and ranges to match your criteria.

Please Login or Register  to view this content.

**thequiff** · 11-02-2013, 12:04 PM

Excellent, thanks for that, minor modification and it works

Please Login or Register  to view this content.

**BeachRock** · 11-02-2013, 01:50 PM

Glad I could help.

Select Range and Save As PDF? On a mac

LinkBack

Thread Tools

Rate This Thread

Display

Select Range and Save As PDF? On a mac

Re: Select Range and Save As PDF? On a mac

Re: Select Range and Save As PDF? On a mac

Re: Select Range and Save As PDF? On a mac

Thread Information

Users Browsing this Thread

Similar Threads

Look up cell, use as reference to select from a range, to then select data in a column...

[SOLVED] Save PDF - Select file location

send to range, popup box to input what the range should be each time/select range

Select row and save it

How To Select/Save ListBox Contents

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions