vba

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » VBA

VBA

resolvedResolved · Low Priority · Version Standard

Mariagiulia has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel VBA Advanced course

VBA

Is there a way to record Codes in VBA and have access to those codes from any spreadsheets?

RE: VBA

Hi Mariagiulia

Yes there is.

You need to record the macros in the Personal Macro Workbook and then all you open Workbooks can see the code.

The Personal Macro Workbook is a hidden workbook which opens every time you open Excel.

Carlos


 

Excel tip:

Saving your Excel Spreadsheet as a CSV File

In situations where you need to save your Excel spreadsheet as a CSV file, follow these simple steps.

Click the File tab and click Save As.
Enter a name in the File name field.
Click the drop-down arrow next to the Save as type field to select the file type. Scroll down the list and select CSV (comma delimited) (*.CSV)
Click Save

The data will now be saved to a separate CSV file which can be used in different applications.

View all Excel hints and tips


Server loaded in 0.09 secs.