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 ...

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.

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.