Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: need excel vba help wtith making pdf files

28 Dec 2010   #11
nailgunner

Windows 7 Home Premium 64 bit
 
 

I did read the original question, so this is for the others who might be reading the posts.

There is another option. If you have the drive space for the program, Open Office has a nice tab that will quickly convert and save an Excel file as a PDF. Done it a few times and it takes about 5 seconds.


My System SpecsSystem Spec
.
29 Dec 2010   #12
Irene

Windows 7 Home Premium 64bit
 
 

I cannot see the reason to use VBA at all.

Save the spreadsheet as a PDF file, by selecting from the drop-down menu.
Open the pdf file and select the printer.

Am I really missing something here?
.
.


Attached Images
need excel vba help wtith making pdf files-excel-pdf-save-1.jpg need excel vba help wtith making pdf files-excel-pdf-save-.jpg need excel vba help wtith making pdf files-excel-pdf-save-2.jpg 
My System SpecsSystem Spec
29 Dec 2010   #13
mikedl

Windows 7 Ultimate x64 SP1
 
 

Hi, Irene. I do it to save steps. One chunk of VBA code converts it to a PDF, saves it to a file, prints it and prepares a blank email with the file attached.
My System SpecsSystem Spec
.

29 Dec 2010   #14
Irene

Windows 7 Home Premium 64bit
 
 

Quote   Quote: Originally Posted by mikedl View Post
Hi, Irene. I do it to save steps. One chunk of VBA code converts it to a PDF, saves it to a file, prints it and prepares a blank email with the file attached.
Thanks for the explanation, Mike. I was beginning to think I was losing it.

At my time in life, the pressure for speed is significantly reduced.
Still, it's good to learn something new every day - and I certainly do on this forum.
My System SpecsSystem Spec
Reply

 need excel vba help wtith making pdf files




Thread Tools




Similar help and support threads
Thread Forum
Excel files are not opening
I love the new taskbar and the "right click" on a pinned programme to access recent files & pinned files. However, while this feature works perfectly for Word, when I try to open an excel file from the taskbar, or even as an attachment to a received e-mail, I get the message " there was a problem...
Microsoft Office
Thumbnails on Excel files
Hi, On the open dialog box of Excel 2010 file, when browsing the files, I found these ones. But as you see, some ones have the thumbnails and some not. Why please? And how to have all with thumbnails?
Microsoft Office
My excel files can't open
My excel files can't open it shows a message 'hot key 1 not working' what it means..? :(
Microsoft Office
Files won't open once associated with Excel
I have a friend who has Windows 7 and Office 2007. He needs to open tab-delimited files that are saved in the .dat format. He's wants to open them in Excel 2007. We set up Excel as the default program (we had to manually browse to excel.exe. I also tried excelconv.exe). However,...
Microsoft Office
can't open (excel) files
Hi All ... When I am in Explorer and My Documents and I try to double click open an Excel file (Office 2003), I get the error message: "There was a problem sending the command to the program." However, if I try to similarly open a Word, or .PDF, or .TXT file in a similar manner, there is no...
Microsoft Office
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 03:36.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App