Macro to save a file as a PDF

[ynissel]

How do I end off a written macro to save my file as a PDF using a specific
field as the file name ?

[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

"ynissel" <ynissel@discussions.microsoft.com> wrote in message
news:D4292C97-D78C-4C1D-9143-02B99738EAC9@microsoft.com...
> How do I end off a written macro to save my file as a PDF using
> a specific
> field as the file name ?

[ynissel]

"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" <ynissel@discussions.microsoft.com> wrote in message
> news:D4292C97-D78C-4C1D-9143-02B99738EAC9@microsoft.com...
> > How do I end off a written macro to save my file as a PDF using
> > a specific
> > field as the file name ?
>
>
>

[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.

"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" <ynissel@discussions.microsoft.com> wrote in message
> news:D4292C97-D78C-4C1D-9143-02B99738EAC9@microsoft.com...
> > How do I end off a written macro to save my file as a PDF using
> > a specific
> > field as the file name ?
>
>
>

[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

---
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" <ynissel@discussions.microsoft.com> wrote in message news:FC0AFB36-A5BA-43B8-BD2F-056908A8532F@microsoft.com...
>
>
> "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" <ynissel@discussions.microsoft.com> wrote in message
> > news:D4292C97-D78C-4C1D-9143-02B99738EAC9@microsoft.com...
> > > How do I end off a written macro to save my file as a PDF using
> > > a specific
> > > field as the file name ?
> >
> >
> >

[ynissel]

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" <ynissel@discussions.microsoft.com> wrote in message news:FC0AFB36-A5BA-43B8-BD2F-056908A8532F@microsoft.com...
> >
> >
> > "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" <ynissel@discussions.microsoft.com> wrote in message
> > > news:D4292C97-D78C-4C1D-9143-02B99738EAC9@microsoft.com...
> > > > How do I end off a written macro to save my file as a PDF using
> > > > a specific
> > > > field as the file name ?
> > >
> > >
> > >
>
>
>

[David McRitchie]

File, Print, choose printer


Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"ynissel" <ynissel@discussions.microsoft.com> wrote in message news:370D9BEB-2C0B-45B7-89B0-12C9B59D0086@microsoft.com...
> 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" <ynissel@discussions.microsoft.com> wrote in message news:FC0AFB36-A5BA-43B8-BD2F-056908A8532F@microsoft.com...
> > >
> > >
> > > "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" <ynissel@discussions.microsoft.com> wrote in message
> > > > news:D4292C97-D78C-4C1D-9143-02B99738EAC9@microsoft.com...
> > > > > How do I end off a written macro to save my file as a PDF using
> > > > > a specific
> > > > > field as the file name ?
> > > >
> > > >
> > > >
> >
> >
> >

[ynissel]

Worked like a charm - one more follow up - can I specify in the macro where
to "save/print" it ?
Thanks,
Yosef

"David McRitchie" wrote:

> File, Print, choose printer
>
>
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "ynissel" <ynissel@discussions.microsoft.com> wrote in message news:370D9BEB-2C0B-45B7-89B0-12C9B59D0086@microsoft.com...
> > 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" <ynissel@discussions.microsoft.com> wrote in message news:FC0AFB36-A5BA-43B8-BD2F-056908A8532F@microsoft.com...
> > > >
> > > >
> > > > "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" <ynissel@discussions.microsoft.com> wrote in message
> > > > > news:D4292C97-D78C-4C1D-9143-02B99738EAC9@microsoft.com...
> > > > > > How do I end off a written macro to save my file as a PDF using
> > > > > > a specific
> > > > > > field as the file name ?
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>
>

[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.

"ynissel" <ynissel@discussions.microsoft.com> wrote in message news:3B7CF441-A73B-47D5-B8DB-C47BC41A7E15@microsoft.com...
> Worked like a charm - one more follow up - can I specify in the macro where
> to "save/print" it ?
> Thanks,
> Yosef
>
> "David McRitchie" wrote:
>
> > File, Print, choose printer
> >
> >
> > Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> >
> > "ynissel" <ynissel@discussions.microsoft.com> wrote in message news:370D9BEB-2C0B-45B7-89B0-12C9B59D0086@microsoft.com...
> > > 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" <ynissel@discussions.microsoft.com> wrote in message news:FC0AFB36-A5BA-43B8-BD2F-056908A8532F@microsoft.com...
> > > > >
> > > > >
> > > > > "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" <ynissel@discussions.microsoft.com> wrote in message
> > > > > > news:D4292C97-D78C-4C1D-9143-02B99738EAC9@microsoft.com...
> > > > > > > How do I end off a written macro to save my file as a PDF using
> > > > > > > a specific
> > > > > > > field as the file name ?
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >