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?
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?
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.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
I was probably not clear enough. 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.