- Home /
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
Answer by Ybotic-Software · Oct 20, 2021 at 05:16 AM
@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.
Your answer
![](https://koobas.hobune.stream/wayback/20220613044403im_/https://answers.unity.com/themes/thub/images/avi.jpg)
Follow this Question
Related Questions
Can Unity help me make a stock market App for android using Excel spreadsheets for data 1 Answer
List export to Word or Excel 2 Answers
How to import data into Microsoft Excel? 1 Answer
I am trying to use EPplus library with Unity 2019.1, i am getting the error. pl. help to resolve 0 Answers
Export data to excel in unity 3 Answers