Updating a macro that doesnt work on the newest excel

[esb128]

Hello

I have a macro that was made to work on 97-2003 excel, i need to get it updated to work on the most recent version of excel. Is there a service someone offers to update it for me?

 

[Joe4]

Most VBA code written in older versions of Excel will work just fine on newer versions of Excel. Only a few things have been deprecated over the years (i.e. like some file browsing options).
So most of the time, you shouldn't have to do anything special to run them, unless maybe you used some special coding libraries.
If you did use special coding libraries, those errors can usually be fixed pretty easily by simply selecting the most recent version of that coding library under "References" in the VB Editor.

Have you tried running the code in your current version to see if it works, or has any errors?

 

[Peter_SSs]

I have a macro that was made to work on 97-2003 excel, i need to get it updated to work on the most recent version of excel.

Perhaps you could post the macro so helpers could consider if they can help or not?

 

[esb128]

Most VBA code written in older versions of Excel will work just fine on newer versions of Excel. Only a few things have been deprecated over the years (i.e. like some file browsing options).
So most of the time, you shouldn't have to do anything special to run them, unless maybe you used some special coding libraries.
If you did use special coding libraries, those errors can usually be fixed pretty easily by simply selecting the most recent version of that coding library under "References" in the VB Editor.

Have you tried running the code in your current version to see if it works, or has any errors?

Hi so the original script was created in an older excel version, normally i used to drag that excel file into a current open excel file and then could run it, right now when i drag it in, in the new excel it just does nothing, nor can i open that old file