macro advice

  • Thread starter Thread starter tommy
  • Start date Start date
T

tommy

i need to create a macro that will be used with various workbooks and
worksheets in different files and i am doing it programmatically using
C#, other than adding references and and running the macro from C#.net
everytime i run my program, what are my other options and or how would i
go about doing it -- THANKS in advance
 
And here I thought Visual Basic for Applications was the ultimat
technique for creating complex macros. lol, shows how little I know.
Seriously, is C# used for writting Excel macros
 
dderolph wrote...
And here I thought Visual Basic for Applications was the ultimate
technique for creating complex macros. lol, shows how little I know.
Seriously, is C# used for writting Excel macros?
Click to expand...

Hi,

Most people here discuss VBA (Visual Basic for Applications). It is the
most commonly used method for creating macros.

While I believe C# can be used for creating macros, it isn't discussed a lot
here.

You can look here for some information
http://civilu.ce.utexas.edu/stu/goodaljl/c++VBA.htm

And you can look here as well:
http://www.wilmott.com/index.cfm?nocookies=yes

The latter link is to a "quantitative financial community" where they often
talk about using C++ and Excel. This is beyond me, but it might be up your
alley.

Good luck.

Kevin
 
The latter link is to a "quantitative financial community" where the
often talk about using C++ and Excel. This is beyond me, but it migh
be up your
alley.
Well, that's interesting. But, it's beyond me, too. My goal is t
Click to expand...
learn more about VBA. I doubt I'll ever delve into C++
 
dderolph wrote...
learn more about VBA. I doubt I'll ever delve into C++.
Click to expand...

dderolph,

You can access VBA by pressing Alt F11. There are several good books you
can get to help get you started.

Excel 2003 Power Programming with VBA ; John Walkenbach; John Wiley & Sons;
ISBN: 0-764540726

Excel 2002 VBA Programmers Reference; John Green, Stephen Bullen, Rob Bovey,
Robert Rosenberg; 993 pages; Wrox Press Inc; ISBN 1861005709

Excel 2000 Programming For Dummies; John Walkenbach; 408 pages; Hungry
Minds, Inc; ISBN: 0764505661

Because I have not read the third book on the list, I cannot speak to it
directly. But John Walkenbach does a very good job at whatever he writes,
so I am sure you would find that book good too. I will return to John in
just a sec. I found the first two books to be indespensible. For those
that are able to learn computing languages easily or already have a strong
computing background, the first book might be the best route. But for me, I
found having two different but complimentary sources to be helpful. The
second book is more advanced but is still a good read. I should note, I
skipped chapters in the second book where I lacked interest. For example, I
skipped the chapter on COM add-ins.

Bill Manville, an Excel MVP, often recommends the following book to people
new to programming and VBA:

Microsoft Excel 2002 Visual Basic for Applications Step by Step (Step by
Step (Microsoft))
Reed Jacobson; Microsoft Press; Bk&CD-Rom edition (September 12, 2001)
ISBN: 0735613591

In my opinion, this book is probably best suited for those who have no prior
programming knowledge.

If you have any programming experience, I'd recommend the top three lists of
books. If you are completely new to programming, then you might want to
consider this last book.

John Walkenbach has an excellent website if you are interested in learning
more about Excel. You should browse through his "Spreadsheet Page". He
lists VBA code on his website that solves various challenges. It is helpful
to review his code and learn. He also has a lot of interesting other stuff
about Excel that you will find interesting. He also lists links to other
well known Excel sites. Here, let's make this a bit easier.

John's site: http://www.j-walk.com/

From there you can readily access the Spreadsheet page:
http://j-walk.com/ss/

Links to other good Excel sites: http://j-walk.com/ss/excel/links/
In particular, look at the developer links:
http://j-walk.com/ss/excel/links/xllinks2.htm

Others who frequent this newsgroup also have great Excel web sites. You
will often see themselves identified as MVPs. Have a look at their web
sites for useful information.

Here are a couple extra links for you to investigate:

Chip Pearson's web site: http://www.cpearson.com/excel.htm

Jan Karel Pieterse's web site: http://www.jkp-ads.com/indexEN.htm

This is probably a lot longer of a response than you were looking for or
wanting, but it should provide you with an excellent start at a useful
resource list.

Please come back with your questions.

Regards,
Kevin
 
Back
Top