MACRO - XLS Worksheets to PDF via SaveAs Command2

I create a regular EXCEL spreadsheet with 50-100 separate worksheets. Each worksheet then needs to be output to a PDF File. I want a Macro that will do this for me. Some more detailed points:

1. I'm using EXCEL 2010.

2. Most of the sub-routines I have seen on the web assume you want to Print to PDF. I DON'T, I want to File/SaveAs/PDF

3. I don't want to output every worksheet in the workbook. I would hightlight the ones I wished to output and it would run through them consecutively.

4. I want the file name to be specified as part of the routine, each Worksheet would of course have a different filename. These would be drawn from a FileName Worksheet within the same Workbook and would be variables. So there would be a list of file names that the routine could work through consecutively. So for example it could perhaps look up the filename in cell A1 for the first worksheet output A2 for the second and so on.

5. The directory would also be specified in the same way (though directory would probably be the same for all worksheets in each output session).

6. The number of Worksheets to output each time would vary so the routine would need to cycle through until it reached a null value / last sheet and then stop.

7. Speed is not an issue so by all means build a in a few seconds between each PDF output.

A lot of the work seems to be out there on the web already, for example here: [url removed, login to view] so hopefully it is more a case of pulling pieces together. Anyway that's up to you.

Do ask me any other questions.


Taidot: Excel

Näytä lisää: excel saveas pdf macro, excel xls pdf macro, create pdf worksheet macro excel 2010, saveas pdf macro, excel pdf worksheet macro, macro pdf worksheets, xls worksheets pdf via saveas, command2 excel, create file saveas macro excel 2010, mrexcel, macro excel workbook pdf, create macro pdf excel sheet, create pdf using excel macro, xls macro pdf, excel pdf separate worksheets, command2, Worksheets, mrexcel forum, a1, Print PDF

Tietoa työnantajasta:
( 9 arvostelua ) London, United Kingdom

Projektin tunnus: #1196980

17 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


I sent you a small sample showing the basic concept of the planned solution, see it attached to my message in PMB.

$250 USD 2 päivässä
(40 arvostelua)

Hi, Excel VBA [login to view URL] see my reviews.I have over 7 years of VBA Excel experience. I will provide a very comprehensive solution for [login to view URL] check PMB for a sample and solution [login to view URL]

$320 USD 2 päivässä
(65 arvostelua)

Excel / VBA expert - ten years experience.

$250 USD 1 päivässä
(25 arvostelua)

Hi Tim I am a Management Accountant with 20 years experience and very strong Excel & VBA skills, so I know that I can deliver a great solution for you. Please see PM.

$250 USD 2 päivässä
(11 arvostelua)

Hi Tim, ***************PLEASE CHECK MESSAGE BOARD I THINK YOU'LL FIND IT'S DONE****************

$250 USD 3 päivässä
(21 arvostelua)

Hello, I see you require an Excel macro (which will work on Excel 2010) to CUSTOM save to PDF files. I mean the "FileName" worksheet will have the list of other Worksheets and there filaments to be saved. The macro nee Lisää

$250 USD 5 päivässä
(14 arvostelua)

Hello, Excel VBA develoepr here working in a Surrey based company. I have done similar work before and can send you a sample if needed? I am keen on this and look forward to your reply. Thanks.

$300 USD 5 päivässä
(2 arvostelua)

Have done the *exact* same thing before. Would be glad to help! Pls see PM. Thanks!

$250 USD 1 päivässä
(3 arvostelua)

Excel / VBA expert - 10+ years experience

$350 USD 2 päivässä
(0 arvostelua)

I have worked developing VBA macros for many customers (outside For this project, I just developed a small macro as a proof of concept of what you need and it works smoothly! Please help me build my re Lisää

$250 USD 2 päivässä
(0 arvostelua)

Dear Sir, I understand your demand [login to view URL] give me a [login to view URL] check PM.

$300 USD 5 päivässä
(0 arvostelua)

I am an experienced Excel VBA programmer with good Excel skill. I can complete this task as described in the job description using save as function in Excel 2010. Please have a look at the pm that I sent you. Thank you Lisää

$250 USD 0 päivässä
(0 arvostelua)

I need excel work

$300 USD 3 päivässä
(0 arvostelua)

Hi Tim, I have good amount of experience in developing the VBA excel macros. I would be able to do this for you.

$250 USD 7 päivässä
(0 arvostelua)

Hi: I can deliver this project; we will give you a user-friendly version. Thanks!

$250 USD 2 päivässä
(0 arvostelua)

Hello, Our team can do it for you. Regards, v Engineering Team

$250 USD 7 päivässä
(0 arvostelua)

Hi, Please check your Inbox. Thanks

$250 USD 7 päivässä
(0 arvostelua)