Recent content by madelca100

Recorded this macro as a test - which worked. I copied it down and the conditional formatting sticks. thanks, skip Sub CF() ' ' Macro recorded 5/4/2011 ' Selection.FormatConditions.Delete Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlGreater, _...

SV wrote "What kind of error do you anticipate?" MA Response - human error. - like miscoding the three conditions. - picking the wrong shade of red, yellow, green - things I haven't thought of that another human being might do when they are setting up CF. PHV wrote "So, why asking in a...

Skip, The CF is not failing. I want to automate the process to avoid potential human error. We are using Excel 2003. mike

Skip, Yes it can be done using native CF. That is how we are doing it now. I would like to automate the process, if possible. This would avoid errors and would allow the process to run in batch i.e., unattended. Any ideas? mike

Hi, I've seen and used code here that allows me to conditionally set formats for values in a worksheet. (Thanks to all who posted code.) Currently I use VBA to create a pivot table and change the color of cells (outside of the pivot table) based on its value. Example: Cell G5, which is...

PWise, I tested it again this morning and it WORKS! Thanks so much for sticking with me on this one. I don't know what happened except a reboot of my computer. (I should have tried that myself.) mike

Mydb is where the table resides. Icon is table. (Some of the tables have arrows, but not this one.) Type is Table. (Others are Table: Linked Access) In MyDev the table is "linked". MyDev is where I'm coding the ALTER TABLE with the IN clause (or the OpenDatabase) statement. If I manually...

PWise, I do point to the "path to database where original tables are". So..... MyDev points (links) to a table in Mydb. The "IN" clause (or OpenDatabase) points to Mydb. Am I missing something? mike

thanks PWise for the quick response. I tried it and got the following error: 3611 - Cannot execute data definition statements on linked data sources. mike

Using MS Access 2003 - I want to add a new field to a "linked" table and then populate the field with data. Why am I doing this? Another department drops a database onto my server each week. I want to add new fields to this database so developers can use them. I can't put any code in the...

Question - how would you read all the rows in each worksheet if you don't know how many rows there are? Obviously each worksheet could have a different number of rows. Assume you can't test for a blank cell, but must read until you get to a blank row in the worksheet.

this is what I use to print in the Immediate Window: debug.print "Starting process xyz at : " now() code code code debug.print "Ending process xyz at : " now() (note: VBEditor will insert a semicolon.)

Thanks Skip for the code. And thanks for pointing out TGML. Being here five years didn't magically clue me in to all the tips and techniques available on this site. I've only posted about two questions a year and offered about two dozen tips. (Not a frequent flier by any means.) However I...

I've seen several sample of code that aligns columns, but they all use 'unbroken' lists. Currently this is done manually. By cutting and pasteing L/M to a matched I value. Insert a row where there is an L value and no I value. etc. Very error prone. Note: I can't copy this data, sort it, and...

Thanks for all the assistance especially NWBeaver. Here is what worked - almost. (It converted all the files, but died on a Run-time error 1004 Application-defined or object-defined error.) This code: - finds all .csv files - converts them to .xls - puts all the data in...