Search results for query: *

Hi I am new to this forum, and relatively new to Access in general. I'm wondering if anyone can offer advice on the following.... I have a table "LOCATIONS" with the following information in: LOCS Description WORLD everyone WORLDXUSA all except USA OTHER other countries I have another...

Hi I have a table in Microsoft Access which I have linked with a table in a program called Create-A-Label3 which uses a dBase III format. All of the data transfers across just fine, except for the £ symbol which is in Access but will not go into the dBase table. It goes in as a weird symbol...

Hi, I am trying to include whitespace in a string. Here is part of my macro: watch for "CALL SUPERVISOR" : {} "? FORMAT" : {} "INVALID " : invchecker : {} "RP/": {} endwatch I've simplified it, but basically I only want the invchecker procedure to be called if it finds the word...

Sorry - ignore that - I just noticed a comma instead of a full stop!! Corrected now and it works - fantastic. Thank you!!!

Thanks Skip! Unfortunately I'm getting the following error when trying to run... runtime error '438' "object doesn't support this property or method" when debugging, its this line.... Source.Worksheets("DB").Range ("B10:O29"), Copy Any ideas? should I maybe use the full address of DB...

Thankyou very much for your time and help, much appreciated!! I shall take a look at this in a few minutes. Many thanks Tim

Hi Olaf Thanks for that - very helpful. The only thing is that when trying to run it I get: "Run time error "9": Subscript out of range" and when debugging it points to the line: Set Dest = ActiveWorkbook.Worksheets("DB") DB, by the way, is a folder (not a workbook) - they are numbered 1.xls...

Hi, I have the following code which transfers multiple "source" workbooks with a single sheet in each into a single "summary.xls" workbook over multiple sheets. (1)What I'd like to do is copy a range (B10:O29) instead of the whole sheet...can anyone help? Everything I try gives me unwanted...

Sorry, whats the DIR function? As I mentioned, I'm a novice! Can you show me the code? Many thanks, Tim

Thanks Andy. I have a number of files to loop through....1.xls, 2.xls, 3.xls etc up to any number. Can you tell me how I can incorporate a loop into the above code? Never done it before! Thankyou very much Tim

Hi Andy Thanks for the reply. Yes, sorry, they are separate EXCEL FILES! Each one has just one worksheet in them. I need to put them all into a single worksheet in a new .xls file which I'll call "Collated.xls". My biggest issue is that I ONLY want to copy a particular range of cells...

Hi there I'm a relative newcomer to VBA Excel. I wondered if anyone knew how to do the following: I have several sheets, numbered 1.xls and 2.xls and 3.xls etc which each contain the same field data, data contained in cells B10:O29. Basically, cells B10:O10 contains the data of 1 record...

Ok, I'm getting a bit confused...I was thinking your path was relating to where the excel data was coming FROM, not TO.

Hi, No, basically emails come into my inbox, and a pre-defined rule sends them to inbox/Test Folder. Each has an attachment, which I want to work with. I would like them opening and copying (unprotected) to my hard drive....which is Y:\Scripts\ So, I didn't think I could just find the path...

Ok, great. Just one more thing....the example you have given allows me to copy the first sheet from each workbook in C:\Documents and Settings\ii36250\Desktop. Ideally I'd like to get the information directly from my inbox/Test Folder folder. Do you think this is possible? and how would I do...

Aha, great. That sounds what I need. Incidentally, what is I decide I do not want ALL of the data from the first page of each workbook? What if I just want the range B10-O29? How would I manipulate the script? Thanks

Hi Skip Thanks for your replies...I'm a complete VBA novice though!!! How would I incorporate your code into my code above? I.e I want this macro to run in Excel, but only search Outlook for emails with attachments in "Test Folder", which is a sub-folder of Inbox. I only want it to save to...

Also, as per the title of my question...the sheets I am copying are actually protected, in that the data cannot be overwritten. Ideally I would like the copies of these sheets to be completely unprotected. I'm not sure if this is possible? The above script simply makes a direct copy of the...

Hi, the following code copies and pastes any excel attachments from a subfolder (called "Test Folder" in Outlook, into individual new excel workbooks under the path Y:\Scripts3\copy, the first being copy1, the second copy2, etc. However, I would like them to all go in 1 worksheet, one after...