PDA

View Full Version : Sleeper: Link Excel to pdf



hobgoblin
08-04-2005, 08:46 AM
I'm not sure if this is the right forum to post in, but anyway.

What im trying to do is to create a pdf file from Excel data, that when i update the Excel file the pdf updates automatically.

Can any1 help me on how to do this? :help

Bob Phillips
08-04-2005, 08:53 AM
Ther is info on printing to pdf at http://www.mvps.org/dmcritchie/excel/pdf.htm

Maybe you could use the BeforClose event to write it out.

hobgoblin
08-04-2005, 11:02 AM
I was probably not clear enough.:think: I need to export FROM Excel to pdf while preserving the data linkage, not convert from pdf to excel.

Any ideas ? Tnx for reply though.