JustAnswer > Computer
Ask A Question|Register|Login|Help
JustAnswer

Computer

Ask a Computer Question, Get an Answer ASAP!

Have your own Computer question?

7 Tech Support Specialists are Online Now
characters left:
Not a Computer Question?
Bookmark and Share

Question

I do keyboard merges in Word Perfect using a macro. I would like to do this in Word but am not sure how

Submitted: 187 days and 21 hours ago.
Category: Computer
Value: $16
Status: AWAITING EXPERT REPLY
+
Read More

Optional Information

OS: Windows XP; Browser: IE

Already Tried:
I am trying to convert my WP file which have commands called "KEYBOARD" and "NESTFORM?KEYBOARD that allow me to merge text files into and existing document. When I pull the files with the WP extensions up in Word, the commands don't transfer. Is there an equivalent in Word?

Posted by Karl Everest King 187 days and 21 hours ago.

Info Request

Hi XXXXXXXX. Thank you for asking.

Is this command related to mail-merge? As in a form letter printed with address of multiple recipients?

Can you please explain a little more so I can find the comparable Word command.

Thanks.

187 days and 21 hours ago.

Reply

I am a family doctor. I have files on each of my patients with their medical problems and medications. I have text files for common clinical problems, diagnoses, medications... that using a macro that was written by someone at WP years ago, allows me to merge the files into an existing document . WP does this using the KEYBOARD/NESTFORMKEYBOARD command tha tmerges the file. THe KEYBOARD command lets me insert text into the document during the merge. WP , using AltF3, has an easy way of letting me see the seeing the codes . I'm trying to migrate to Word. Thanks

187 days and 20 hours ago.

Reply

Do you need more information? DM

Posted by Karl Everest King 187 days and 20 hours ago.

Info Request

Word has the ability to insert the contents of another document in its entirety. In 2003, press the Insert menu > File. In 2007 Click the text tab > Object menu > Text from file.

Does that suffice? Or do you need insert text from a database or a single paragraph from a larger file?

I could of course make a macro to automate any of those tasks.

Karl

187 days and 20 hours ago.

Reply

I need to do more than just insert text in order to simulate what I'm doing in WP. The text files insert have embedded commands that let me, pardon me for not being able to use more specific computer language 1. jump form field to field where I can insert addtiional text . For example, a file might say cough, runny nose, fever.... the KEYBOARD command is embedded in the file and is inserted between each of those terms, and I'll put in a "no" , i.e. no cough, or "+" for pstive for cough ... also 2. the KEYBOARDNESTFORM KEYBOARD comand that's also lets me stay in the merge and addtional files. Does this help?

Posted by Karl Everest King 187 days and 19 hours ago.

Answer

If you have Word 2007 then this type of file I'm sending might do the trick for you. I inserted combo boxes with choices of treatment, etc. Click each one and select your choice, then that text is inserted.

If you like this I'll show you how to do it to your docs, it's easy.

However if you have 2003, then it's not so easy. Please let me know which version you have.

http://wikisend.com/download/480054/diagnosis1.docx

187 days and 18 hours ago.

Reply

I have 2003, I do have 2007,m tried to install it but the setup failed, I'm not sure why

187 days and 17 hours ago.

Reply

I have 2003, I do have 2007, I tried to install it but the setup failed, I'm not sure why . Can I use 2003? thx DM

187 days and 15 hours ago.

Reply

still waiting to hear back

Posted by Karl Everest King 187 days and 15 hours ago.

Info Request

Would you like to pursue installing 2007? I can help you install it, if you have that then it would be worth installing.

187 days and 15 hours ago.

Reply

yes

Posted by Karl Everest King 187 days and 14 hours ago.

Info Request

Are you getting an error when you try to install 2007? What's the error?

Be sure to close all other programs and have lots of free disk space.

187 days and 13 hours ago.

Reply

error message: "source file not found D:\PA561401.cab". What next?

187 days and 13 hours ago.

Reply

still waiting for an answer, what next?

Posted by Karl Everest King 187 days and 12 hours ago.

Info Request

 

(I do have other questions to answer, I cant devote my whole time to just one.)

That's an odd error. It usually means your 2003 trial version is not fully installed.

Are you installing 2007 from a CD? Is it a trial? (A trial is availble and may be an option, at least for us to get your solution up and running, then you can buy the 2007 later.)

For now, in My computer, Right click your CD drive and choose Open. Look for setup.exe and Double-click it. Unless that's what you've been doing.

 

Heres the link to 2007 trial if you need it:

http://www.microsoft.com/office/trial/default.aspx

 

 

Karl

187 days and 12 hours ago.

Reply

thanks, I am installing it from a fully licensed 2007 version. what next?

Posted by Karl Everest King 187 days and 11 hours ago.

Answer

Here's a trick that seems to fix that problem for most people:

http://www.technotes.co.uk/sku011-cab

But I have summerized it for you:

graphic
View Full Image

graphic
View Full Image

Delivery might be in a slightly differnet place.

If you dont see the CDCache, then let me know.

Karl

PS here's what the actual Word 2007 document will look like, minus your modifications, of course.

graphic
View Full Image



Edited by Karl Everest King on 5/20/2009 at 1:16 AM

187 days and 2 hours ago.

Reply

delivery is not there. I am working remotely now. I did find it in regedit on my home machine. where else might it be?

Posted by Karl Everest King 186 days and 20 hours ago.

Info Request

Are you installing 2007 remotely too? That may be why that cab is not found.

186 days and 20 hours ago.

Reply

yesterday I did it at the PC. last nite , I tried remotely. Is it possible that this error message is that I've "used up" the amount of installations of the CD. I think it was loaded on at least 2, possible 3 other machines

186 days and 18 hours ago.

Reply

still waiting for an answer

Posted by Karl Everest King 186 days and 17 hours ago.

Info Request

You probably wont get any error for that reason, untill after sucessfully installing it and entered the key. You havent gotten to that point.

 

I'm going to suggest you start a new question re the installation, as I'm not a "installation" expert. There are plenty such experts here, accept their answer and come back to this one, to continue with the macro.

 

If this one times-out (in 24hours) then start a new one and ask for me and we can resume.

186 days and 13 hours ago.

Reply

I do have 2007 installed on a laptop, so let's go ahead and keep trying

186 days and 13 hours ago.

Reply

I downloaded the file. Is there a command that lets me jump from part to antoiehr i.e. to insert simple text such as, "no" cough, ""bumpy" rash, etc. Also , is there a macro that would liet me pull in and merge another file into the existing document? thx

186 days and 1 hours ago.

Reply

I tried again, and was successfull at downloading 2007 on my office machine. I looked at the file you sent me. The embedded prompts are a good start. Is there and easy way to jump from prompt to prompt? Can one of the embedded prompts be "something" that allows me to imerge in another text file? As I mentioned before, the way I create documents is to insert text at the prompts which are little stopping points, and then add another file utnil I'm done composing a note. Thanks

Posted by Karl Everest King 185 days and 21 hours ago.

Info Request

Could you please send the file you have, in wordperfect and I will convert it to do the same thing in Word 2003.

Karl

185 days and 20 hours ago.

Reply

I don't know how to add an attachment to this reply . I tried copy and paste but it didn't work. Here's a facsimile of a typical file. using Alt-F4 in WP causes the cursor to jump from 1 [KEYBOARD] filed to the next. the [NESTFORM][KEYBOARD] command in WP allows me if I want , to continue the merge by typing in a file name which will insert the file into the document. Most often, the 2nd file has the same type of commands embedded which allows me to chain files together.

 

Here's an example of a typical file

 

[DATE] re: [KEYBOARD]

 

[KEYBOARD] days with a cough and runny nose. [KEYBOARD] fever.

[KEYBOARD][NESTFORM][KEYBOARD]

Thanks, P.S. how much is my bill so far?

184 days and 23 hours ago.

Reply

I done a little research while waiting for your reply. It looks like a need to write a macro using Visual Basic. Can you help me figure out how to simulate what I;ve been doing in WP? Awaiting your reply. DM

Posted by Karl Everest King 184 days and 22 hours ago.

Answer

Sorry, I meant to give you instruction on uploading a file, if you still want to:

graphic
View Full Image

Instead of a macro would Autotext work for you.

Autotext lets you type short "codes" for any word, for example:

nc=no cough

You would have to setup each codeword pair, but then you can insert it anywhere just but typing "nc".

But to jump from one place to another...I'll have to think about that.

 

This is probably best:Here is a Word 2003 that is similar to what I did for 2007, only difference is that you have to click the Lock icon on the Forms toolbar to either select the drop downs or edit the text, back and forth.

If that is satisfactory I can convert your existing docs to this format and of course a macro for you to choose which document to insert and modify thusly.

http://wikisend.com/download/723766/diagnosis2003.doc

 

As for payment, you can press the accept button when you are happy and pay the $16. A bonus is allways appreciated.

Karl

184 days and 8 hours ago.

Reply

Its not exactly a mail merge, as I am not merging a list with a formed document that has codes embedded . What I do is I have a text file that I start with that has the commands I spoke you about earlier i.e. [keyboard] which in WP a is a stopping point in the document where I insert text , or [keyboard][nestform][keyboard]., which is another stopping point that lets me type in a file name and be inserted into the document. In WP, Alt-F4 is the command that causes the cursor to jump to the next [keyboard] embedded in the document The majority of time when I am inserting a file, the file has the same type of commands that allows to to keep the merge going until I decide to exit out . I have a macro in WP that starts the merge by inserting my first file. Can you help?

Posted by Karl Everest King 183 days and 21 hours ago.

Info Request

I dont think I have mentioned mail-merge. Mail-merge wouldnt be helpful in this case.

I'm sorry this is taking so long, but it's because Word dosent have the ability you describe in WordPerfect, perse. It could be done with macros,and bookmarks and stuff. But it would be complicated.

 

My goal is for you to be able to make and modify your own included files AND be easy to use.

 

Did you look at my lateset file I sent? It uses the form controls to let you choose your "keyword", cough/no cough, etc. It dosent jump to the next, but you use the mouse to click each drop and select the word you want in that place. Then click the Lock icon on the Forms toolbar to switch it to normal document and vice-versa.

 

183 days and 17 hours ago.

Reply

thanks, I did look at the file. its a beginning ,h/e the ability to "jump" from field to field using the keyboard saves me an enormous amount of time. Is there anything you could program in Visual

Basic that could mimic this function? I'm suprised Word doesn't have the ability to do this. DM

Posted by Karl Everest King 182 days and 13 hours ago.

Answer

Here is a macro that jumps to the next bookmark by ALT-F4.

So then you can type, or whatever, over it. Once you type, the bookmark is lost so you cant jump to it again.

The idea is you insert (and let me know if you need a macro to do that) this type of doc and press the ALT-F4 to jump to each bookmark.

Look at this and let me know. The macro itself would have to be in the master document or normal template to work on the 'included' doc. Cant be in the 'included' doc.

 

http://wikisend.com/download/674216/jumping.doc

 

Also the macro module separately:

http://wikisend.com/download/464550/jumpingBAS.bas

 

How to add it to VBA:

Right click normal on the left, not book1.

graphic
View Full Image

 


If you find my answer satisfactory, please press the ACCEPT button, thank you.

Karl.

 

181 days and 17 hours ago.

Reply

OK. I imported the macro, and was able to use Alt-F4 on you document to jump from bookmark to bookmark. However, when I tried to use on a new document, the Alt-F4 command closed Word. Any suggestions? Also, at the end of each file, I would like the macro the prompt me to insert another file that would contain embedded bookmarks. Is this poosible? thanks for your help. DM

Posted by Karl Everest King 181 days and 13 hours ago.

Answer

Sorry about that. I'll give you an updated macro that automatically assigns ALT-F4 to the macro for all documents.

First remove the old module:

Right click jumpingBAS and select remove. Dont export it.

Download the new one and replace the old on your hard drive.

http://wikisend.com/download/595414/jumpingBAS.bas

Now import this new one the same way as before. It must be imported into Normal. So right click Normal and Import File and choose the new one.

 

You will see a new SUB called AddHotKey, just click on it and press F5. That will assign ALT-F4 to the jumpit macro. And ALT-F5 to another macro.

 

This new version will bring up the insert file dialog if you have pressed ALT-F4 past the last bookmark. Letting you insert it into the very end.

 

Or you can press ALT-F5 to do the same, but at any spot in the doc, not just the end.

 

If you find my answer satisfactory, please press the ACCEPT button, thank you.

A bonus is always appreciated.

Karl

181 days and 10 hours ago.

Reply

I followed your directions. A few problems. I made my own files using bookmarks. The Alt F4 hot key works . When I get to the point where I can insert another file, the new file comes in with a hard return which is not desirable for me. Also , some times I get an error message "can't execute code in break mode". Any ideas? DM

Posted by Karl Everest King 181 days and 8 hours ago.

Info Request

The function that inserts the file simpley moves to the last of the current doc and starts the insertFile dialog for you to choose a file to insert.

In my tests, it dosent add a return; it puts it right after the last letter .

It may be that the inserted file is the one with an extra return at its beginning. Open that file seperatly and delete anything before the first character.

You can also click graphicto see all the returns.

 

As for the error, that is caused if you have paused another macro at the same time. Did you click Record Macro? In the VBE (the macro editor) do you see a yellow or red line? If you see a red line, click it and press F9. If you see a yellow line press the stop button in the tollbar. That should stop the error. Do you have other macros in your normal template, such as for other purposes that may be running or getting there own errors?

 

Karl

180 days and 9 hours ago.

Reply

Thanks, I don't seem to be getting the error message anymore. Alt F4 takes me from bookmark to bookmark. Alt-F5 asks me to insert a file. When I insert a file that I've created with bookmarks, the bookmakrs seem to be gone. Alt-F4 takes me to the end of the inserted file. As I mentioned , I create a note by chaining file to file. How do I keep the what I call the merge going. Also, is there some way to easily see where the book marks are in the document? I fel I'm making progress, thanks for your help. DM

Posted by Karl Everest King 179 days and 21 hours ago.

Answer

I've changed it so it remembers the spot where the cursor was before the file insert and returns to that spot to let you press ALT-F4 and continue.

You can insert a file with bookmarks and jump to the next bookmark. However, if you insert a particular file with bookmarks again, anywhere in the doc, its bookmarks are cleared because there cant be duplicate bookmarks. Are you inserting the same file more that once?

http://wikisend.com/download/458728/jumpingBAS.bas

To see all bookmarks:

  1. Click Tool menu
  2. View tab
  3. Under Show, check Bookmarks

A bonus is definitely appreciated.

Karl

179 days and 18 hours ago.

Reply

thanks , how do I give you a bonus. what's a typical range for bonus's. You've been very patient and helpful.

Posted by Karl Everest King 179 days and 18 hours ago.

Info Request

You're welcome, it was an interesting project.

I'm not allowed to discuss bonus amounts. A bonus would be commensurate with the extra time I put into it; what you feel is appropriate.

Thanks.

Karl

179 days and 17 hours ago.

Reply

1. Still having trouble with the 2nd file I insert not going to the bookmark. 2. can't find the show bookmark after I click view on the toolbar 3. about how much time have you spent on this to give me an idea. I also think I'm going to need more help down the line on my project. How do I continue working with you? DM

Posted by Karl Everest King 179 days and 14 hours ago.

Info Request

It's not on the View menu, it's in the Tools menu:

  1. Click Tools menu
  2. Click View tab
  3. Under Show, check Bookmarks

Maybe when you see the bookmarks you'll see there are none, maybe? They have to be Word bookmarks, if your inserting WordPerfect file,s, then maybe WP's bookamrks are different, so redo them. Insert menu, Bookmark. Give each a unique name.

 

I don't keep track of hours, but at least several hours.

 

You can simply ask for me, anytime in the future, I'll be happy to help.

Karl



Edited by Karl Everest King on 5/27/2009 at 10:00 PM

179 days and 11 hours ago.

Reply

I clicked on view/show under the tools menu, but do not see anything about showing bookmarks. There were promts to show ; ruler, gridlines.. am I in the right place? How do I send the bonus

Accepted Answer

I'm sorry, I told you the wrong thing, twice!

It's this:

  1. Tools menu
  2. Options
  3. View Tab
  4. Under Show, Check Bookmarks

graphic
View Full Image

When you click accept, you are able to give the bonus at that time. Thanks in advance.

Karl

Picture
Expert: Karl Everest King
Pos. Feedback: 100.0 %
Accepts: 
Answered: 5/28/2009

Computer Software Engineer

20+Years of experience: Excel, Word, BlackBerry, and Programming

179 days and 9 hours ago.

Reply

are you sure you're giving me the right info for word 2007? can you give me each screen shot? I don't see the commands you're suggesting. DM

Posted by Karl Everest King 179 days and 8 hours ago.

Info Request

I thought you were using Word 2003?

Here's how to do it in 2007:

Click the Office button

graphic

Click Word options in the lower right.

Then Advanced, Show document content

Check Bookmarks.

graphic
View Full Image

Hit OK.

 

Karl

 

179 days and 8 hours ago.

Reply

I did a google search and found that under word options, the show bookmarks is under the advanced tab. So now I can see my bookmarks. At the end of all this , I am still having problems with the macro when it inserts the second file. The bookmarks in the 2nd file do not appear, and the Alt F4 command closes the document. I started this whole [rpcess hoping I would be able to chain files together , easily insert text and create a cogent document. Is this possible or am I wasting yours and my time. Please let me know.

Posted by Karl Everest King 179 days and 7 hours ago.

Info Request

I thought we you had given up trying to install 2007 after we spent a lot of time trying.

That's why I thought you had 2003.

Yes the show bookmarks is in advanced tab, as I said in my last post.

 

The reason ALT-F4 closes Word is because that is the default behaviour for that button, meaning the hotkey is not assigned to the macro. It may be that the macro is not in the Normal template as it should be. Check that in the VBA editor:

graphic

 

If it's not, then remove it from where it is and import it into Normal and run the addHotkey macro one time.

 

I have no idea why you dont see bookmarks in all the files, can you see them if you open the file in Word in the usual way?

 

You can send me the file and I'll look at it.

 

Karl

172 days and 15 hours ago.

Reply

Still having trouble merging the 2nd file.The macro doesnt seem to work when I pull in the 2nd file. I'm ready to stop for a while, thanks for your help

+
Read More

Related Computer Questions

  • someone is using an AIM account and is sending out
  • what is ripping
  • i'm looking for a site that gives operating
  • how can i get to myspaceby using the unblocks because the .....
  • My DVDs have no colour
  • I HAVE A CHECK THAT CAME IN THE MAIL AND I WANTED TO KNOW .....
  • I need an internet program that allows me to color my ...
  • need help on making a powersupply for a ibm thinkpad its 16v...



Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.
Question List | Become an Expert | Terms of Service | Security & Privacy | About Us
© 2003-2009 JustAnswer Corp.