Share via

Copy a Macro to Another PC

Anonymous
2017-04-19T06:48:48+00:00

Hi Everyone, 

I have created a macro in excel on my pc. This macro applies a specific format to the active workbook and then saves it as a CSV file.

I need others in my team to be able to run the same Macro. The macro is stored in my personal workbook. 

Is it as easy as exporting the VBA code and loading it on their machine? Am I missing something here? Can i copy my personal workbook to their PC?

Thanks in advance.

Dan

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2017-04-19T09:04:53+00:00

    Hi Dan,

    Based on your description, you can follow the steps below to export and import a macro.

    1. Open the workbook that contains the code you want to export.
    2. Press Alt+F11。
    3. Right-click on macro in the Project Explorer.
    4. Select Export File.
    5. Navigate to the folder where you want to save your macro.
    6. Give the file a name and click Save.

    To import the macro into another computer, follow these steps:

    1. Open the workbook that contains the code for your new application.
    2. Press Alt+F11.
    3. Right-click the project name in the Project-VBA Project window.
    4. Select Import File.
    5. Navigate to the file you want to import.
    6. Click Open.

    Regards,

    Tisky

    20+ people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-04-21T10:16:51+00:00

    Hi Dan,

    Any update?

    Regards,

    Tisky

    0 comments