Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can an Excel macro be converted into a VBdotnet Windows application?
Can an Excel macro be converted into a VBdotnet Windows
application? Thanks in advance, Mirsten Choiple |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can an Excel macro be converted into a VBdotnet Windows application?
Indirectly yes, providing you're talking about just automating Excel (think
of it as remote controlling Excel). If you want to start from scratch and simulate a spreadsheet environment without Excel being on the PC itself then this will prove extremelly difficult. The macro code itself will have a direct equievlent in VB.NET. That's the easy part. What you'll need to do will involve driving Excel (using VB.NET) through automation. I may be wrong but the fact you are asking this question suggests you do not have the knowledge (just now) to make this work. With that in mind you'll need to look for information on automating Excel through VB & COM. .NET adds something new to the mix but I'll ignore that for the moment. Check back at my site in a few days and I'll stick up an article on this as a few people have asked me the same thing now. -- Regards, Bill Lunney www.billlunney.com "Mirsten Choiple" wrote in message ... Can an Excel macro be converted into a VBdotnet Windows application? Thanks in advance, Mirsten Choiple |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can an Excel macro be converted into a VBdotnet Windows application?
"Mirsten Choiple" wrote in message ... Can an Excel macro be converted into a VBdotnet Windows application? Thanks in advance, Mirsten Choiple The routines - yes The code modules can be largely just imported but you should note there are some changes between VBA and ..Net For example there are no variants in .net and the handling of arrays is somewhat different. Importing forms is also possible but you are better off rebuilding them using the .net tools. The actual Spreadsheet functionallity still requires Excel you can build a compiled .net addin to replace the VBA routines. Keith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running a macro from windows application | Excel Discussion (Misc queries) | |||
can i record a macro from excel to invvoke another windows application | Excel Discussion (Misc queries) | |||
Windows application error message | Excel Discussion (Misc queries) | |||
separate application windows | Excel Discussion (Misc queries) | |||
How to keep userform always on the top of all windows application | Excel Discussion (Misc queries) |