Error when trying to export macros

[bernatagulloesbrina]

Hello Stephen,

quite blown away by the coding you have put togeter!
As I try it though I'm getting the following error

---

You may only use the Microsoft .NET Core Debugger (vsdbg) with
Visual Studio Code, Visual Studio or Visual Studio for Mac software
to help you develop and test your applications.

The application to execute does not exist: 'C:/Users/maguires/.dotnet/tools/.store/dotnet-script/1.3.1/dotnet-script/1.3.1/tools/net6.0/any/dotnet-script.dll'
The target process exited without raising a CoreCLR started event. Ensure that the target process is configured to use .NET Core. This may be expected if the target process did not run on .NET Core.
The program '[44304] dotnet.exe' has exited with code -2147450751 (0x80008081).

looks like there's an absolute reference somewhere in the code -- any hint on how can I fix that?

regards!

[samaguire]

🤔 that's an old profile directory. That could be coming through the project file from when I originally did the setup. I'll have a look tomorrow; it may be a case of resting the environment. Regards Stephen Get Outlook for Android<https://aka.ms/ghei36>

…

________________________________ From: Bernat Agulló Roselló ***@***.***> Sent: Sunday, January 15, 2023 8:41:30 PM To: samaguire/TabularEditorScripts ***@***.***> Cc: Subscribed ***@***.***> Subject: [samaguire/TabularEditorScripts] Error when trying to export macros (Issue #38) Hello Stephen, quite blown away by the coding you have put togeter! As I try it though I'm getting the following error

________________________________ You may only use the Microsoft .NET Core Debugger (vsdbg) with Visual Studio Code, Visual Studio or Visual Studio for Mac software to help you develop and test your applications. The application to execute does not exist: 'C:/Users/maguires/.dotnet/tools/.store/dotnet-script/1.3.1/dotnet-script/1.3.1/tools/net6.0/any/dotnet-script.dll' The target process exited without raising a CoreCLR started event. Ensure that the target process is configured to use .NET Core. This may be expected if the target process did not run on .NET Core. The program '[44304] dotnet.exe' has exited with code -2147450751 (0x80008081). looks like there's an absolute reference somewhere in the code -- any hint on how can I fix that? regards! — Reply to this email directly, view it on GitHub<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fsamaguire%2FTabularEditorScripts%2Fissues%2F38&data=05%7C01%7C%7Cad4c0808cc5340113aa608daf6e5102e%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638093760923524482%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=BbVkGyslccJpspeFREceICUD7vskmehVFK6gwM1GKEw%3D&reserved=0>, or unsubscribe<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAO3PBAQGN6VYLSCX346YX63WSPH5VANCNFSM6AAAAAAT3ZKL7Y&data=05%7C01%7C%7Cad4c0808cc5340113aa608daf6e5102e%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638093760923524482%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Q0RvMA%2F6g4L7RzmaiE4fwoEq7T8o5zJSmjjHY3ywNaA%3D&reserved=0>. You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[samaguire]

Okay. So, it sounds like you're trying to run this using the debugger instead of the script runner. If you want to run in debugging mode, you'll need to issue the command dotnet script init in the terminal first. This will reset the launcher settings to suit your local setup.

[bernatagulloesbrina]

How should i do it with the script runner? El dom, 22 ene 2023 5:39, Stephen Maguire ***@***.***> escribió:

…

Okay. So, it sounds like you're trying to run this using the debugger instead of the script runner. If you want to run in debugging mode, you'll need to issue the command dotnet script init in the terminal first. This will reset the launcher settings to suit your local setup. — Reply to this email directly, view it on GitHub <#38 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AJUUXHJIXD73TVJQ7XM43TLWTS2ZVANCNFSM6AAAAAAT3ZKL7Y> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[samaguire]

When script runner is installed, it'll add a play button to the top right-hand corner near the exit button. I think they show it on their site if you click through links. Regards Stephen Get Outlook for Android<https://aka.ms/ghei36>

________________________________ From: Bernat Agulló Roselló ***@***.***> Sent: Sunday, January 22, 2023 9:34:30 PM To: samaguire/TabularEditorScripts ***@***.***> Cc: Stephen Maguire ***@***.***>; Comment ***@***.***> Subject: Re: [samaguire/TabularEditorScripts] Error when trying to export macros (Issue #38) How should i do it with the script runner? El dom, 22 ene 2023 5:39, Stephen Maguire ***@***.***> escribió:

Okay. So, it sounds like you're trying to run this using the debugger instead of the script runner. If you want to run in debugging mode, you'll need to issue the command dotnet script init in the terminal first. This will reset the launcher settings to suit your local setup. — Reply to this email directly, view it on GitHub <#38 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AJUUXHJIXD73TVJQ7XM43TLWTS2ZVANCNFSM6AAAAAAT3ZKL7Y> . You are receiving this because you authored the thread.Message ID: ***@***.***>

— Reply to this email directly, view it on GitHub<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fsamaguire%2FTabularEditorScripts%2Fissues%2F38%23issuecomment-1399430348&data=05%7C01%7C%7Cee467d51569a4b523b9408dafc537b8d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638099732728607667%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=PuRzyWQlepGAJxuZTvav4wgfmnqny2SxSwMkyuk097A%3D&reserved=0>, or unsubscribe<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAO3PBATYESSFWZLGWLRWB2DWTTWJNANCNFSM6AAAAAAT3ZKL7Y&data=05%7C01%7C%7Cee467d51569a4b523b9408dafc537b8d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638099732728607667%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=ihKDPtN%2Fv6OY0TDC41BnG5eiFUHaJog3CRDjc7Mh3v8%3D&reserved=0>. You are receiving this because you commented.Message ID: ***@***.***>

[bernatagulloesbrina]

I think I managed to execute it now but still not quite 'getting it'
A blog post/video walk through would be very much appreciated

At some point I'd like to test if it would be possible to automate copying the script followed by the custom class so that I can paste them in tabular editor in one go -- or update the macro files

[samaguire]

Sure, I'll look into that. I had thought about expanding the ReadMe on GitHub after you had asked. The trouble is I don't want to have maintain instructions based on other projects I don't control, but I see your point. I'm not really following what you mean regarding copy and pasting. You should be able to make your edits in VSCode then run the script to update the macros in TE. Just make sure TE is closed first to avoid any issues. Custom classes, I haven't tried that. I haven't had a need to use one yet. Are you talking about from a custom dll file? (Custom dll | Esbrina (esbrina-ba.com)<https://www.esbrina-ba.com/tag/custom-dll/>) If so, then you'll need to explicitly reference the dll in the script like so as well.  Alternatively, I believe you can have them defined inline in the script. But again, I haven't actually tried that. Regards Stephen From: Bernat Agulló Roselló ***@***.***> Sent: Sunday, January 22, 2023 10:56 PM To: samaguire/TabularEditorScripts ***@***.***> Cc: Stephen Maguire ***@***.***>; Comment ***@***.***> Subject: Re: [samaguire/TabularEditorScripts] Error when trying to export macros (Issue #38) I think I managed to execute it now but still not quite 'getting it' A blog post/video walk through would be very much appreciated At some point I'd like to test if it would be possible to automate copying the script followed by the custom class so that I can paste them in tabular editor in one go -- or update the macro files - Reply to this email directly, view it on GitHub<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fsamaguire%2FTabularEditorScripts%2Fissues%2F38%23issuecomment-1399443202&data=05%7C01%7C%7C6ae0c871a0564f75d57308dafc5eec96%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638099781867572966%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=4qlE2J1Eh9tvCzqst8lTWRyr9MQPNOxVV2DYyHgNc0E%3D&reserved=0>, or unsubscribe<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAO3PBAVSZ3GUIJFQBJ5EGQ3WTT74RANCNFSM6AAAAAAT3ZKL7Y&data=05%7C01%7C%7C6ae0c871a0564f75d57308dafc5eec96%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638099781867572966%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=%2BHbq8bNJv3RzrFYuK5Q7r2UKwe5WIyQS2ndisL7egSA%3D&reserved=0>. You are receiving this because you commented.Message ID: ***@***.******@***.***>>

[samaguire]

Adding the missing image from my email reply above.

[bernatagulloesbrina]

Hello Sam, I tried developing custom dll, but is a pain to develop and a pain to share with others. Now I favor to add the class as an in-script class as I show in this blog post https://www.esbrina-ba.com/how-to-write-a-c-script-for-tabular-editor-part-2-in-script-classes/ basically you can add the class at the end of the script and it works. However in Visual Studio they exist in different files so I need to pick some code from a fila and some content from another I'd love some way of coping the code from one function and the bit of the class that I need to copy (not all of it since it includes some auxiliary code to improve the coding experience) Regards! El mié, 25 ene 2023 a las 3:03, Stephen Maguire ***@***.***>) escribió:

…

Adding the missing image from my email reply above. [image: image] <https://user-images.githubusercontent.com/62320770/214464096-e46acf2e-d389-4f50-a39b-d18bf6faedce.png> — Reply to this email directly, view it on GitHub <#38 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AJUUXHNZTQKNUXGPBIU6TNTWUCCWRANCNFSM6AAAAAAT3ZKL7Y> . You are receiving this because you authored the thread.Message ID: ***@***.***>

-- Bernat Agulló Partner & Data Enthusiast ***@***.*** +34 637 93 42 76

[samaguire]

I think I get the use case now. BTW, it’s Stephen not Sam 😄 Rough specs * We have another folder “collection\classes” The scripts/macros in this folder could be added to the scripts/macros in the folder “collection\macros”. * ‘Classes’ would need to adhere to a structure, this could be the structure I’ve already setup for the ‘macros’ * Macros can be updated with the code from the classes by adding or updating * Classes within macros would have their own section at the end, much like the current ones for assemblies, name spaces, and class variables Since this is driven by .Net 6.0 I’m not sure if there is a quick way to prompt a user, i.e. call VB or WinForms dialogue box to select specific classes. However, I think it’d be a better experience to just inject all classes into the macros. This would be a secondary process after exporting from TE but could still be manually triggered. I’d look at selectively adding classes as a second piece of development, building on a generic inject all. Is this the sort of solution you were thinking of? Regards Stephen A. Maguire — Reply to this email directly, view it on GitHub<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fsamaguire%2FTabularEditorScripts%2Fissues%2F38%23issuecomment-1403679640&data=05%7C01%7C%7C6754b2b348db4a0d0b7308dafedda002%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638102525068385950%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=85cw%2Fc9poXDQy%2B5Y30HzPqAyTvUm1Kx3AINmKAAHlwE%3D&reserved=0>, or unsubscribe<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAO3PBATEE5XTX2UYAGEOPLDWUEXVRANCNFSM6AAAAAAT3ZKL7Y&data=05%7C01%7C%7C6754b2b348db4a0d0b7308dafedda002%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638102525068385950%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=waqL1jWdZDRUgzk8BBvfwo3xwwkrFviyuXXMa7UTkAA%3D&reserved=0>. You are receiving this because you commented.Message ID: ***@***.******@***.***>>

[bernatagulloesbrina]

Apologies! I tried to recall your name from your user and didn't go well (it was before my coffee, but no excuse) At this point I'm planning on a single huge class as it works basically as a custom function folder, so it could be added to all macros or only those that contain certain comment or something However the code of the class needs to be fixed to exclude all the aux methods and variables Regards! El mié, 25 ene 2023 21:47, Stephen Maguire ***@***.***> escribió:

…

I think I get the use case now. BTW, it’s Stephen not Sam 😄 Rough specs * We have another folder “collection\classes” The scripts/macros in this folder could be added to the scripts/macros in the folder “collection\macros”. * ‘Classes’ would need to adhere to a structure, this could be the structure I’ve already setup for the ‘macros’ * Macros can be updated with the code from the classes by adding or updating * Classes within macros would have their own section at the end, much like the current ones for assemblies, name spaces, and class variables Since this is driven by .Net 6.0 I’m not sure if there is a quick way to prompt a user, i.e. call VB or WinForms dialogue box to select specific classes. However, I think it’d be a better experience to just inject all classes into the macros. This would be a secondary process after exporting from TE but could still be manually triggered. I’d look at selectively adding classes as a second piece of development, building on a generic inject all. Is this the sort of solution you were thinking of? Regards Stephen A. Maguire — Reply to this email directly, view it on GitHub< https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fsamaguire%2FTabularEditorScripts%2Fissues%2F38%23issuecomment-1403679640&data=05%7C01%7C%7C6754b2b348db4a0d0b7308dafedda002%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638102525068385950%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=85cw%2Fc9poXDQy%2B5Y30HzPqAyTvUm1Kx3AINmKAAHlwE%3D&reserved=0>, or unsubscribe< https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAO3PBATEE5XTX2UYAGEOPLDWUEXVRANCNFSM6AAAAAAT3ZKL7Y&data=05%7C01%7C%7C6754b2b348db4a0d0b7308dafedda002%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638102525068385950%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=waqL1jWdZDRUgzk8BBvfwo3xwwkrFviyuXXMa7UTkAA%3D&reserved=0>. You are receiving this because you commented.Message ID: ***@***.******@***.***>> — Reply to this email directly, view it on GitHub <#38 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AJUUXHJOEOXAMGA2RDN5CV3WUGGNFANCNFSM6AAAAAAT3ZKL7Y> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[samaguire]

Don’t beat yourself up – I’m not offended. If it’s just the one script file, then it should be straight forward. Do you mind posting an example script for me to work with. I’ll do this change to your requirements 👌 Regards Stephen — Reply to this email directly, view it on GitHub<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fsamaguire%2FTabularEditorScripts%2Fissues%2F38%23issuecomment-1404209609&data=05%7C01%7C%7C3010a8b6a459413eb84908daff162f56%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638102767996394019%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=3%2BDZaiw4y8HJcGauI5kKFL0%2F7Yr4xVlkohBhpsRstvQ%3D&reserved=0>, or unsubscribe<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAO3PBATB4I2AICNABSSBDUDWUGHD3ANCNFSM6AAAAAAT3ZKL7Y&data=05%7C01%7C%7C3010a8b6a459413eb84908daff162f56%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638102767996394019%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=mG5dNJ16G4blXikkYCsDKLvcWyrVlq2a6dhPup1kK4g%3D&reserved=0>. You are receiving this because you commented.Message ID: ***@***.******@***.***>>

[bernatagulloesbrina]

Sure thing!
This is the repo I'm using
https://github.com/bernatagulloesbrina/TE-Scripting-with-Scripts

each method of https://github.com/bernatagulloesbrina/TE-Scripting-with-Scripts/blob/main/TE%20Scripts/TE_Scripts.cs would be a script/macro. The first one is the time calc script which does not require macros, but the second one " createMeasureFromCalcGroupWithFieldParameter" starting at line 896 aprox does require the custom class copied at the end

the class is defined in https://github.com/bernatagulloesbrina/TE-Scripting-with-Scripts/blob/main/GeneralFunctions/GeneralFunctions.cs
each time I copy the scritp I need to come here and also copy from line 21 up until 310 ending with the //} and then remove the the // so that the curly bracket closes the class

if there's a way to automate that it would be great

I would love if the two bits could be combined and put into the clipboard so I could paste it in the c# script tab in tabular editor, because even with VStudio sometimes there are bits that do not work well, and I would get more info this way. I think Tabular Editor does not even load any macro if any of them has any little problem

Regards!

[samaguire]

Cheers. I’ll have a look through that and pull something together. Yes, TE/TE3 is not forgiving about what it deems as issues with the scripts. 😔 Regards Stephen From: Bernat Agulló Roselló ***@***.***> Sent: Thursday, January 26, 2023 10:10 AM To: samaguire/TabularEditorScripts ***@***.***> Cc: Stephen Maguire ***@***.***>; Comment ***@***.***> Subject: Re: [samaguire/TabularEditorScripts] Error when trying to export macros (Issue #38) Sure thing! This is the repo I'm using https://github.com/bernatagulloesbrina/TE-Scripting-with-Scripts<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fbernatagulloesbrina%2FTE-Scripting-with-Scripts&data=05%7C01%7C%7C0b161ea13bf44ac494d308daff187933%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638102777821549043%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=ZMkId2mSt%2FKhnhvvIgOhC1gZPtKCbie4%2BilVHYZAmow%3D&reserved=0> each method of https://github.com/bernatagulloesbrina/TE-Scripting-with-Scripts/blob/main/TE%20Scripts/TE_Scripts.cs<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fbernatagulloesbrina%2FTE-Scripting-with-Scripts%2Fblob%2Fmain%2FTE%2520Scripts%2FTE_Scripts.cs&data=05%7C01%7C%7C0b161ea13bf44ac494d308daff187933%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638102777821549043%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=jjYnDnqAgOLOD7nksuldomZATgtYQCGb0g%2FTayYlG2w%3D&reserved=0> would be a script/macro. The first one is the time calc script which does not require macros, but the second one " createMeasureFromCalcGroupWithFieldParameter" starting at line 896 aprox does require the custom class copied at the end the class is defined in https://github.com/bernatagulloesbrina/TE-Scripting-with-Scripts/blob/main/GeneralFunctions/GeneralFunctions.cs<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fbernatagulloesbrina%2FTE-Scripting-with-Scripts%2Fblob%2Fmain%2FGeneralFunctions%2FGeneralFunctions.cs&data=05%7C01%7C%7C0b161ea13bf44ac494d308daff187933%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638102777821549043%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=C78RpKWnaNazizIjQBToZ%2FMUJP3okwE6qt%2BObBuU7ig%3D&reserved=0> each time I copy the scritp I need to come here and also copy from line 21 up until 310 ending with the //} and then remove the the // so that the curly bracket closes the class if there's a way to automate that it would be great I would love if the two bits could be combined and put into the clipboard so I could paste it in the c# script tab in tabular editor, because even with VStudio sometimes there are bits that do not work well, and I would get more info this way. I think Tabular Editor does not even load any macro if any of them has any little problem Regards! — Reply to this email directly, view it on GitHub<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fsamaguire%2FTabularEditorScripts%2Fissues%2F38%23issuecomment-1404226787&data=05%7C01%7C%7C0b161ea13bf44ac494d308daff187933%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638102777821549043%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=42C%2BTr985th9EZ0qFTsZT63Qu9gLJnSUJSl6K%2B84ZGw%3D&reserved=0>, or unsubscribe<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAO3PBARMJPZ3OIFVP5JEOEDWUGJBHANCNFSM6AAAAAAT3ZKL7Y&data=05%7C01%7C%7C0b161ea13bf44ac494d308daff187933%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638102777821705256%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=YtkQ2vK%2BoxvZ17l9PRjODgWAAekZu9N8wsAJkYPTtI0%3D&reserved=0>. You are receiving this because you commented.Message ID: ***@***.******@***.***>>

[samaguire]

@bernatagulloesbrina So I thought a nice solution to this could be to use the #load directive to load the classes from a script file. But it's not supported in TE2 and partially supported in TE3 😔

The loaded script does work in TE3 but has no intellisense so makes it hard to use within TE3. You'd could bug daniel to get better support?

Everything works perfectly in VSCode though. 😁

So, moving forward with this I'm going to have to append the full code to the bottom of the relevant scripts, which is messy when referencing other assemblies, and I think the cleanest solution would be to reference a script file as it automatically loads the required assemblies referenced in the file (i.e. #r "Microsoft.VisualBasic").

TE2

TE3

VSCode