Search results for query: *

I am using excel '97. (Yes, I know it is old but for various reasons, we can't upgrade this specific machine). Anyway, what I basically need is an "IsFunction" function or the functional equivalent. Where I pass it a reference and it will tell me if that reference contains a...

Import them as a text instead of a number. When you do the text to columns command, you can select the format for each column. Using the wizard, in step three select the column, then click the "text" radio button in Column data format. Imagineer

Hello, I'm unix hand that is a novice at WORD macros/programming so I'm having problems with this code. We have some text files that are being combined and then brought into word for document type formatting, etc. In the original text file, the authors put [LANDSCAPE:ON] and...

Found my own answer. I was searching for "command line" at support.microsoft.com. Silly me. I need to search for "command PROMPT". Imagineer

What is the registry key for the command line here option. I know that it is part of the Resource kit but that disk has been misplaced in our IT dept. Imagineer

The real question is "what are your delimiters, i.e, what character immediately precedes 'J' and succeeds 'n'?". I suspect that the space didn't work because the character was in fact a tab. If you have a POSIX version of grep then the expression would be...

Permanence is a relative thing. What I meant was that I needed them to last beyond the current session of awk. Awk allows you to read the environment variables using the ENVIRON array. The values in the ENVIRON array can be changed but they do not return these values back to the OS. All...

I'm trying to set some environment variables in a DOS (actually WinNT 4.0 cmd) shell. I know that changing the value in the ENVIRON variable does not pass the value back to the shell. I've tried using the system() command thusly, sVar = "EnvTest" sValue = "oldhat" if...

Subject says it. TIA, Imagineer

Nevermind. I found the note that the circumflex is the negation operator if it is the first character in []. Imagineer

hmm... why the ^? Isn't that the beginning-of-line metachar? Do you mean the negation operator "!"? Thanks, Imagineer

But I need the space to define end-of-word. Otherwise the expression would match to end-of-line. Since I will be holding the word, I don't want the rest of the line. Imagineer

Oops, there should be a space after the *. The regex tried is "IN.* ". Basically, I'm trying to find words beginning with "IN". Thanks again, Imagineer

Hmm.. for some reason this regex is not working. I am using the cygwin version of gawk. It only finds lines 1, 2, 13, 18, 31, 38 of the attached file. It appears that the "*" is not working. I really wanted it to match lines 21, 25, 31, 50. I even tried "IN..", still no...

mns, IIRC, ' specifies left justified text. " specifies right justified text and ^ specifies centered text. Imagineer

That was the solution to the problem. Works great. [pc2] Thanks, Imagineer

Yes, that is exactly what I am doing and why I want referenced objects. Hmmm, let me check on moving the first page header to the sheet itself. I still need the footer which is what put me in the "must have" mindset. Ok, steps I'm going to try. 1) move header to page and adjust top...

AngO, Have been doing that. The names in the ask and ref fields were exactly the same. (Sort of had to be because I copied and pasted. [pipe])

Re:placement of headers. Unfortunately, they really need to be headers which is what got me involved in the first place. The "original" template didn't use headers and footers at all. The users were manually copying and spacing. As I got into converting this to headers and footers...

Q1) What do the Macro Buttons do other than direct the user to "TYPE HERE"? Q2) Do you see a use for form fields in my application that I don't?