Search results for query: *

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!

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.

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 am using the following command to start a Procomm session and run an Aspect script: &quot;pw4.exe&quot; TELNET CONNECT MANUAL <machineName> <aspectScriptFileName> <aspect parameters> My aspect script contains the following code: *** proc main waitfor &quot;login:&quot; transmit...

I am creating new sheets from within VBA. First I would like to see if a sheet by that name (for example &quot;abc123&quot;) already exists and if so, don't try to create &quot;abc123&quot; again. Is there an easy way to do this other than looping through all sheets present?

I have a user defined type that contains three dynamic arrays of strings. I need to write a function that will increase the size of the array if necessary and take a value from a text box or combo box and write it to the array. So, I need to pass in the array that will be written to and the...

How can a script get the same information as using <right-click> and selecting &quot;Properties&quot; for a file? (I need to get the firmware version of an adapter)

I am trying to install the Option Pack and I have Win NT 4.0 with SP 5, the Option Pack install pops up a warning that it has not been tested with SP4 and above. Has anyone heard of major problems with SP5 and the Option Pack? Should I go ahead and install it?

How would I search for a specific string that appears between two other specific strings? For example, given the following text I want the number that the first &quot;ghi&quot; refers to, so I need to find the &quot;ghi&quot; that comes after &quot;abc&quot; but before &quot;pqr&quot;. I want...