Suljettu

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: [login to view URL] so hopefully it is more a case of pulling pieces together. Anyway that's up to you.

Do ask me any other questions.

TIM

Taidot: Excel

Näytä lisää: php excel pdf, xls macro xml, list last names, number pdf, copy paste xls macro, build via, print excel file php, excel list together, pdf output php, pdf spreadsheet, create xls php, pdf create web, excel file via php, macro excel web, xml xls macro, xls php, excel macro print, excel lot number, create pdf php, web output excel

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

Projektin tunnus: #1146005

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

bharanisrihari

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

$50 USD 2 päivässä
(67 arvostelua)
6.3
chriskerpini

Please check PMB

$45 USD 1 päivässä
(66 arvostelua)
6.5
svet63

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

$80 USD 1 päivässä
(57 arvostelua)
6.5
koolsidz

Please see PMB

$35 USD 0 päivässä
(148 arvostelua)
6.5
vbexcel

Excel PDF expert.

$50 USD 1 päivässä
(32 arvostelua)
5.6
nagybatonyi

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

$70 USD 3 päivässä
(62 arvostelua)
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 2 päivässä
(21 arvostelua)
5.1
SamNanton

See PM for details.

$50 USD 7 päivässä
(25 arvostelua)
4.9
telemarketing555

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

$50 USD 2 päivässä
(22 arvostelua)
4.3
MuhrizRashid

Hello, please see PMB.

$75 USD 3 päivässä
(12 arvostelua)
4.0
mike25

Please check your inbox for some remarks. Regards, Mike

$70 USD 2 päivässä
(9 arvostelua)
3.5
KellogITSolution

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

$30 USD 2 päivässä
(5 arvostelua)
3.2
sjestuista

please check pmb for details

$40 USD 1 päivässä
(3 arvostelua)
3.1
ExactSystems

Please see a better solution on PMB. regards

$180 USD 5 päivässä
(2 arvostelua)
4.2
szhomestudio

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

$70 USD 1 päivässä
(1 arvostelu)
1.4
kanadyanako

For your consideration.

$30 USD 0 päivässä
(1 arvostelu)
1.6
meektech

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

$50 USD 1 päivässä
(0 arvostelua)
0.0
patelakash

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

$40 USD 2 päivässä
(0 arvostelua)
0.0
shrutivaidya16

i will do it.

$100 USD 5 päivässä
(0 arvostelua)
0.0
sohel1985

Dear, Interested.

$200 USD 15 päivässä
(0 arvostelua)
0.0