Search results for query: *

I have a field of data that looks something like this: C320-EB-17-SOME NAME I need to extract just the part that is SOME NAME. In Access I'd use INSTREV and search for '-' then do a left function from that point. The data is variable so I can't just count on SOME NAME starting at the same...

Thanks, I didn't have time to work it through, it was a immediate need sitation. Now that I solved the immediate need I will work on updating the routine to clarify the required range and clean up the approach. Thanks again!! Once I have it completed I'll let you know.

I thought the color index for red was 3 instead of 45.

Just wanted to give you my end result code that works. It's not perfect for every possible situation but it does what needed in a heartbeat. Thanks to Skip for all the assistance! Sub MColorMe() Dim myMatchVariable As Variant...

That's the thing, the range will be variable I'm afraid. I think to start I would say it would be no bigger than 13 columns and 500 rows.

4 different values so that's fairly easy. The tough part now is walking two columns over and highlighting the values in this column, etc, etc. and then also doing this same walk through for 10 worksheets. Is there a "for each worksheet" routine that would simplify this?

That's the ticket! I was using Set P1 = (VBCode for lookup) No more errors. Now I just have to set the background color of the cell based on the value the lookup returned. Thanks for the assistance!!

A4 is the exact value. It would be referencing Sheet1!A4 value. my first line of code is setting focus to sheet1 and cell A4.

I don't want to add to the worksheet, just change the highlighting of the cells based on walking through the cells with values and doiing the comparison. I was thinking of calling the procedure in an on-open routine(?) make the changes and save it, I haven't really thought that far ahead...

I want to look up one value in sheet1 that will have a matching value in sheet2, I have to walk through each cell value and highlight matches. Here's my code: Application.VLookup(Range(myRcdA).Value, Range("A3:D535"), 3, False) Range(myRcdA) will have data in sheet1, I need to match that to...

Visual Basic but if there is a better, simpler language I'm confident I can pick it up and get an understanding of it.

Is there an example of a simple script somewhere that I could see and walk through to see how it's done?

Is it possible to create a batch script or some other script to look at a web page with links within the page, open the link (link is to a file for downloading) and have the script automatically put the linked file (zip file, excel, text, etc.) somewhere on your harddrive?

That could be an option because then if I wanted to save the selections I could do a make table type query or SQL update query to save the data. I didn't really think about that angle.

Anyone have an example of doing something like this? I have a form based on a table which relates to another table (subform holds this info) that I want to be able to select a check box and return those selections inthe main and subform to a seperate temporary table. I don't know if I'm being...

Is it possible to have excel change the format of one cell based on what you enter in another cell? Say I wanted to automatically have excel format bold fonts if I enter a number in an adjacent cell greater than 100 as an example.

Has anyone noticed if databases which link into a main database will cause the processing of updates/changes to the main database data to become degraded?

I assumed you have access to the webserver and the folder the DB1 is in. If this is the case you should be able to map a drive to the folder say something like this K:\\webservername\parentfolder\subfolder\db1.mdb Can you do this?

There is no need to download any thing. In DB2 on the tables object view right click the white space and a list of options comes up. Look for the link tables option and navigate to your DB1 when the files list comes up. Open your DB1 and link to the tables you need. Then you can create make...

What I usually do is just link the tables from the "data" DB to a DB on my PC which I end up running queries, reports, updates on. You can write VB code in a module which will open the data DB and create temp tables but not knowing what you are trying to accomplish I couldn't begin...