I have Excel 2003 and Acrobat Professional 6. I'm trying to automate saving the current worksheet to a distincly-named PDF file. Easy enough using File->Print and choosing Adobe PDF as the printer ...

Automate Excel Headers and Footers Using VBA Automating headers and footers in Excel can save you significant time, especially when working with large workbooks containing multiple sheets.

While Excel boasts over 450+ functions, sometimes they just donâ t cut it. These built-in functions fall short when you want to automate specific tasks or perform unique calculations in your ...

The bare bones VBA code A simple list of sheet names is easy to generate using VBA thanks to the Worksheets collection. Listing A shows a simple For Each loop that cycles through this collection.

If you have users who prefer to push Excel data into Outlook instead of importing it from inside Outlook, try this VBA event procedure.