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: mrexcel, command worksheet pdf, macro xls worksheet pdf, mrexcel forum, a1, print pdf, macro, macro excel, create pdf file, create excel worksheet, build list spreadsheet, cell names, run php command, routine create pdf file, php pdf file, php workbook, php macro, excel output pdf, macro spreadsheet, pdf excel via macro, excel 2010 create list, php excel macro, create workbook, php run command, excel print sheet

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

Project ID: #1146005

31 freelancers are bidding on average $84 for this job

svet63

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

$80 USD in 1 day
(52 Reviews)
6.3
bharanisrihari

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

$50 USD in 2 days
(60 Reviews)
6.3
koolsidz

Please see PMB

$35 USD in 0 days
(94 Reviews)
5.6
nagybatonyi

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

$70 USD in 3 days
(48 Reviews)
5.6
vbexcel

Excel PDF expert.

$50 USD in 1 day
(26 Reviews)
5.3
SamNanton

See PM for details.

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

Please check PMB

$45 USD in 1 day
(12 Reviews)
4.4
telemarketing555

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

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

Please see a better solution on PMB. regards

$180 USD in 5 days
(2 Reviews)
4.3
mike25

Please check your inbox for some remarks. Regards, Mike

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

please check pmb for details

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

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

$30 USD in 2 days
(4 Reviews)
2.8
kanadyanako

For your consideration.

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

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

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

hi,lets start the work.i m ready for it.

$40 USD in 2 days
(0 Reviews)
0.0
dineshmhatre

check PM please. You already have solution in excel

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

I'm thinking something like this.... TAB 1 List of File Names…"Sequence start" reportname (xx.xx.date) 1 reportname B (xx.xx.date) 1 reportname C (xx.xx.date) 1 More

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

Dear, Interested.

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

hi i am here to do your job . just check my work to make you happy

$30 USD in 3 days
(0 Reviews)
0.0
shrutivaidya16

i will do it.

$100 USD in 5 days
(0 Reviews)
0.0