| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Macro to save a file as a PDF
How do I end off a written macro to save my file as a PDF using a specific
field as the file name ? |
|
#2
|
|||
|
|||
|
Excel doesn't have the ability to save as a PDF file, so the
reply to your question would depend on what program you are using to create the PDF file. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "ynissel" wrote in message ... How do I end off a written macro to save my file as a PDF using a specific field as the file name ? |
|
#3
|
|||
|
|||
|
"Chip Pearson" wrote: Excel doesn't have the ability to save as a PDF file, so the reply to your question would depend on what program you are using to create the PDF file. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "ynissel" wrote in message ... How do I end off a written macro to save my file as a PDF using a specific field as the file name ? |
|
#4
|
|||
|
|||
|
and your additional comment was what ?
If you checked something in the CDO menus, it is unseen in the newsgroups, which are strictly text postings. What you have to do is to choose the printer, and if you have something to create a PDF file you should see the appropriate choice, and you would print to a file. You can get the code by recording a macro. More information on PDF files http://www.mvps.org/dmcritchie/excel/pdf.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "ynissel" wrote in message ... "Chip Pearson" wrote: Excel doesn't have the ability to save as a PDF file, so the reply to your question would depend on what program you are using to create the PDF file. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "ynissel" wrote in message ... How do I end off a written macro to save my file as a PDF using a specific field as the file name ? |
|
#5
|
|||
|
|||
|
I reposted, sorry. The macro didnt record the switch of the printers - how
do I do that ? Thanks "David McRitchie" wrote: and your additional comment was what ? If you checked something in the CDO menus, it is unseen in the newsgroups, which are strictly text postings. What you have to do is to choose the printer, and if you have something to create a PDF file you should see the appropriate choice, and you would print to a file. You can get the code by recording a macro. More information on PDF files http://www.mvps.org/dmcritchie/excel/pdf.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "ynissel" wrote in message ... "Chip Pearson" wrote: Excel doesn't have the ability to save as a PDF file, so the reply to your question would depend on what program you are using to create the PDF file. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "ynissel" wrote in message ... How do I end off a written macro to save my file as a PDF using a specific field as the file name ? |
|
#6
|
|||
|
|||
|
File, Print, choose printer
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "ynissel" wrote in message ... I reposted, sorry. The macro didnt record the switch of the printers - how do I do that ? Thanks "David McRitchie" wrote: and your additional comment was what ? If you checked something in the CDO menus, it is unseen in the newsgroups, which are strictly text postings. What you have to do is to choose the printer, and if you have something to create a PDF file you should see the appropriate choice, and you would print to a file. You can get the code by recording a macro. More information on PDF files http://www.mvps.org/dmcritchie/excel/pdf.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "ynissel" wrote in message ... "Chip Pearson" wrote: Excel doesn't have the ability to save as a PDF file, so the reply to your question would depend on what program you are using to create the PDF file. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "ynissel" wrote in message ... How do I end off a written macro to save my file as a PDF using a specific field as the file name ? |
|
#7
|
|||
|
|||
|
I have Adobe Writer that adds a toolbar to convert to PDB. Can I run that
from within a macro - and use a specific cell as my filename ? Thanks. "Chip Pearson" wrote: Excel doesn't have the ability to save as a PDF file, so the reply to your question would depend on what program you are using to create the PDF file. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "ynissel" wrote in message ... How do I end off a written macro to save my file as a PDF using a specific field as the file name ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to save a file as | Excel Discussion (Misc queries) | |||
| macro to save file automaticaly? | Excel Discussion (Misc queries) | |||
| How to stop getting the file save box when running a macro | Excel Discussion (Misc queries) | |||
| This one is tricky....Macro to save file as cell value x in di | Excel Discussion (Misc queries) | |||
| Macro did not run after download file from net | Excel Worksheet Functions | |||
Hybrid Mode
