Web可以在任何Workbook對象上使用Path屬性，而不僅僅是ThisWorkbook對象。. 因此，要獲取ActiveWorkbook的路徑，可以使用ActiveWorkbook.Path 。. 或者，例如，如果您使用以 … Web1) Select the PERSONAL.XLS (b) in the project window and click on the + before it. 2) Then click on the + before Modules. 3) Double click on Module1 to open the code window on the right. 4) We copy/paste the example function in this module. 5) Now use Ctrl-s or File>Save in the VBA editor to save the PERSONAL.XLS (b).

vba - use one macro in different excel files - Stack Overflow

WebJul 28, 2024 · To insert standard module, right click on VBA project==>Insert==>Module. then paste code in newly created module. Sub Save1 () Application.DisplayAlerts = False ThisWorkbook.Save … WebMar 14, 2024 · What are Excel Personal Mapping Workbook? Personal Macro Workbook is a special file named Personal.xlsb in Excel 2007 – 2024 or Personal.xls in earlier versions. Any macros stored in this print are available to you whenever they start Excel. smith printing vidalia la

How to force users to save as a macro enabled workbook?

WebStep 1. Write the macro to be shared in an empty spreadsheet. Click the "View" tab on the ribbon menu. If you are going to record the macro, click the small arrow at the bottom of … WebHow The Macro Works Before you run the macro, select of sheet (s) that you want to export to which PDF file. Wenn and micro starts, it sets variables for the active sheet, and the active workbook. This will be used the set the default file name real folder. Set wbA = ActiveWorkbook Set wsA = ActiveSheet Web You are now done recording your macro. Close the Excel window, and you will be asked if you want to save the macro you just recorded to the Personal Macro... Click Save. river belle terrace fantasmic menu