question

HuThomas-8417 avatar image
0 Votes"
HuThomas-8417 asked VikiJi-MSFT commented

Macro from excel 2010 running in O365 excel

Dear Tech,

We met an "unknow error" message when executing Excel 2010 macro in O365 macro, application did not provide any error code or logs for us to troubleshot, so could you please provide knowledge on similar issue? is it a syntax problem or capability issue between o365 excel and excel 2010, and how can we resolve this issue?

Looking forward to your reply, thanks.

office-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

VikiJi-MSFT avatar image
0 Votes"
VikiJi-MSFT answered VikiJi-MSFT commented

Hi @HuThomas-8417,
Welcome to Q&A forum!

Does this issue occur with all macros in Excel 2010 files, or only on specific macros?
I suggest you create a blank Excel 2010 file, and add a simple macro such as copy and paste for testing.
The above test can help us determine whether the problem is the Excel application or the macro itself.

  • If only special macros have the issue, please check and make sure the file extension is .xlsm.
    Besides, how did you import the macros into Excel 365?
    To import correctly, please open Visual Basic, right-click in the Project Window and select Import File.

If the issue persists, the issue may be in the macro itself. Since I am not a macro expert, I suggest you refer to the following page to post a new question and provide detailed macro codes for professional help. Thanks for your understanding.
Office developer community

For references:
Excel 2016 macro written in Excel 2010 not working
Macros don't compile in Excel 2016 after import from 2010
Please note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

Any updates, please let me know.


If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @HuThomas-8417,
If you have a chance to review this thread, please check if my reply is helpful.
Thanks!

0 Votes 0 ·