| Thread | Last Post | Replies |
|
| Blank lines in mailmerge not removed if using VBA | 07 Jul 2004 12:39 GMT | 2 |
Using Word 2000 (and Access 2000) I have a Word mailmerge document that I am running from an Access application. I use the following code: Set myWDApp = CreateObject("Word.Application")
|
| How do I call Print Watermark dialog box | 07 Jul 2004 11:49 GMT | 6 |
Does anyone know the vba code to display the "Print Watermark" dialog box generally accessed from Format > Background > Printed Watermark. It appears that you can't access this object in either vba or by trying to
|
| Removing non-breaking trailing spaces | 07 Jul 2004 11:49 GMT | 3 |
I have a cell in excel which has a not-breaking space at the end. I need to get rid of it but can't seem to check if the space is a space. Ive tried RTrim(string), instr(lengthofstring, 1, " ") and if string = chr(32) but nothing seems to work. Is there anything else I can
|
| Macro for Hyperlinking | 07 Jul 2004 11:38 GMT | 2 |
Greetings. I am using MS Windows / Office XP. I am unable to figure out how to do this on my own, so I am asking the experts here in this newsgroup for help. I have a bunch of files containing containing Bible verses
|
| Removing Metadata | 07 Jul 2004 10:02 GMT | 1 |
Greetings. I'm trying to find a way to automate the removal of metadata (author info, etc.) from Word documents. Can someone recommend a good way to proceed? Ideally I would be able to "clean" docs with a single click from within Word, drop files onto an application icon, run the ...
|
| prevent page break after copy part of the document from original document | 07 Jul 2004 02:58 GMT | 1 |
Is there a way to prevent the new document that i copy from original document to prevent page break? regards, joe
|
| Finding, copying, and pasting all sentences with specific strings | 07 Jul 2004 02:46 GMT | 1 |
I need to search all documents in a folder to find all sentences in each one that contain four different strings of 8 characters in each string (e.g. NAV?????, LAB?????). I need to copy those sentences and paste them into another open document where I'm building a report. I can't ...
|
| Doc name and page # in header | 07 Jul 2004 01:07 GMT | 2 |
I have a few hundred or so word doc's. I'd like a macro to open each one and insert the document name and page numbers (ie: NameOfDocument.doc page 1 of 5) into the header. Then, save and close the file, open the next, etc.
|
| Word as report engine?? | 06 Jul 2004 22:57 GMT | 1 |
I'm new to word and am having some trouble figuring out how to create a report template of several pages and loading data from my SQL Server database into the appropriate sections of my report. The report requires that individual columns from individual records be used in specific ...
|
| create shortcut to active document and place in a folder | 06 Jul 2004 22:53 GMT | 24 |
This is really a vba question yet I neglected initially to send it to the vba group.. I've cancelled the original messages, which had some mistakes, and I'm starting over. Is there a command that I could run through VBA that would create a
|
| Word & Excel MVP code problem | 06 Jul 2004 19:58 GMT | 6 |
http://www.word.mvps.org/faqs/interdev/ControlXLFromWord.h tm I have been attempting to use this code on two PCs using Office 2000 and a friend has tried on Office XP, but in
|
| Printing macro | 06 Jul 2004 16:13 GMT | 2 |
I have a macro that was made by someone else and I need to modify it so the printer dialog box comes up instead of just printing the document but I'm not sure how to do that. It works fine the way it is now but the option to change printers or do more than one copy isn't available. ...
|
| Conditional compilation on Word version | 06 Jul 2004 15:57 GMT | 1 |
anybody know how to get a conditional compilation based on the version of word ?? This bit of code doesnt work but illustrates what i need #if Val(Application.Version) > 8 Then ' 8 = Word97, 9 = Word2000 blahblah
|
| Word/ VBA/ Access | 06 Jul 2004 15:28 GMT | 1 |
I am a web developer who has managed to talk himself into a project that sounded relatively easy when I suggested it, now I'm stuck and hoping for a little enlightenment. I have created an intranet for my client part of which contains a customer
|
| Remove reference to Normal | 06 Jul 2004 06:06 GMT | 9 |
I have several templates for a project and some VBA associated with each. One of the templates has a reference to 'Normal' and I'd really like to remove that but when I try it says that it is in use. Any ideas?
|