Set Home| Set Favorite|

WPS Office Forum

 Forgot password?
 Register
Search
View: 1664|Reply: 1

Export to PDF using VBA

[ Promote this link! ]
Post time: 2013-11-12 10:45:49
| Show all posts |!read_mode!
Is there a facility to export spreadsheet document directly to PDF format through VBA. I tried running the sheet1.exportasfixedformat method but it is not supported. Any plans of supporting this method?
Thanks,
svk123
Reply

Use magic Report

Post time: 2014-11-20 14:47:31
| Show all posts
On VBA editor of Excel, go to Tools menu, References..., look down the list for "Microsoft word 12.0 Object library", check it, click ok, run the code again, you should be fine.
You have to log in before you can reply Login | Register

Points Rules

Dark room|Mobile|Archiver|WPS Office   

2019-08-18 02:09 GMT+8 , !processed_in! 0.079563 !seconds!, 16 !queries! .

Powered by Discuz! X3.2

Release 20151208, © 2001-2019 Comsenz Inc.

MultiLingual version, Rev. 469, © 2009-2019 codersclub.org

!fastreply! To Top !return_list!