Swiftslide
New Member
- Joined
- May 28, 2012
- Messages
- 8
Is it possible to use Visual Studio to write excel macros, and then import them into an .xlsm workbook? Or perhaps even have them imported automatically?
I don't think I want to use the excel interop functions, as these seem to manipulate the spreadsheet from outside excel. My workbooks are going to be passed around and the macros need to run like any other macros. I simply want to use Visual Studio because of its superiority to Excel's inbuilt editor. I would like the ability to, say, change function names automatically without using the find function.
I don't think I want to use the excel interop functions, as these seem to manipulate the spreadsheet from outside excel. My workbooks are going to be passed around and the macros need to run like any other macros. I simply want to use Visual Studio because of its superiority to Excel's inbuilt editor. I would like the ability to, say, change function names automatically without using the find function.
