Hi All,
Can anyone help me translate this Macro which is in excel to be utilized within Goggle Sheet ?
Please Login or Register to view this content.
Hi All,
Can anyone help me translate this Macro which is in excel to be utilized within Goggle Sheet ?
Please Login or Register to view this content.
Last edited by ctguards1987; 08-05-2022 at 10:51 AM.
Excel macros are based on VBA, Google Sheets macros are built in Apps Scripts which are based on RE2 Javascript... in other words they are completely different languages and cannot be converted in the way you might think is possible.
You will need to have the script completely rewritten, and for that to happen you will need to:
- give Editor access to a copy of your file
- ensure the sample file has EXACTLY the same structure and sample data as would be in the original.
- give thorough explanation of what you need the script to do
- accept that although it is possible to replicate the overall functionality, it doesnt mean the app script will behave exactly same, AND some things are not possible to do the same
- accept that you cannot convert apps script back to excel VBA
As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.
And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks