Using VBA macro at Unity

How Can I run the macro in excel xlsm sheet.
for example, The Excel Sheet file name is WorkBook.xlsm, module name is module_A and Macro Name is macro_A

I Want Run “macro_A” but I cant Find source code.

please let me know about this

I just have Visual Code it means I can’t use visual studio

@june93729 - Lol - not sure if this is a joke but if you’re serious you can in fact quite easily convert VBA to VB.NET and from there you can either link to it like you would any other c# library. This would require at least rudimentry knowledge of C# as you’d need to call the library from a C# script. If you can’t even bear that then I wouldn’t suggest trying to get it working directly considering, even though it should be possible in theory (they’re both CLI languages - hence why they’re both referred to as C#.net and VB.net respectively). Knowing this, it’s no surprise that there exists plenty of VB.NET to C# converters already. One of them is bound to be free and open source (it’s not a big enough task that it warrants paying for) - I’d start my search on Github.

Something tells me you’re going to struggle with context if you only know VBA in an Excel context. I know VBA as I work in Finance so I can see already you’re not going to know how to call any “functions” or “subs” from Unity as you’ll be used to writing VBA in the context of a Worksheet or Workbook object.

If I were you, I’d read a beginner’s guide to C# and Unity. You can usually find it at one of those humble, yet fanatical, websites that like to sell eBooks (and Games ← just so you understand what I’m writing about in a “general” sense) in bundles. Note the rules probably prevent me from linking to or even naming the sites in question - it could be seen as advertising or spam - but a popular search engine would be your friend in this and no-doubt a googol other instances.