Search results for query: *

How can I change the font color in Excel based on another cell block. For example - I'm trying to change the font color to white if the above cell value is the same. I need to retain the value, I just don't want to see it. The formula should look like this "=if(F2=F1,text(F2,[white])&quot...

How Do I disable the functions in Excel while a macro executes? As I step through the macro, it goes back and recalculates these functions after every step.

Thanks, works beautifully.

I've been puzzling over this for a while. I have a formula "=cell("filename")" that gives me "c:\xxx\yyy\ttt\excel.xls" How do I get the cell block to return "ttt"?

Actually no, that was a typo as I was trying to make the code more readable for this forum. What the problem was, is that "FileFormat:=wdFormatText" was not being recognized; "FileFormat:=2" works though.

To answer my own question, if anyone else has this problem. I've also included the comments so that you know the order of the properties. Sub OpenWord() Dim AccApp As Object Dim test As String Dim junk As String test = "c:\2AirProdcorpd.rtf" junk =...

''''Does anyone have any idea why this won't save as a text file? Sub OpenWord() Dim AccApp As Object Dim test As String Dim junk As String input = "c:\crap.rtf" output = "c:\junker.txt" Set AccApp = CreateObject("Word.Application")...

I'm trying to open MS Word with a file My code looks something like this. This works but I need the opening file ("c:\conversion.doc") to be a variable Sub WordTest() Call Shell("c:\Program Files\Microsoft Office\Office\winword.exe c:\conversion.doc", 1) End Sub I'm...