Closed

MACRO - XLS Worksheets to PDF via SaveAs Command

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.

TIM

Skills: Excel

See more: xls worksheets pdf via saveas, macro spreadsheet print pdf file worksheets workbook, create file saveas macro excel 2010, mrexcel, command worksheet pdf, macro xls worksheet pdf, mrexcel forum, a1, Print PDF, pdf work, macro, macro excel, macro + excel, excel to pdf, create pdf file, create excel worksheet, build list spreadsheet, cell names, excel com create sheet, run php command, routine create pdf file, php pdf file, http command, php workbook, php macro

About the Employer:
( 9 reviews ) London, United Kingdom

Project ID: #1146005

29 freelancers are bidding on average $85 for this job

bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

$50 USD in 2 days
(67 Reviews)
6.4
koolsidz

Please see PMB

$35 USD in 0 days
(148 Reviews)
6.5
svet63

VBA developer since 1997. Can do. Regards, Svet.

$80 USD in 1 day
(57 Reviews)
6.5
chriskerpini

Please check PMB

$45 USD in 1 day
(59 Reviews)
6.3
vbexcel

Excel PDF expert.

$50 USD in 1 day
(31 Reviews)
5.6
nagybatonyi

Such jobs are my daily practice, please see PMB for details! Regards!

$70 USD in 3 days
(62 Reviews)
5.7
Krusche

Your requirements are really strict - and also you are after an elegant user friendly, rich faces solution - so your search is over here. Please check your PMB!

$240 USD in 2 days
(21 Reviews)
5.1
SamNanton

See PM for details.

$50 USD in 7 days
(25 Reviews)
4.9
telemarketing555

Hi, please check your PM. Thank you for the great project.

$50 USD in 2 days
(22 Reviews)
4.3
MuhrizRashid

Hello, please see PMB.

$75 USD in 3 days
(12 Reviews)
4.0
mike25

Please check your inbox for some remarks. Regards, Mike

$70 USD in 2 days
(9 Reviews)
3.5
sjestuista

please check pmb for details

$40 USD in 1 day
(3 Reviews)
3.1
ExactSystems

Please see a better solution on PMB. regards

$180 USD in 5 days
(2 Reviews)
4.2
KellogITSolution

Hello Ready to start right now. Please see your PMB for details. Thanks

$30 USD in 2 days
(5 Reviews)
3.2
kanadyanako

For your consideration.

$30 USD in 0 days
(1 Review)
1.6
szhomestudio

I am good at EXCEL and VBA development. Please check the PM

$70 USD in 1 day
(1 Review)
1.4
meektech

I'm thinking something like this.... TAB 1 List of File Names…"Sequence start" reportname ([url removed, login to view]) 1 reportname B ([url removed, login to view]) 1 reportname C ([url removed, login to view]) 1 More

$50 USD in 1 day
(0 Reviews)
0.0
dineshmhatre

check PM please. You already have solution in excel

$30 USD in 0 days
(0 Reviews)
0.0
sohel1985

Dear, Interested.

$200 USD in 15 days
(0 Reviews)
0.0
shrutivaidya16

i will do it.

$100 USD in 5 days
(0 Reviews)
0.0