Hi there,

I am just so frustrated now. I have been trying now for a month to control excel from VB.Net. However I cannot get the neccessary methods i want to run into vb.net.

For example, I can record a macro in excel and I understand the VBA script. But I cannot seem to even use it in VB.net.

I understand that I have to add the COM reference and i have done all that.

I really need a book or a website which is able to teach me some VB.net which can allow me to understand the interaction between VB.Net and Excel alot better. Perhaps even a list of commands which i can use. Right now it is just trial and error, taking up loads and loads of time.

I have found a article on the microsoft site saying that i can add VBA macros into excel and run it. But i am sure VB.net is powerful enough to control excel.....

If you could direct me to a book/source of information. I would be most most Grateful !

THANKS !

You can't do what your trying to do. You have wasted a month.

"converting" a recorded macro is just not going to work. You will need to write this in vb.net. The macro language of VBA isn't compatible with VB.NET.


EDIT: you should keep in mind that Excel, like all of MS Office, are *NOT* made to be automated against (well, Office 2003 can do it). Using an older version this way is asking for difficulty. Make sure you are doing it on a machine with O2k3

Hal Levy
I am here to help you, not do it for you.

I know it isn't compatible,

But i cannot find the equivalent function of what i want to do in excel using VB.Net.

And what function do you want to do in excel?


Hal Levy
I am here to help you, not do it for you.

I have office 2003, I want to be able to open an excel document. I was able to open excel through the snippet you posted. I also checked out the website that was listed in this forum listing, but had no luck with my problem. Please help as much as you can.

Thank you,
tankd