Converting Excel file to word or pdf

[TheConeHead]

Does anyone know if there is a way to convert an excel file to word or pdf?

 

[eyec]

Google a program called PDFCreator (free).

 

[mandara]

Look at this, it works fine for me:

Export Excel Table to Word
Put this into an Excel module:

VBA:

Sub PushSelectionToWord() 
    Dim wdApp As Object 
    Set wdApp = GetObject(, "Word.Application") 
    Selection.Copy 
    wdApp.Selection.Paste 
    Set wdApp = Nothing 
End Sub

Go back to Excel, select the range of cells you want to send over, and run the macro.

It will create a table in Word of the cells you selected.

It is not mine: see the original site, please

http://www.vbaexpress.com/forum/showthread.php?t=6699&highlight=PushSelectionToWord

 

[Madawc]

Cut-and-paste to Word gives you a Word table.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[rodesh]

If your purpose to display data only, you can save as excel file in a web page which only display data not formula. if open this web page in Internet Explorer there will be an option to edit data (not formula) in excel.

 

[KenPuls]

If you are more interested in the PDF route, I'll throw in a second vote for PDF Creator. It's an awesome little free application that works very well. It also exposes its classes to VBA, so that you can code it as well, as I show here:

http://www.excelguru.ca/node/21

Ken Puls, CMA

http://www.excelguru.ca