Change MS Excel Worksheet To PDF Format Using Access VBA
Posted on 2011-03-21
I am writing an Access database where I have to program a module in VBA to convert an MS Excel Worksheet into a PDF Format and save it.
I have searched EE and I have obtained various sporadic results with many variations and possibilities including references which is quite confusing.
I guess what I am looking for is a straight link where I can download the reference dll's and/or object files and clean VBA code to change an Excel Worksheet into PDF Format.
All help and pointers are highly appreciated.