Export an excel range to pdf or word?
Hey, I need to export a certain cell range from an excel file into a word document or pdf file. The range can be exported as a picture or anything like that as long as size and format remain the same. Im pretty sure this needs to be done with VB, but i have no knowledge of VB at all. Please help!
I know that I can just copy/paste into word, but I would like to place a button or something of that nature on the spreadsheet that would export a specific range to a file when you click it. It would be great if this file would just be created on the desktop but I am open to all suggestions.
Thanks!
Let me know if further explanations are needed.
Re: Export an excel range to pdf or word?
if you record a macro doing the copy and paste to word, and saving to the desktop you will be able to assign this macro to a button.
if you use
VB Code:
Application.ScreenUpdating = False
the user wont see the copy paste and save procedure
be sure to set it back to true once the process is complete.
HTH
Re: Export an excel range to pdf or word?
I actually found some VB code that works really well so Im using that, but thanks anyway.