Search results for query: *

That's a wonderful macro and exactly what I was looking for. It's also very clearly written and I'll certainly refer to it the next time I get the urge to learn Word macro basics. Thanks a lot!

Yep, that's the INCLUDETEXT command. In summary: - Now I use {INCLUDETEXT "C:\\Doc1.doc"}, which works great but I'd like to refrain from using absolute paths. - Using {INCLUDETEXT "Doc1.doc"} uses whatever current directory Word is using (My documents at startup, or the directory of the last...

Unfortunately that doesn't work. Word apparently uses the working directory as the default, not the directory that the main document is stored in. If I manually open the main document using Word's Open dialog, Word will change its default directory. But it won't change its default directory...

Sometimes when I add a footnote or endnote I have several references, i.e., 1-4. However, if I simply add 4 endnotes I end up with Word displaying 1234 in the text rather than 1-4. Any trick I can use to change this?

I'm using INCLUDETEXT fields to insert many subdocuments into a master document. All subdocuments and master documents are in the same directory, which changes every once in a while. I'd like to tell INCLUDETEXT to use the "Chapter1.doc" file in the same directory as the master document - is...

I am building conditional lists of data in columns. Ie, =if(A1="Name",B1,""). I would then like to do things such as average the data (not a problem) and make histograms (problem, as it tells me my data range contains non-numeric data). I can delete the empty cells using...

Hmmm... that doesn't work for me. A1 => foo A2 => =if(A1="foo","") A3 => =isblank(A2) => FALSE

I would like to have IF functions return blank cells. Example: =if(A2="foo","bar",BLANK) Then, when filling down, I get either cells with "bar" in them or cells that would return true for the ISBLANK function. It seems "" creates an empty text string...