Accessing Excel Macros from VB.Net

G

Guest

Hi, We are trying to automate an application that consumes excel sheets, gets
fed into a couple of excel templates and generates new excel sheets based on
the data and the macros on the templates.

We are willing to use VSOT (Office Tools from Visual Studio), do you think
this is a good idea? Can I access Excel Macros from VB.Net? Or is there a way
I can automate this whole process?
 
N

NickHK

There are some posts here from people using various .Net products (seems
mainly C#) to automate Excel. Whilst it does not appear as straight forward
as say from VB5/6, others accomplish it.
AFAIK, any user of such a app would require the compatible Framework,
possible OWC and a few other system components to make it all work, so
ensure you install all these with your app.

Note: I don't use .Net, this is just what I've picked from seeing how much
complex it is compared to automation from VB Classic.

NickHK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VB.NET with Excel VBA 3
Making sure the user is able to run macros 1
Documentation on programming Excel from Vis. Studio StandardEdition. 2
WEIRD - Excel is Changing the name of my macro 1
Why is Excel 2003 changing the names of my macros?? 1
Do I need DLL or COM Addin, Excel Addin 1
Working with Excel via Visual Studio 2008 2
Calling excel-macros from script? 5

Top