Recent content by castout

Thanks for your help! Sorry if I'm being dense, but I can't get this to work. I can't get it to let me rename the "A" column on every sheet the same name - like "Status" for example. And if I could, I wouldn't be able to select only the "Status" range for Sheet1 - wouldn't it select that...

Well, I have several worksheets. I want each column to have the same name from one worksheet to the next, but I want to be able to refer to each sheet's column individually. Will that work? Also, will the name of the range show up instead of the column letters ("A", "B",...)?

Is there a way to rename the columns in Excel so you see the name instead of A,B,C,etc.? I want to be able to refer to them by name in VBA.

I need to loop through rows and select the row based on the value in a column. Basically, I want to "ctrl-select" each row that meets my criteria. I tried recording the macro, but it just looked like this: Range("5:5,12:12,15:15").Select Anyone know how to do this? Thanks!

Thanks! That helped, but also left me with more questions. Let me see if I can explain my situation... My index.htm contains a header.htm and main.htm (each in a frame). The header.htm has links to other *.htm pages that display in place of main.htm, header.htm stays fixed. On main.htm and...

My homepage uses frames, header and main. There are links on main that I want to appear in the same window with no frames (in the hyperlink properties, I choose "Whole Page"). From that page, I want a link back to home, but I can't get it to display my homepage with the frames.

Does anyone know how I can use "waitfor" with two expressions? For example, I need to say: waitfor "abc^M" or "123^M" Then, I need to react differently depending on which string I receive.

Thanks for the response, however it did not work for what I need. The problem is that I am calling the batch file from a link on a web page, so the directory of the command window is not the same as the directory of the batch file.

If I am running a batch file (ex: c:\temp\mybatch.bat), is there a command that I can put in that batch file that will return the directory where it is located (c:\temp)?

I have verified that it works if I delete the .wax file every time it runs. I am specifying the .was file on the command line. Weird, huh? Anyway, thanks a lot for all of your help!

I think the reason it doesn't work the second time is because it is using the previously compiled .wax file. I think if it compiles it each time, it will work. Do you know of a way to force a compile via command line? Otherwise I will just have to delete the .wax file after every run.

Sorry - I meant to say 'closes' instead of 'loses'.

Thanks a bunch!! That worked for me also - but, there's another catch. (I see weird stuff like this all of the time in Procomm/Aspect!) When I run the command on the first controller it works fine. I see the Procomm window open up and compile the script and then it minimizes for a few seconds...

Boy, I'm glad it's not just me! Thanks!

I'm actually connecting to a disk array controller. I am starting the window minimized using the Shell() command in VBA for Excel.