LITTLEBLACKDOG.COM

Butt Sniffer Joined: 06 May 2002 Posts: 1579

maybe this should go in the general software section, being about excel and all, but i took a look at excel's macro maker and it seemed to open up a VB editor. so anywho.

can i get pointed in a general direction on making excel macros? the help file is rather worthless. maybe someone knows a good site with some basic ones i can look through? i know C/C++ and have some experience with java, so this can't be all that hard, yeh?

i have to make up these stupid little spreadsheet reports almost nightly that involve taking existing spreadsheets and editting them, moving columns around, making it all look nice, etc. it's getting old.

once i get that project under my belt i want to whip up something that can take a tab delimited text file, check values in it against other similar files, and then compile and spit out a simple html file. or at least compile the data so i can make it into an html file by hand. but that is all later.

i'll also be using this thread to harass you all with exact questions at a later date. thanks for your time.

Leg Humper Joined: 16 Jan 2002 Posts: 5483

I browse this stie whenever I am trying to achieve somethign in Excel that I am uncertain of: http://www.exceltip.com/
You can pry find more technical information from locating site from here:
http://www.mvps.org/index.html
maybe this one ? http://www.mvps.org/dmcritchie/excel/excel.htm

someone reading over my shoulder recommended this news group: microsoft.public.excel.programming

Posted: Fri Jul 25, 2003 7:01 am Post subject:

quijbe wrote:
someone reading over my shoulder recommended this news group: microsoft.public.excel.programming

Don't you just frikin hate that..one of my pet peev's

Butt Sniffer Joined: 06 May 2002 Posts: 1579

quijbe wrote:
I browse this stie whenever I am trying to achieve somethign in Excel that I am uncertain of: http://www.exceltip.com/
You can pry find more technical information from locating site from here:
http://www.mvps.org/index.html
maybe this one ? http://www.mvps.org/dmcritchie/excel/excel.htm

someone reading over my shoulder recommended this news group: microsoft.public.excel.programming

ok the http://www.mvps.org/dmcritchie/excel/excel.htm is excellent. i'll use that to help me through the first macro i mentioned.

i don't think i'll use excel for the other project. i'll just code something in c++.

thanks