#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Not-so-noob


Hi Folks,

I've been programming for quite some time in basic (started in 1980)
and VB since VB3. I did VB software dev for a POS company for years
til they folded in 2001.

I even bluffed my way into developing some kinda major Excel 5 (or
maybe it was Excel 97) apps to manage large portfolios of mortgages in
the late 90's. I even got paid pretty well for it.

The problem with the Excel stuff is that I was just winging it. I
didn't really know if I was doing things in a solid and acceptable
manner. Things like creating and destroying menus and toolbars, adding
and deleting rows, etc. Although the customer liked it, It actually
seemed a bit hokey to me at the time.

Question: Other than the MSKB stuff, are there any web resources that
have 'best practices' type of info for developing Excel apps?

Thank you,

Don in Redmond
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 301
Default Not-so-noob

Buy Professional Excel Development (Amazon.com?) by Bullen, Bovey, Green.


"Don" wrote in message
...

Hi Folks,

I've been programming for quite some time in basic (started in 1980)
and VB since VB3. I did VB software dev for a POS company for years
til they folded in 2001.

I even bluffed my way into developing some kinda major Excel 5 (or
maybe it was Excel 97) apps to manage large portfolios of mortgages in
the late 90's. I even got paid pretty well for it.

The problem with the Excel stuff is that I was just winging it. I
didn't really know if I was doing things in a solid and acceptable
manner. Things like creating and destroying menus and toolbars, adding
and deleting rows, etc. Although the customer liked it, It actually
seemed a bit hokey to me at the time.

Question: Other than the MSKB stuff, are there any web resources that
have 'best practices' type of info for developing Excel apps?

Thank you,

Don in Redmond



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 226
Default Not-so-noob

i was thinking of this one for myself, do you have a preference to either?

Excel 2003 Power Programming with VBA by John Walkenbach
--


Gary


"Bob Umlas" wrote in message
...
Buy Professional Excel Development (Amazon.com?) by Bullen, Bovey, Green.


"Don" wrote in message
...

Hi Folks,

I've been programming for quite some time in basic (started in 1980)
and VB since VB3. I did VB software dev for a POS company for years
til they folded in 2001.

I even bluffed my way into developing some kinda major Excel 5 (or
maybe it was Excel 97) apps to manage large portfolios of mortgages in
the late 90's. I even got paid pretty well for it.

The problem with the Excel stuff is that I was just winging it. I
didn't really know if I was doing things in a solid and acceptable
manner. Things like creating and destroying menus and toolbars, adding
and deleting rows, etc. Although the customer liked it, It actually
seemed a bit hokey to me at the time.

Question: Other than the MSKB stuff, are there any web resources that
have 'best practices' type of info for developing Excel apps?

Thank you,

Don in Redmond





  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 126
Default Not-so-noob

I have them both.
Bullens book is good if you are very experienced in xl vba and you are ready
to make a complete application.

Walkenbach is best to learn vba in excel.

On the net Chip Pearson's site is a good example of "best practices."
He's good.

"Gary Keramidas" wrote:

i was thinking of this one for myself, do you have a preference to either?

Excel 2003 Power Programming with VBA by John Walkenbach
--


Gary


"Bob Umlas" wrote in message
...
Buy Professional Excel Development (Amazon.com?) by Bullen, Bovey, Green.


"Don" wrote in message
...

Hi Folks,

I've been programming for quite some time in basic (started in 1980)
and VB since VB3. I did VB software dev for a POS company for years
til they folded in 2001.

I even bluffed my way into developing some kinda major Excel 5 (or
maybe it was Excel 97) apps to manage large portfolios of mortgages in
the late 90's. I even got paid pretty well for it.

The problem with the Excel stuff is that I was just winging it. I
didn't really know if I was doing things in a solid and acceptable
manner. Things like creating and destroying menus and toolbars, adding
and deleting rows, etc. Although the customer liked it, It actually
seemed a bit hokey to me at the time.

Question: Other than the MSKB stuff, are there any web resources that
have 'best practices' type of info for developing Excel apps?

Thank you,

Don in Redmond






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Noob question letmeplay1977 Excel Worksheet Functions 2 October 5th 05 09:27 PM
Noob question Micro_pal New Users to Excel 2 September 4th 05 02:37 PM
Noob question Micro_pal Excel Discussion (Misc queries) 5 September 3rd 05 01:42 AM
Noob help Patrick Excel Worksheet Functions 3 March 6th 05 08:23 PM
VBA noob help with an IF duster Excel Programming 2 June 27th 04 10:21 PM


All times are GMT +1. The time now is 05:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"