After reading this Excel tutorial, you're ready to start creating macros for purposes of saving Excel files as PDF. This Excel VBA Save as PDF Tutorial is accompanied by files containing the data and macros I use in the examples above. You can get immediate free access to these example files by subscribing to the Power Spreadsheets Newsletter. I am not an expert in vba and with the forum guide created userform and works well. I want to save the userform in pdf with textbox file name which i am trying for.

The clipboard to BMP API's used in userform1 has a problem. It has a DLL entry point error for the SetClipboardData.

Since routines need to return LongPtr type, there is no point in using the VBA7 test. I attached the file in case someone has time to debug it. If you do test it and it errors, simply close Excel and reopen to fix the clipboard memory overload. For me, the API sendkeys method seems to 'work'.

I made it into a Function for you. Put this into a new Module. No check was made to see if the drive and path for the pdf filename is valid/exists. Debug.Print UserForm1.btnPrintPDF return a valid drive: path filename.pdf?

Link: Megadeth-Anthology.Set.The.World.Afire-2CD-2008-VAG.rar [258.08 Mb]. Is this as good as any of their older music? Anthology: Set The World Afire is loaded with 35 electrifying tracks, among them Megadeth's top hits, including. ARTIST: Megadeth TITLE: Anthology: Set The World Afire GENRE: Heavy Metal ENCODER: LAME 3.97 / -V2 --vbr-new QUALITY: 230 Set The World Afire 5:48 08. Into The Lungs Of Hell 3:22 09. Rapidshare.com/files/150250110/Megadeth-Anthology_2CD-2008.DREAM-TEAM.part2.rar http. Megadeth anthology. Discover releases, reviews, credits, songs, and more about Megadeth - Anthology: Set The World Afire at Discogs. Complete your Megadeth collection. Megadeth — Rattlehead (Anthology: Set The World Afire 2008). Megadeth — Angry Again (Anthology: Set The World Afire 2008). Uloz.to is the largest czech cloud storage. Upload, share, search and download for free. Credit allows you to download with unlimited speed.

Press Ctrl+G after a run to view the Immediate Window's results. I don't see how a btnPrintPDF could have a Value = to a pdf filename as it has no Value property. One could use Tag or Caption I guess. Tag would be the better property.

As I showed in the workbook and my last post, I used TextBox1 to store the pdf filename. It initially filled the value for the user.

Of course there are more advanced ways to let the user pick a filename to use. The purpose was to show how the Function was used. The function could be used for any ActiveWindow.