Y
ynissel
How do I end off a written macro to save my file as a PDF using a specific
field as the file name ?
field as the file name ?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Chip Pearson
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
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
Y
ynissel
Chip Pearson said: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
D
David McRitchie
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
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
Y
ynissel
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.
from within a macro - and use a specific cell as my filename ?
Thanks.
Y
ynissel
I reposted, sorry. The macro didnt record the switch of the printers - how
do I do that ?
Thanks
do I do that ?
Thanks
David McRitchie said: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
D
David McRitchie
File, Print, choose printer
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
ynissel said:I reposted, sorry. The macro didnt record the switch of the printers - how
do I do that ?
Thanks
David McRitchie said: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 said::
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
How do I end off a written macro to save my file as a PDF using
a specific
field as the file name ?
Y
ynissel
Worked like a charm - one more follow up - can I specify in the macro where
to "save/print" it ?
Thanks,
Yosef
to "save/print" it ?
Thanks,
Yosef
David McRitchie said:File, Print, choose printer
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
ynissel said:I reposted, sorry. The macro didnt record the switch of the printers - how
do I do that ?
Thanks
David McRitchie said: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
:
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
How do I end off a written macro to save my file as a PDF using
a specific
field as the file name ?
D
David McRitchie
Didn't you get a dialog "Print to Output file"
where you specify where you want it to go. If you didn't, I wouldn't
know what would control that.
where you specify where you want it to go. If you didn't, I wouldn't
know what would control that.
ynissel said:Worked like a charm - one more follow up - can I specify in the macro where
to "save/print" it ?
Thanks,
Yosef
David McRitchie said:File, Print, choose printer
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
ynissel said:I reposted, sorry. The macro didnt record the switch of the printers - how
do I do that ?
Thanks
:
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
:
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
How do I end off a written macro to save my file as a PDF using
a specific
field as the file name ?