471,582 Members | 1,397 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,582 software developers and data experts.

Excel/automation Gurus., please help... extract macros from excel and adding new macros into an excel sheet.

Hello Excel/automation Gurus,

I am working on an application where I have to keep a centralized
database of all macros distributed to user and save the changes back on
a nightly basis back to one central Excel macro repository.

What would you guys suggest me do?

Should I keep all macros in a centralized unique text file of some sort
or is it best to do with SQL server?

Does C# offer any features like extracting macros from excel and adding
new macros into an already existing excel sheet.

BTW, I'm using C#/Windows Forms/SQL Server 2000

I can use all the help I can get...

Thanks,

OhMyGaw!

Nov 17 '05 #1
3 2250
Here is half of the equation:

http://www.eggheadcafe.com/articles/..._in_dotnet.asp

--
2004 and 2005 Microsoft MVP C#
Robbe Morris
http://www.masterado.net

Earn $$$ money answering .NET Framework
messageboard posts at EggHeadCafe.com.
http://www.eggheadcafe.com/forums/merit.asp

"OhMyGaw" <oh*****@gmail.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...
Hello Excel/automation Gurus,

I am working on an application where I have to keep a centralized
database of all macros distributed to user and save the changes back on
a nightly basis back to one central Excel macro repository.

What would you guys suggest me do?

Should I keep all macros in a centralized unique text file of some sort
or is it best to do with SQL server?

Does C# offer any features like extracting macros from excel and adding
new macros into an already existing excel sheet.

BTW, I'm using C#/Windows Forms/SQL Server 2000

I can use all the help I can get...

Thanks,

OhMyGaw!

Nov 17 '05 #2
Robbe,

Thanks for the reply. I've tried that link and it works beautiful.

Now, how can I extract the already existing macros from an excel
workbook?

Thanks,

OhMyGaw

Nov 17 '05 #3
I've never needed to do that. I suggest looking at the intellisense
in the sample I provided and look at the module object
created here:

module =
wb.VBProject.VBComponents.Add(VBIDE.vbext_Componen tType.vbext_ct_StdModule);

take a look at the module.Collection and try iterating through it and see
what

you get.
--
Robbe Morris - 2004/2005 Microsoft MVP C#

Earn money answering .NET Framework
messageboard posts at EggHeadCafe.com.
http://www.eggheadcafe.com/forums/merit.asp

"OhMyGaw" <oh*****@gmail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...
Robbe,

Thanks for the reply. I've tried that link and it works beautiful.

Now, how can I extract the already existing macros from an excel
workbook?

Thanks,

OhMyGaw

Nov 17 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by Allison Bailey | last post: by
1 post views Thread by Steven Stewart | last post: by
1 post views Thread by Giganews | last post: by
12 posts views Thread by elziko | last post: by
3 posts views Thread by Carlos Magalhaes | last post: by
14 posts views Thread by cj | last post: by
6 posts views Thread by Duncan Smith | last post: by
4 posts views Thread by =?Utf-8?B?THluZXJz?= | last post: by
reply views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by lumer26 | last post: by
reply views Thread by Vinnie | last post: by
1 post views Thread by lumer26 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.