I am working with an old Word template created by someone else years ago using Word Basic. I need to make some modifications to the template, including a new userform I created (with VBA) that I need to call up at the end of the existing AutoNew module (which is written in Word Basic) but my...
I am using the code below:
Sub Macro9()
ActiveDocument.SaveAs FileName:="c:\temp\name.txt", FileFormat:=100
End Sub
Is there a way to bypass/avoid the warning prompt that comes up when this code is run that says, "This file needs to be saved using the MS-DOS Text with Layout text converter...
I would like to write some code that does the following:
If the print preview screen is open Then
Close the print preview screen.
I know the code for the second line
(ActiveDocument.ClosePrintPreview), but I am having trouble coming up
with how to write code for...
Background information:
- I have a template created in Word 97 that has quite a few userforms and macros in it.
- The template is posted on our company's intranet.
- All employees have downloaded the template from the intranet.
- The template is changed periodically.
PROBLEM: How do we let the...
Is there a way to automatically have information that the user types in a textbox of a userform get saved as a field in the document properties of Word (ie. title, subject, author, etc.)?
My userforms are set up so that the text in the textbox gets inserted in a bookmark within the document. In...
I need to write code that inserts a picture/logo (saved in autotext in
Word) into a bookmark in a Word template so that I can reference the
bookmark on the second page header. Normally when I insert text at a
bookmark I use code similar to this:
Set BMRange =...
I have created a program in Word97 that has several userforms that prompt the user for information. I do not want them to be able to close out of the forms, as it is mandatory that they select certain options. Is there a way to disable the Close (X) button on the top right corner of the userforms?
Does anyone know if it is possible to write a macro that will connect you to a webpage. What I would like to do is create a toolbar button so that when the user clicks on the button, it will send them to a particular site on our intranet. Any suggestions?
I have a program created with about 5 different forms. At one point in one of the forms, I want to have a statement stating that If a checkbox on that form is checked, AND a certain checkbox on the previous form was checked, Then it will prompt the user for information. However, I am new to...
I am working in VBA (Word 97) and I have created a template with multiple forms which prompt the user for information. I would like to create a "Close Document" button (to be used if the user gets half way through the prompts and decides that he/she does not want to finish, but...
I know that in Visual Basic you can use the ControlBox property to remove the min,max, and close buttons from the window. However, I am working with VBA in word and have created several forms. The ControlBox property is not available in these userforms. Does anyone know of any way to remove...
I would like to make my program have the OK button "disabled" until the user selects one or more checkboxes on the form, at which time it would be enabled. I am new to programming and I don't know what code to use. Any help would be appreciated. Thanks.
Does anybody know what this error message means. . . ."Run-time error '5981' - Could not Open Macro Storage"? I have a program in VBA set up for our employees so that they keep track of the amount of work that they do (they are secretaries). Each time they work on a document, they...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.