$$Excel-Macros$$ Deploying Excel 2003 updates

2011-04-17 Thread BJthebear
I have a spreadsheet with multiple macros and userforms running perfectly in Excel 2003 across 10 different sites with 10 different sets of information in the tables - but there are various improvements that have been requested and I was looking for some advice on redeploying a revised spreadshe

$$Excel-Macros$$ Re: Updating excel 2003 spreadsheets and redeploying updates

2011-03-31 Thread BJthebear
I am surprised that after three days no-one has come up with any advice. I find it hard to believe that others have not come across this sort of problem before Please help - I am getting desperate Thanks brian On Mar 28, 7:18 pm, BJthebear wrote: > I have a spreadsheet with multiple mac

$$Excel-Macros$$ Updating excel 2003 spreadsheets and redeploying updates

2011-03-28 Thread BJthebear
I have a spreadsheet with multiple macros and userforms running perfectly in Excel 2003 across 10 different sites with 10 different sets of information in the tables - but there are various improvements that have been requested and I was looking for some advice on redeploying a revised spreadshe

$$Excel-Macros$$ Re: error checking VBA Excel 2003

2011-02-16 Thread BJthebear
Thanks Stuart - now working perfectly - until the next problem Thanks once again BJ On Feb 16, 7:16 am, Stuart Redmann wrote: > > On Feb 15, BJthebear wrote: > > > I have written a sub routine to add a name to a dynamic list but I > > > have three problems with it a

$$Excel-Macros$$ Re: error checking VBA Excel 2003

2011-02-15 Thread BJthebear
Brian Scotland On Feb 15, 11:40 am, BJthebear wrote: > I have written a sub routine to add a name to a dynamic list but I > have three problems with it and would be grateful for some advice. > > First the routine:- > > Sub InputNewUser() > ' > ' InputNewUser Macro

$$Excel-Macros$$ error checking VBA Excel 2003

2011-02-15 Thread BJthebear
I have written a sub routine to add a name to a dynamic list but I have three problems with it and would be grateful for some advice. First the routine:- Sub InputNewUser() ' ' InputNewUser Macro ' Macro recorded 01/02/2011 by Brian ' Dim Newuser As String Dim nextRow As Long Dim flag As Boolean

Re: $$Excel-Macros$$ Copying userform to new worksheet - Excel 2003

2011-02-05 Thread BJthebear
- 90290 32123 > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On > Behalf Of BJthebear > Sent: Saturday, February 05, 2011 8:05 PM > To: MS EXCEL AND VBA MACROS > Subject: $$Excel-Macros$$ Copying userform to new workshee

$$Excel-Macros$$ Copying userform to new worksheet - Excel 2003

2011-02-05 Thread BJthebear
I have created a complex spreadsheet that extracts certain worksheets and modules and creates another workbook which is subsequently emailed using Outlook to a list of individuals. It is not a complete copy of the original workbook as there is information which must not be sent out. However I hav

$$Excel-Macros$$ Creating an array of email addresses and using Outlook to send copy of excel worksheet to each

2011-02-05 Thread BJthebear
I am trying to amend a VBA macro that I created some time ago using WinXP and Excel 2003. This macro sends a temp worksheet via outlook to the names listed in the sendMail.array. What I am now trying to do is create a dynamic named range somewhere in the workbook that can be added to or email add

Re: $$Excel-Macros$$ Help With UserForms

2011-01-27 Thread BJthebear
I am amazed at what you have accomplished very simply but I do not understand where you are storing the information in the Combobox1 and combobox2 for the drop down selection process Please help - I really think I would benefit in my programming by utilising Userforms but I have always shied away