Search results for query: *

thanks - that was driving me nuts. Have a star

OK - I thought I knew a little about Excel but I can't figure this one out: When I press my TAB button, instead of advancing to the next cell to the right, it jumps to the next cell on the next page to the right. I have looked at the help files and my settings but cant seem to find what is...

I did make a few changes - Since I am using an input box to capture a string of data, I ended up coding the cancel button like this: Dim inp inp = Application.InputBox("Input MM_DD" , "Input Required") ' Check to see if Cancel was pressed. If inp <> False Then ' MAIN...

thanks - that was exactly what I needed - have a star!

I have a macro that uses an input box to get some data from the user. I used a OK/cancel button - what is the code to kill the macro if the user selects cancle? thanks

Is there any way to "pause" a macro? I have a macro that imports a datasheet and then begins to shred it into several reports - and eventually mails them. I would like to be able to pause execution of the macro after the datasheet is imported, so the user could verify the data before the macro...

Remou, thank you - I spent about an hour searching this site for something like this - guess I wasn't using the right keywords? Anyway, looks like that will work. thanks again. Patrick

Is there any way to have Excel create an email, populate the "To" and "Subject" fields (don't need message body) and attach a zip file?

Skip, OK thanks - I figured it out. Perrymans - thanks - I also found a use for your example. Thanks, Patrick

Skip, How can I tell what the value is of .Cells(j + 1, 11).Value when the error occurs?

Skip, Thanks - that works, but it also errors once it's done. It looks like it loops through the entire spreadsheet (as I added a "match" on the first and last line.) As expected it concatenated the "-A", however it then errors out on this line: If .Cells(j + 1, 11).Value = "8603" Then The...

In the last few days I have noticed a weird problem with Excel (2003 SP1). If I try to open an .xls file that was exported from an Access DB (on a network share) OR try to open an .xls file that is physically located on a network share, my personal macro workbook is gone. Any one know what's...

I have a spreadsheet that is imported daily into an access database. The spreadsheets columns are always the same, however the number of rows will change daily. The spreadsheet represents invoices from the previous day. What I need to do is check each row to see if a particular location in...

I need to to a docmd.transferSpreadsheet to export a table as a xls file. I can do that easy enough - what I need help with is the VBA to name the file according to the previous day's date. For example if today is 12/12/2005 I would like the exported file to be named 2005_12_21.xls

Its set for HTML - and uses Word for email editor

I want it to check only the text that I typed - I don't want it to check the text that was in the origional message I received. It is checking everything - the stuff I typed and the stuff I received.

I have outlook set to NOT check the spelling on emails that I reply to, or forwarded messages, but it does anyway. Is there any way to keeo it from doing that? I have mine set like this: Tools - Options - Spelling (tab) - have "Ignore origional message text in reply or forward" checked.

they were not indexed - adding the indexes helped greatly. Thank you

Actually - the query locks Access up :(

Duane, Interesting SQL - I think It works, but it's bringing my machine to a crawl... Thanks