Excel 2016 Macro not converting properly RRS feed

  • Question

  • Hi,

    I have a macro that imports .rpt file and in excel file. It worked fine in Excel 2010, but in Excel 2016, although it imports the data but the data is pasted in one column. I have to manually use text to columns to properly format the data. Is it possible to have the functionality restored in Excel 2016 as well?

    Any assistance would be appreciated!


    Wednesday, June 24, 2020 2:12 AM

All replies

  • Hi,

    Considering the issue is mainly related to macro, to help you resolve the issue better, I will move the thread to Excel for Developers. You may get more helpful replies there. Thanks for your kind understanding.

    If conditions permit, you may upload the related macro codes in this thread, it is convenient for for other partners who read the thread to further analyze and test your issue.



    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

    Wednesday, June 24, 2020 7:39 AM