Recent content by RollinAgain

PJ, Thanx for your response. That is exactly what I was looking for. Rollin

Why am I doing this in Excel VBA? The source file (Excel) is automatically generated by another application and comes back to me with lots of other USELESS information, graphics, codes, dates, page headers, etc. The Excel file would require extensive manual formatting and cutting/pasting in...

Sorry about the double post but I didn't see the Access Module Forum until after I posted in the general MS Office Forum. I have a very large Excel file that contains information about various Employee timesheets. I am using Excel VBA to insert the information into several Access Tables...

I have a very large Excel file that contains information about various Employee timesheets. I am wanting to use VBA to insert the information into several Access Tables. Here is an example of how each of the Excel Record would appear: NAME WEEK ENDING TOTAL HOURS John Doe...

In Outlook click TOOLS --> ADDRESS BOOK. When the address book window pops up click TOOLS --> OPTIONS Make sure that the list box at the bottom of the screen includes all the address lists you want to use to check names against. Rollin

Sorry about being vague with my description. I am running Windows 2000 on a generic laptop that I have had about 2 years. I have never had any problems with this computer until just a few weeks ago when it just unexplainably started doing this. The DVD/CD ROM is a Toshiba SD-C2502. This...

I have a laptop computer with a combo CD/DVD reader. Everytime I put a CD in the drive it is unable to be read and when I try to browse the contents, I get the message "DISK IS NOT FORMATTED." I have no problems whatsoever when using the same drive to read DVD's. Any ideas of why...

I had the same problem once. I kept seeing 2 of everything in my email box. It turned out that I had just had too much to drink and was seeing double...he he he. Rollin

You can write a macro to do what you want but it is not a simple straight forward task since it involves some programming skills. Are you up for a challenge or just seeking a simple quick solution? Rollin

QUOTE: "You could use rules to send it to a specific folder and run your code against that folder." This is what I have done in the past with my Outlook macros. The only thing to remember still is that you must include logic in your code to flag each email in the folder as being read...

QUOTE: "Another gotcha to be aware of is the Security patch will prompt you for permission to send an email when you reference an address with your autoreply feature. There is no way to program around it" Are you not able to use send-keys to get around these prompts. I have gotten...

I once wrote a macro that does something quite similar to what you are asking. Let me ask you this, do these emails you recieve follow any type of set template/format or are they all unique and appear very different each time you recieve them. Do the emails have the same or similar subject...

Try the following code. Just replace "Book1" and "Book2" in the code with the actual names of the workbooks you want to keep open. The workbooks names ARE case sensitive so make sure to spell them exactly the way they are named without include the .xls extension. Public...