Forum Discussion

leverage's avatar
leverage
Copper Contributor
Jan 29, 2021
Solved

Excel macro not working after Windows update - Office 365

After a recent windows update, a previous Excel vba script that was working, no longer functions correctly. The macro operation, when working, opens a csv file that is defined in the active workbook...
developer
excel
Macros and VBA
office 365
  • leverage's avatar
    leverage
    Feb 01, 2021

    Issue resolved after lots of searching on stackoverflow.

     

    It seems that between Excel V1902 and V2002 a hidden variable _xlfn.SINGLE exists in the workbook. When the macro loops through, it sees the named range, cannot resolve its address or sheet location and stops. The hidden variable was only possible to see after running an additional macro to display hidden named ranges.

     

    The fix was to include a loop to skip the named variable _xlfn* if found. Full detail and solution available on https://stackoverflow.com/questions/65947254/excel-macro-not-working-after-windows-update-office-365/65985711#65985711 

     

leverage's avatar
leverage
Copper Contributor
Feb 01, 2021

Issue resolved after lots of searching on stackoverflow.

 

It seems that between Excel V1902 and V2002 a hidden variable _xlfn.SINGLE exists in the workbook. When the macro loops through, it sees the named range, cannot resolve its address or sheet location and stops. The hidden variable was only possible to see after running an additional macro to display hidden named ranges.

 

The fix was to include a loop to skip the named variable _xlfn* if found. Full detail and solution available on https://stackoverflow.com/questions/65947254/excel-macro-not-working-after-windows-update-office-365/65985711#65985711 

 

Resources