Forum Discussion

huskereurocat's avatar
huskereurocat
Copper Contributor
Jul 11, 2023

Using Personal Workbook Macro in Excel online?

I'm just trying to see if this functionality is even possible in Excel on the web. I have Excel and have created a personal.xlsb file that opens each time I open excel on my PC, but I have a friend that has the web version of Office and I'm wondering if there is a way he can use it as well.  

excel
Excel for web
Macros and VBA
  • H2O's avatar
    H2O
    Iron Contributor
    Jul 11, 2023
    No, it is not possible to use a personal workbook macro in Excel online. Excel online does not support VBA macros, which is the type of macro that is stored in a personal workbook. However, you can open and edit workbooks that contain macros in Excel online, but the macros will not run. To use macros in Excel online, you would need to open the workbook in the Excel desktop app.
    Alternatively, you could use Office Scripts, which are JavaScript-based scripts that can automate tasks in Excel for the web. Office Scripts can be recorded or written in the Code Editor, and run from the Automate tab. Office Scripts can also be shared with other users.
    Here are the steps on how to use Office Scripts in Excel online:
    1. Open the workbook in Excel online.
    2. Click on the Automate tab.
    3. Click on the Record button to start recording a new Office Script.
    4. Perform the actions that you want to automate.
    5. Click on the Stop button to stop recording.
    6. The Office Script will be saved in the workbook.
    7. To run the Office Script, click on the Run button.
    I hope this helps.
    • huskereurocat's avatar
      huskereurocat
      Copper Contributor
      Jul 11, 2023
      I'm confused. How do I open my personal.xlsb in Excel online? I'm only seeing workbooks that I have created in Excel online and are now saved to One Drive.
      • H2O's avatar
        H2O
        Iron Contributor
        Jul 11, 2023
        To open a personal workbook in Excel online, the user needs to upload it to OneDrive. A personal workbook is usually stored in a folder called XLSTART on the user's computer. To access it from Excel online, the user needs to upload it to OneDrive and then open it from there. However, the macros in the personal workbook will not run in Excel online.
        There are online tools that can open XLSB files .XLSB files are binary files that store Excel workbooks, including personal workbooks. There are some online tools that can open XLSB files for free, such as Aspose.Cells Excel Viewer. However, these tools may not support all the features or functions of Excel, and the macros in the personal workbook may not run either. Open XLSB Online for Free - Aspose. https://products.aspose.app/cells/viewer/xlsb.

Resources