Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Currently I have a macro that selects sheet 3 of my workbook, copies it, and
saves it as a new workbook in a seperate folder. What I want is for it to save sheet 3 as a .pdf file instead of .xls The code I have right now to save sheet 3 is as follows. Sheets("Sheet3").Copy Range("B13").Select Sheets("Sheet3").SaveAs Filename:="blaahblaahfolder" & _ Range("B15").Value & ".xls" ActiveWorkbook.Close I was thinking easy so I changed it to Sheets("Sheet3").Copy Range("B13").Select Sheets("Sheet3").SaveAs Filename:="blaahblaahfolder" & _ Range("B15").Value & ".pdf" ActiveWorkbook.Close I run the macro and it does run cleanly but when I go into the "blaahblaahfolder" to open up the file I get an error message and am unable to open the file. Any help would be most appreciated. Thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automaticly saving formula's to values when saving | Excel Discussion (Misc queries) | |||
VBA not saving! | Excel Discussion (Misc queries) | |||
Saving | Excel Discussion (Misc queries) | |||
Saving | Excel Programming | |||
Saving a Workbook: Forcing User to Rename before Saving | Excel Programming |