Macro in Word document
Asked By kishore babu
06-Nov-09 11:39 PM
I need a macro to move the menu bar (File, Edit etc) from top to bottam where we can see auto shapes, 3-D e.t.c
I need to move the menu bare through the macro only not manually.
Try this
S Sason replied to kishore babu
27-Nov-09 04:35 PM
Sub Refresh()
Set myMenuBar = CommandBars.ActiveMenuBar
myMenuBar.Position = msoBarBottom
With myMenuBar
.Protection = msoBarNoMove ' to prevent it from moving manually
.Visible = True
End With
End Sub
Run time error 5479 in VB macro Hi, I am getting run time error 5479 with the below code. Set LetterTemplate = Word.Documents.Open(LetterDocPath) It gives Debug option, and if i cursor to the next line and run it again, the VB macro finishes fine. This error happens only when I run the macro via a word doc, if i run the Normal file itself, there is is though I have added the global template on my word, it still throws error 5479. I also tried error handling lockergnome.com / office / Word2003-generating-error-5479-close-Microsoft-Office-Word- -ftopict948697.html http: / / windowssecrets.com / forums / showthread.php / 109504-Word-VBA-Error-5479-%28English-Word-2007%29 This will not happen
How to pass a value from MS Word to VB function I have to pass a value from MS Word Macro VBA to VB function. I need some help to know whether it is possible to pass a value from Word VBA to VB function. Please give clear description of the problem. Create New
MS Word Macro HOT KEYS Hello~ I was wondering if someone can help me out with this situation. I'm looking for a macro for ms word, where I can basically auto bold, underline and put squiggly brackets on a word I select and push a hotkey. For example, selecting the word "farm": The man went to the farm to grow some get what do you mean, do you want assign a Word command or macro to a hot-key? then do this things 1. Choose In the list on the right, choose a command or macro. 4. Enter a key combination in the space provided. 5 issue. I would like to be able to select any word on a word document and simply press a hotkey to
opening macro enabled word document hi, I am doing a project in VB.NET which requires that on clicking a button, a MS- word macro enabled template(.dotm file, already created) gets opened.followed by from SQL database and append it to the template enabled word document.Could anyone please provide me with the code.Ill
Insert pdf in word doc via macro vs. insert object Word version: 97-2000 Background: I need to insert 200+ small (~40KB) pdf files into a Word doc. Doing it manually works fine via Insert-> Object-> Adobe I wanted to automate the process and wrote a little VB macro (see below.). Problem: When I save the document where I However, a document where I inserted the file via the macro is 1.5MB . I'm new to VB , so what am I missing? Thank you Sub Macro1() Dim the reader installed, so that the manual insert and the macro insert can use the same version. Other than that your a File Picker dialog box as shown in the below macro. Sub Macro1 () Dim FoundFile As Variant Dim vName As Variant
Lock a word document using vb net I am trying lock a word document using vb.net . Anyone know how to do this? Although I don more helpful then the code to do it. Open your word document. Go to macro builder and set the recorder to record your actions which the document. Then stop the recorder and go to the Macro sub menu and select the Edit code selection. You will till you see it. If you need to open the word object tell me but I am assuming you know how that. Here is the code I got from building a macro Sub Macro1() ' ' Macro1 Macro ' Macro recorded 5 / 15 / 2006 by ' ActiveDocument.TrackRevisions = Not ActiveDocument
Help me in defininging macro in MS Word 2003 I need help. Here is the case. I want a code or a macro which finds and replace acronym in a document only on if it not mentioned. For example in a big MS Word 2003 document to check the first occurrence of USA acronym of America (USA). Can anyone help me in writing the macro (a code in html or any other language which is comparable with VB) to perform the above task? Many thanks Emebet hi • Open a new Word document • Type in a few words of text. Anything you like • Highlight your text, or just a single word of the text • From the menu bar, click on Tools From the drop down menu click on Macro • A sub menu appears • Click on Record New Macro Click Macro > Record New Macro When you click on Record
MS Word VB Replace using Input Box Hi There, I've searched high hand. I have a document I need to create a macro for that upon opening will pop up with an inputbox putting the name into the input box I want the macro to find the default name I have in the document ABC" example. After the 5 inputboxes that would end the macro. Sound relatively simple but I'm looking to do this makes sense. Any advice would be greatly appreciated as my VB skills leave a little to be desired! Cheers, Create New