Recent content by razman10

...or preferably copy all but only the stuff you want into a new WorkBook and then send that. That is actually where I started, but I need to send some code with it (Module 3) so the recipient can in turn run a macro. I could not find a way to easily copy a module into a new workbook, so I...

A nice simple way to accomplish this is the declare the email addresses in variables then use: ActiveWorkbook.SendMail _ Recipients:=Array(emailaddy, emailaddy2, emailaddy3), _ Subject:="Subject Goes Here" This way you can have as many email addresses as you need.

I've tried it both with and without the error trap and with and without the DisplayAlerts and it does the same. There is no error message; the code is properly laid out and it runs properly. The Module is removed if I stop the code, but not if I let it run. Is there any way of releasing memory...

Try Application.Dialogs(xlDialogSendMail).Show instead of wb.SendMail The filename will be in the SUBJECT: field and the TO: field will be blank.

Thanks for the reply, Tony, but that's not it. Module 2 is still there. Module 2 has a bunch of macros and what not that run BEFORE moving to Module 3 which is where the code I posted above is located (along with other code). It's almost as if it's keeping Module 2 in memory until the code is...

I have the following code in a userform to delete "Module 2" and it works - sometimes. (I "borrowed" this code from a website, I don't remember which one) DeleteVBComponent ThisWorkbook, "Module2" Sub DeleteVBComponent(ByVal wb As Workbook, ByVal CompName As String) ' deletes the vbcomponent...

How were the drop downs created? Did you use the Forms Toolbar or Control Toolbox Toolbar or some other way?

In the example above I only included duplicates. In the example I have here below, I do not want to see: 03901, 03904, 03906, 03908, 03909, or 04005. County Zip Code City State YORK 03901 BERWICK ME YORK 03902 CAPE NEDDICK ME YORK 03902 YORK ME YORK 03903 ELIOT ME YORK 03903 ELLIOT ME YORK...

Thank you Leslie. That solution provides all unique zips, regardless of non-matching cities. However I am looking for only unique zips with non-matching cities. Can this be done? I know it can be done in Excel, however with the number of records I have, that is not feasible.

Hello, I apologize if this has already been answered, I could not find the answer anywhere. I have a large database (almost 400,000 records) each with a customer's name, address etc, year & month, and sales. I have found many records with the same zip code but somehow have a different...

Bijan Shahrokhi, This is from the Microsoft Office Help section: When you mark an item on an IMAP e-mail server for deletion, it is displayed in strikethrough text in the header list. To permanently delete the items marked for deletion, do the following: On the Edit menu, click Purge Deleted...

What I do is select all of the blank columns to the right of the data and delete the entire columns. Then I select all of the blank rows below the data, and delete the entire rows. Then save the workbook (it'll be much smaller in file size). This can be done rather quickly once you get used to...

I don't know why Excel is reading it that way, but I can tell you it's because you are using Monday as your start day. For example, 1/1/06 is coming up as week 1, but 1/2/06 is coming up as week 2. Try changing your start day to 1 (Sunday). That should do the trick.

scripscribe, You are missing a closing parenthesis after your second "CONCATENATE". You don't really need to use parenthesis in that form, however since you opened it, you must close it. Here is the code you need...

Thank you JensKKK; I am all set. Razman10