Re: recommended sites for sample codes for Visual Basic for Applications macros

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Norman Harker (njharker_at_optusnet.com.au)
Date: 02/05/04 

Date: Thu, 5 Feb 2004 13:40:35 +1100

Hi Jeff!

Try subscribing to microsoft.public.excel.programming

It's a very high traffic newsgroup and you'll find huge amounts of VBA code
posted there that handles all sorts of problems.

Also try Google for finding solutions to particular problems. You'll find
that Ron de Bruin's Google Search 6.0 makes searching very easy from within
Excel. Free from:

http://www.rondebruin.nl/Google.htm

If you want to search Microsoft Knowledge Base or some of the better
websites, you'll find that Google Search 6.0 also has this option. 

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Jeff Hop" <jhopkins4"no spam"@sc.rr.com> wrote in message
news:GKgUb.57036$5K1.3572569@twister.southeast.rr.com...
>
>
> Hi,
> Does anyone know of  a recommended site that has "sample codes for Visual
> Basic for Applications macros" for Excel (Excel 2002). I have created
> several useful macros for my specific needs, but I was wondering if there
> was a site with VB codes of macros others have created.
> -- 
>
> Thanks,
> Jeff
> -------------------------------------------------------------
> ---------------------                  ----------------------
> -------------------------------------------------------------
>
>

Relevant Pages

  • Re: Applying a | delimiter to separate a series of Zip codes
    ... Debra Dalgleish has some notes how to implement macros here: ... Excel 2003 and earlier won't handle that much text in a cell. ... Or do you just want to create a *.txt file with the pipe delimiter? ... I have a list of Zip codes (approx. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Applying a | delimiter to separate a series of Zip codes
    ... Debra Dalgleish has some notes how to implement macros here: ... Excel 2003 and earlier won't handle that much text in a cell. ... Or do you just want to create a *.txt file with the pipe delimiter? ... I have a list of Zip codes (approx. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: I dont want to count hidden cells
    ... Do a google search on "count visible cells only" and there should be many ... If you have excel 2003 there is a function called subtotal, ...
    (microsoft.public.excel.misc)
  • Re: Problem Importing from an Excel spread sheet to an Access 2003 table.
    ... But if I could after the fact change all of the zip codes ... >Based on your requirements you cannot use Excel. ... >The spreadsheet MUST be properly formatted otherwise it ... >> data when access imports data. ...
    (microsoft.public.access.externaldata)
  • Re: zip code - cant trim preceding space
    ... But you want text for zip codes, ... You do not want a mixture of 5 digit numbers and zip+4 ... those with Excel 2002, ... >>> Format the column as general and then redo your formula. ...
    (microsoft.public.excel.worksheet.functions)