Recent content by thorwood

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...