Word 2003 using data from a drop down list (legacy form field)

J

johnnykunst

I have created a macro to generate filename from entries in a form in Word 2003 and save with this filename. The macro uses bookmarks to identify the text to be used. It works fine if the bookmark is for a legacy text form field, but if used with a drop down form field it generates a save error

Private Sub CommandButton1_Click(
Call RunSpellchec
Dim pStr As Strin
pStr = "C:\Users\John\Desktop\" 'Your director
pStr = pStr + ActiveDocument.Bookmarks("text").Range.Tex
pStr = pStr + "
pStr = pStr + ActiveDocument.Bookmarks("ward").Range.Tex
pStr = pStr + " .doc
ActiveDocument.SaveAs FileName:=pSt
Dim sCode As Strin
MsgBox "Your Intelligence report was saved to the central WINTEL inbox for processing & emailing. No further action is required; it is now safe to close the document
End Su

Any help would be greatly appreciated- is there any way to use the selected text item from the drop down, or, if not, to copy & paste the text into a text form field which the macro will recognise?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I extract text from drop down entry in Word 2003 7
Populate a footer on a protected form with text from mixture of text form fields & drop down form fi 1
Extract section of text from a form field 2
Code only works fully when run from VBA editor 6
Drop down list control value in vba 2
Link a text box based on drop down box with four options MS Word 365 0
Clearing Fields in a Word Form 5
VBA Legacy Drop Down Not Working 0

Top