software

Hello all!

I'm using a VBScript file which I've added to Server 2003 scheduler to
automatically open up Excel, load it with a workbook which is in turn
populated with data, print it out, dynamically come up with a filename which
is figured off of the current date and time which is then appended to the
original filename of the workbook, save it in HTML format, then close
itself. Works like a charm.

I've decided I don't want to save the file in HTML format but would instead
like to save it in PDF. The reason being is HTML files can modified by any
with a text editor. PDF files are relatively permanent and secure which is
what I need.

I have Acrobat 6.0 Pro installed. I can use the print function, select
Adobe PDF as the printer, a prompt comes up asking for a file name to save
to, and it gets converted. At least when I do it manually it's like that.
I thought I could figure out how to do it within VBScript easily. As it
turns out, I'm freaking lost and have no idea how to do it. I was hoping
some info would be on Adobe's website but I'm not finding anything.

Anybody have any ideas? This workbook based report runs every 2 hours. I
have to be able to create a PDF with its own filename that I assign to it
and save it to a specified directory.

I don't have the vbscript file I'm using to do the above with handy at the
moment. If anyone wants it, just let me know and I'll post it later.

Thanks all!

Chris Smith
Hello,

I do not know the vbscript for your task but, as an alternative, you can
save the spreadsheet as a picture!
How you may ask? see my Picture maker Utlity at:

www.geocities.com/excelmarksway

You could then insert the Sheet.gif into a web page and the Viewer need not
have to download the file to view in Adobe Reader.

- -Mark

quot;Who be dat?quot; wrote:

gt; Hello all!
gt;
gt; I'm using a VBScript file which I've added to Server 2003 scheduler to
gt; automatically open up Excel, load it with a workbook which is in turn
gt; populated with data, print it out, dynamically come up with a filename which
gt; is figured off of the current date and time which is then appended to the
gt; original filename of the workbook, save it in HTML format, then close
gt; itself. Works like a charm.
gt;
gt; I've decided I don't want to save the file in HTML format but would instead
gt; like to save it in PDF. The reason being is HTML files can modified by any
gt; with a text editor. PDF files are relatively permanent and secure which is
gt; what I need.
gt;
gt; I have Acrobat 6.0 Pro installed. I can use the print function, select
gt; Adobe PDF as the printer, a prompt comes up asking for a file name to save
gt; to, and it gets converted. At least when I do it manually it's like that.
gt; I thought I could figure out how to do it within VBScript easily. As it
gt; turns out, I'm freaking lost and have no idea how to do it. I was hoping
gt; some info would be on Adobe's website but I'm not finding anything.
gt;
gt; Anybody have any ideas? This workbook based report runs every 2 hours. I
gt; have to be able to create a PDF with its own filename that I assign to it
gt; and save it to a specified directory.
gt;
gt; I don't have the vbscript file I'm using to do the above with handy at the
gt; moment. If anyone wants it, just let me know and I'll post it later.
gt;
gt; Thanks all!
gt;
gt; Chris Smith
gt;
gt;
gt;

Hello, Just a note.
I think you need the PDF Addin then look in VB Editor Help for PDFquot;Who be dat?quot; wrote:

gt; Hello all!
gt;
gt; I'm using a VBScript file which I've added to Server 2003 scheduler to
gt; automatically open up Excel, load it with a workbook which is in turn
gt; populated with data, print it out, dynamically come up with a filename which
gt; is figured off of the current date and time which is then appended to the
gt; original filename of the workbook, save it in HTML format, then close
gt; itself. Works like a charm.
gt;
gt; I've decided I don't want to save the file in HTML format but would instead
gt; like to save it in PDF. The reason being is HTML files can modified by any
gt; with a text editor. PDF files are relatively permanent and secure which is
gt; what I need.
gt;
gt; I have Acrobat 6.0 Pro installed. I can use the print function, select
gt; Adobe PDF as the printer, a prompt comes up asking for a file name to save
gt; to, and it gets converted. At least when I do it manually it's like that.
gt; I thought I could figure out how to do it within VBScript easily. As it
gt; turns out, I'm freaking lost and have no idea how to do it. I was hoping
gt; some info would be on Adobe's website but I'm not finding anything.
gt;
gt; Anybody have any ideas? This workbook based report runs every 2 hours. I
gt; have to be able to create a PDF with its own filename that I assign to it
gt; and save it to a specified directory.
gt;
gt; I don't have the vbscript file I'm using to do the above with handy at the
gt; moment. If anyone wants it, just let me know and I'll post it later.
gt;
gt; Thanks all!
gt;
gt; Chris Smith
gt;
gt;
gt;

gt;gt; Hello all!
gt;gt;
gt;gt; I'm using a VBScript file which I've added to Server 2003 scheduler to
gt;gt; automatically open up Excel, load it with a workbook which is in turn
gt;gt; populated with data, print it out, dynamically come up with a filename
gt;gt; which
gt;gt; is figured off of the current date and time which is then appended to the
gt;gt; original filename of the workbook, save it in HTML format, then close
gt;gt; itself. Works like a charm.
gt;gt;
gt;gt; I've decided I don't want to save the file in HTML format but would
gt;gt; instead
gt;gt; like to save it in PDF. The reason being is HTML files can modified by
gt;gt; any
gt;gt; with a text editor. PDF files are relatively permanent and secure which
gt;gt; is
gt;gt; what I need.
gt;gt;
gt;gt; I have Acrobat 6.0 Pro installed. I can use the print function, select
gt;gt; Adobe PDF as the printer, a prompt comes up asking for a file name to
gt;gt; save
gt;gt; to, and it gets converted. At least when I do it manually it's like
gt;gt; that.
gt;gt; I thought I could figure out how to do it within VBScript easily. As it
gt;gt; turns out, I'm freaking lost and have no idea how to do it. I was hoping
gt;gt; some info would be on Adobe's website but I'm not finding anything.
gt;gt;
gt;gt; Anybody have any ideas? This workbook based report runs every 2 hours.
gt;gt; I
gt;gt; have to be able to create a PDF with its own filename that I assign to it
gt;gt; and save it to a specified directory.
gt;gt;
gt;gt; I don't have the vbscript file I'm using to do the above with handy at
gt;gt; the
gt;gt; moment. If anyone wants it, just let me know and I'll post it later.
gt;gt;
gt;gt; Thanks all!
gt;gt;
gt;gt; Chris SmithI believe that the Adobe PDF quot;printerquot; has an option to automatically print
to XXX.pdf where xxx is the workbook name. I suggest:

1) generating the desired PDF name (sans extension)
2) saving the workbbok as ThatName.xls
3) Printing to the PDF (ThatName.pdf)
4) Resaving the workbook with its original name.
5) Deleting ThatName.xls.

--
Peter Aitken

Remove the crap from my email address before using.
I would be interested in talking a look at the vbasript file, perhaps
then i might be able to see what is going on.