C
CST
We have custom VBA in the xls files that do subtotaling and other
functions on open of the workbook. The issue is that we need to print
these xls files to pdf without having excel on the server.
Is there a tool out there that will print the xls file (after all vba
functions are completed) to pdf? Or will the file need to be opened
by Excel and then printed to pdf using the PrintOut method? This is
not an ideal solution! Server side automation of MS Office products
is not the best solution and is not even supported by MS.
Again, my concern is that the file will be converted to pdf w/o having
any of the vba code executed. The final output (in pdf) should look
exactly like it does when opened in Excel (after VBA code executes).
TIA
functions on open of the workbook. The issue is that we need to print
these xls files to pdf without having excel on the server.
Is there a tool out there that will print the xls file (after all vba
functions are completed) to pdf? Or will the file need to be opened
by Excel and then printed to pdf using the PrintOut method? This is
not an ideal solution! Server side automation of MS Office products
is not the best solution and is not even supported by MS.
Again, my concern is that the file will be converted to pdf w/o having
any of the vba code executed. The final output (in pdf) should look
exactly like it does when opened in Excel (after VBA code executes).
TIA