I've been asked at work to do a project that involves VBA for Excel, and I have had very little experience with either. I've had a moderate to high amount of programming experience in C++, Java ...

How to Program a "Save As" Button in Excel VBA. Offices and small businesses all over the world create countless numbers of Excel spreadsheets every day.

1. Open your Excel workbook containing the data to be formatted. 2. Access the Visual Basic for Applications (VBA) editor, typically by pressing Alt + F11. 3. Insert a new module in the VBA editor. 4.