Export an excel range to pdf or word?

[jritter]

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.

[Br1an_g]

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

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

[jritter]

I actually found some VB code that works really well so Im using that, but thanks anyway.