auto insert a date that is two weeks away

Tutorials Win: Microsoft Windows Forum

- Previous
  - 1
    - for loop not working Hello, I have the following subroutine that breaks right after it reaches the last value of "i" which is 102. I've added watches for every variable in the routine and all the variables are there. The actual For Loop is working fine, and the bookmark exists but when I put in a message box, it won't even go to the message box. I have an identical For Loop higher in the code that works fine. I'm totally flummoxed by this. Thank you for any help you can provide. _________________________________ Public Sub AddBarAdmissionsListInfo(varBookmark As String, varRecords As Long) Dim i As Integer Dim strListInformation As String Dim rng As Range Set rng = ActiveDocument.Bookmarks(varBookmark).Range For i = 0 To varRecords If frmAttyBio.ListBarAdmissions.Selected(i) = True Then strListInformation = _ strListInformation & frmAttyBio.ListBarAdmissions.list(i) strListInformation = strListInformation & " | " End If Next i MsgBox "Out of ForLoop" rng.Text = Left(strListInformation, Len(strListInformation) - 2) Tag: auto insert a date that is two weeks away Tag: 86548
  - 2
    - Printing Current Page problem Please can anyone tell me why the below does not work. Many thanks Private Sub CBOXCURRENTPLAIN_Click() If CBOXCURRENTPLAIN.Value = True Then With Dialogs(wdDialogFilePrintSetup) .Printer = "\\rother\CanonMF13" .DoNotSetAsSysDefault = True .Execute ActiveDocument.PrintOut Range:=wdPrintCurrentPage End With End If End Sub Tag: auto insert a date that is two weeks away Tag: 86544
  - 3
    - Right align column does not work from vb I use vb6, win2000, and word2003. I am creating a word document in vb. After I write the data to the document I put it into a table: oRange.start = WordDoc.Range.start oRange.ConvertToTable numcolumns:=IIf(choice, 4, 1), AutoFit:=True I want to have the second column right-aligned. This code does not work: tbl.Columns(2).Select Selection.ParagraphFormat.Alignment = wdAlignParagraphRight It works as a macro in Word on the final document, but not from vb. This code works, but is slow: Dim cl As Cell For Each cl In tbl.Columns(2).Cells cl.Range.ParagraphFormat.Alignment = wdAlignParagraphRight Next cl Regards, Jan Nordgreen Tag: auto insert a date that is two weeks away Tag: 86543
  - 4
    - document active but not really? I'm using C#. I've created a new document and saved it with SaveAs. Now I want to re-open the same document and allow the user to edit it, so I do Open and then Activate. Then Word's in this odd state with the correct filename in the title bar and the menus appear as if a file is open & active, but the document isn't showing! If I go to the Window menu, the document's there (the only one there) and it's checked, but if I click on it, Word's document area stays empty (blue/grey). The code excerpt is below. Thanks for any ideas! Matt oWordDoc.SaveAs(ref WordFileName, ref Missing, ref Missing, ref Missing, ref oTrue, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing); // re-open it for user to continue editing oWordDoc = oWordApp.Documents.Open(ref WordFileName, ref Missing, ref Missing, ref oTrue, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing, ref oTrue, ref Missing, ref Missing, ref Missing, ref Missing); oWordDoc.Activate(); Tag: auto insert a date that is two weeks away Tag: 86540
  - 5
    - Macro to Save Multiple Word Documents with Different File Names Hi, I have to process some 5,000 documents, and need to change their filename at the same time. All of the documents have a name in the header in the format: Firstname Middlename (where it applies) Surname I need to save the documents as: Surname, Firstname Middlename.doc I know how to change the directory they're saved to, and I've managed to set up the macro to run on all files in a given folder. This is the only thing that's stopping me from being able to run the macro. I don't know what terms to actually search for to be able to find help on this, so I'm trying here. I've tried to create a Function that will let me create the filename, and then use that as the Save As option, but I can't get it to work, as I can't reference the Function in the SaveAs Filename:=" " It will only save as what I put in the " "... I've tried using brackets, and nothing, but no luck. Any help would be greatly appreciated, even if it's just to tell me what terms I need to search for on the web, or a website that you think could help. Many thanks, Wafty Tag: auto insert a date that is two weeks away Tag: 86533
  - 6
    - Calender views Hi I wonder if there anyone who know how to change the calender view? I want to show one or more column that i have created. Gunnar Tag: auto insert a date that is two weeks away Tag: 86526
  - 7
    - View Zoom is killing me! I have this application, see, and when a user finishes editing a document, I want to display all of the pages of the document to them and put up a simple yes/no dialog. (true, the pages are potentially very small and unreadable, but the idea is just to give the user a general reassurance that, at a quick glance, they have not put an errant page break in and left a blank page or something) If they answer no to the dialog, I want to reset the view's zoom back to whatever it was previously, which I already stored before I changed the view's zoom to x pages by y columns.. If they answer yes, I want to set the zoom to page width so anyone else outside of our company who opens the document won't get some funky zoom by default. So, I can show all of the pages by setting .PageColumns and .PageRows, and I can restore the previous view by setting .Percentage to the value that was previously captured.... BUT, this causes all kinds of issues with the zoom in Word because it is seeming to "remember" the many-pages view, and when the user performs various actions, such as maximizing/restoring Word, sometimes switching to another application and back to Word, etc., Word will set the zoom back to the multiple-page view. Here is bare-bones macro that exhibits the problem. Interestingly, this was basically recorded using the macro recorder, yet doing the actions interactively as a user via the View|Zoom dialog works fine, but running the recorded code does not work well at all (per the above gripe). Public Sub Macro1() With ActiveWindow.ActivePane.View.Zoom .PageColumns = 2 .PageRows = 2 End With ActiveWindow.ActivePane.View.Zoom.Percentage = 100 End Sub If you run this macro, then maximize/restore Word, for example, you will be put back into a view that shows 4 pages (2 x 2). Word is reverting back to the .PageColumns and .PageRows setting. Any ideas? I've verified this on Word2000, WordXP, and Word2003. I've tried using the Dialogs(wdDialogViewZoom) dialog object but can't seem to get that to work (I'm not trying to display the dialog, I'm trying to set the values the same as I did interactively and then call .Execute on the dialog object). Any help would be greatly, greatly appreciated. Tag: auto insert a date that is two weeks away Tag: 86524
  - 8
    - Editing an Embedded Excel Worksheet This one has perplexed me ... I'm automating Word from C# under VS .Net 2005. Everything about automating Word has been straightforward. I have an embedded Excel document (not linked) in the Word document that I'd like to change a single cell on. The cell is on the first and only worksheet. Does anyone have any pointers? I cannot seem to find any documention. Tag: auto insert a date that is two weeks away Tag: 86521
  - 9
    - InsertFile() formatting problem (possibly a bug ?) Hi! I need to combine a few documents together in such a way that each document retains its formatting in the resulting document. I tried to put Continuous Breaks at the start and end of each document as described here: http://www.word.mvps.org/FAQs/Formatting/WorkWithSections.htm Unfortunately, that technique does not seem to work. Formatting changes anyway. To illustrate my point I created 3 documents AAA.doc, BBB.doc and CCC.doc that can be downloaded from here: http://www.freefileupload.net/file.php?file=files/310506/1149117631/FILES.zip or here: http://fileshare.variousstuff.net/0000000492/ I need to insert BBB.doc into AAA.doc so the resulting document has the same formatting as CCC.doc (formatting of AAA and BBB was preserved). No matter what Iâ??ve done to AAA.doc and BBB.doc, I could not make it look like CCC.doc. I am truly lost. Is this a bug I need to report to Microsoft? What can I do to preserve formatting with InsertFile()? Infinite thanks in advance, --Michael Tag: auto insert a date that is two weeks away Tag: 86514
  - 10
    - protection with text form field I am using a table in word document and added a text form field in the second row. I have inserted a REF field for the same in some other table column. when i use 'protect form' button in forms toolbar, then after inserting any value in text form field, when i do tab, it reflects in REF field. it works fine. but when i apply protection from Tools menu. then after doing Tab, it is not reflecting changed value in REf field. even, it stops calling any macros associated with text form field. I want to do this through coding. can anyone please suggest me what code runs in background for protection when i click on 'Protect Form' button. Tag: auto insert a date that is two weeks away Tag: 86513
  - 11
    - Export from Word Form to Excel Spreadsheet Hi: I tried reviewing previous postings on exporting form fields from Word to Excel and as I'm new to programming, I had some difficulty in following responses to the postings. So I thought I would start fresh and post a new question. If I were to create a form in MS Word 2003 (with text fields, number fields, checkboxes and dropdowns), what are the steps should I take so that when I send the form to someone and they complete the form (do a "Save As" and send the completed form back to me), I can take the information from the completed form and import the info into an Excel spreadsheet? Is there a tutorial that someone could perhaps suggest? Any help would be greatly appreciated. Thanks! Tag: auto insert a date that is two weeks away Tag: 86512
  - 12
    - where is Auto Format? Auto Format in Word 2003. You would type common words in auto format so that when you typed the first 2 or 3 letters you would press enter for that word to be automatically inserted.. IE Gerald, Ger (Gerald would appear & Enter would make Gerald). I have searched Word & Outlook & no Auto format. As I type my E-Mail johndoe@hotmail.com, all I would type is joh & I have the option of hitting enter for my E-Mail address to fill in. Gerald H Levine Tag: auto insert a date that is two weeks away Tag: 86511
  - 13
    - Autorun Word Macro Hi I have a normal word document that has a macro in it that provides a sequential number each time I open the document: Sub AutoNew() Order = System.PrivateProfileString("C:\Settings.Txt", _ "MacroSettings", "Order") If Order = "" Then Order = 1 Else Order = Order + 1 End If System.PrivateProfileString("C:\Settings.txt", "MacroSettings", _ "Order") = Order ActiveDocument.Bookmarks("Order").Range.InsertBefore Format(Order, "00#") ActiveDocument.SaveAs FileName:="path" & Format(Order, "00#") End Sub This works perfectly ok when I open the document and the select Tools, Macro, Run. What I would like to do is place this document on a server (so that it can be accessed by an number of users) but have it so that when anyone opens it, the macro will run automatically. (Without having to go to Tools, Macro, Run) Can anyone help me? Thanks John Tag: auto insert a date that is two weeks away Tag: 86508
  - 14
    - Word 12 Beta Is there a chat room/discussion group for Word 12 Beta? I am new to these chat rooms and could not find where to go. -- Butch Cassidy Tag: auto insert a date that is two weeks away Tag: 86506
  - 15
    - Eliminate extra pulldown menu entries for acrobat pdf & comments? I keep getting multiple pulldown menu entires for Acrobat PDF & Acrobat Comments. It is only the last set that is usable but nonetheless I currently have 10 sets of these menu options. How do I stop this from growing? Tag: auto insert a date that is two weeks away Tag: 86503
  - 16
    - green underlining during spelling check Hi, Does anyone know how to find the green wavy lines under incorrect grammar or spelling? Thanks for any tips, Regards, Gordon Filby Tag: auto insert a date that is two weeks away Tag: 86498
  - 17
    - Can't repeat nor redo VBA action The following applies to Word 2000, XP and 2003: I have written some VBA macros. When the users are using them, both the "Repeat" command in the "Edit" menu and the "Redo" button in the standard toolbar are greyed out. The "Undo" commands are okay though. One of the macros simply applies a style to the selected text: ActiveWindow.Selection.Style = ActiveDocument.Styles(sStyle) (sStyle being the tag of the action control clicked by the user) The users would like to repeat that command by using [ctrl]+[y] or by using [F4] instead of having to navigate to the action control with the mouse. How can I make the repeat/redo commands accessible for VBA macros, in particular the above command? Thanks in advance for any help! Sheila Tag: auto insert a date that is two weeks away Tag: 86495
  - 18
    - "file not found" when attempting to run macro from list While attempting to run any macro from the list that Word displays, I receive an error message of "file not found." This occurred right after running a macro successfully. The list of macros is surely there, as is Normal.dot, I believe with the same size it was before this started happening. As possible remedies (which didn't work), I ran the Office repair utility and set Windows back to the last restore point. I copy and paste the text of my macro modules to a file but I had done a lot of updating lately and hadn't done this backup procedure recently, and it would be really nice if I could figure this out and recover whatever it is that's missing. I did notice Norton running a check on Normal.dot before it happened so I guess it's possible that a virus got past Norton into the file. I have my macro security set on high (second from the top) and it says there is a viurs scanner installed, though I don't do all the updates like I should. Any ideas would be greatly appreciated. -- Bryan Tag: auto insert a date that is two weeks away Tag: 86494
  - 19
    - Customize Ribbon UI Posting here as I lack knowledge of a better place and in hopes a developer type is lurking around. I am looking for a step by step procedure (that actually works) for making a simple customization to the Word2007 Ribbon UI. All I want to do is add my own tab and add a button to that tab that will fire a macro. I have read and reread the article "Customizing the Office (2007) Ribbon UI for Developers Part 1 of 2 and tried the procedures listed there at least a dozen times and every time the resulting document won't open and generates and error that it is corrupted. Here is the procedure that I have tried: I opened an new file and created a macro as shown. I digitally signed the project. Sub MyMacro(ByVal control as IRibbonControl) MsgBox("Hello World") End Sub I saved the document as an Open XML Formats file that is macro-enabled and has the file name extension .docm. i.e., saved as Test.docm I created a file in Notepad with the following XML markup and saved it as customUI.xml: <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon startFromScratch="true"> <tabs> <tab id="CustomTab" label="My Tab"> <group id="SimpleControls" label="My Group"> <button id="Button1" imageMso="HappyFace" size="large" label="Large Button" onAction="ThisDocument.MyMacro" /> </group> </tab> </tabs> </ribbon> </customUI> I put customUI.xml in a folder on the desktop named customUI I then add a .zip exention to Test.docm i.e., Test.docm.zip The next steps says to "double-click the file name to open it for viewing" Hmm...I don't really follow this part as double-click a file with a .zip extension doesn't really "open it for viewing." It does open the WinZip application and I am able to perform the next steps. I add the customUI folder to the Zip container. I extract the .rels file to the desktop. I open the .rels file in the text Notepad I add the following line between the last <Relationship> element and the </Relationships> element, and then save and close the file: <Relationship Id="someID" Type="http://schemas.microsoft.com/office/2006/relationships /ui/extensibility" Target="customUI/customUI.xml" /> I drag the _rels folder from the desktop to the Zip container file. Remove the .zip extension from the container file. Finally I *try* to open the macro-enabled file in Word 2007 and an error message is generated indicating the is corrupt and contains content that cannot be read. John McGhee in attempting to offer a solution stated that: 1. I had to have a name to go along with "someID." I have no idea what name to use and the code snippet is copied word for word from the example in the article. 2. docm files are already zipped so ignore the bit about adding the .zip extension and open the file in Notepad using WinZip. I don't follow what he means and unless I add the .zip extension I don't see a .rels folder in the file container. I have no idea what I could be doing wrong and hopefully someone can step me through a precedure that works or perhaps direct me to a group that may be able to assist. Thanks. Tag: auto insert a date that is two weeks away Tag: 86487
  - 20
    - Word/Excel toggle I have a macro that picks up information from Word and pastes it into Excel. It then makes a couple additional changes and queues the user to review the results with a mesg box. If everything is well, the user selects OK and the macro continues with some additional changes. If not, the user selects cancel and makes some changes manually. This is my first attempt at toggling between Word and Excel so I have a vague understanding of what's happening, but it seems that all of the actions to be performed in Excel require "oXL." before the line of code. However, when I get the message box, placing oXL. before the line of code gives me a message of "Wrong number of arguments or invalid property assignment". However without it, it goes back to Word to prompt. It runs fine after that, but I can't review the information in Excel without switching back and forth. How to do I execute the message box in Excel? oXL.Workbooks("MyWorkbook.xls").Activate oXL.Sheets("sheet1").Activate oXL.ActiveSheet.PasteSpecial Format:="Unicode Text", Link:=False, _ DisplayAsIcon:=False oXL.Range("c1").Select oXL.Sheets("sheet2").Activate oXL.Range("A1").Select oXL.ActiveCell.Value = MyWordName oXL.Sheets("sheet1").Activate ans = MsgBox("OK?", vbOKCancel) If ans = 2 Then End If ans = 1 Then oXL.Visible = True oXL.Workbooks("MyWorkbook.xls").Activate oXL.Sheets("sheet1").Activate oXL.Range("c1").Select oXL.ActiveCell.Value = MyWordName Tag: auto insert a date that is two weeks away Tag: 86486
  - 21
    - WordART in a protected word document Can WordART be used in a protected word document? The document has been protected to prevent users from changing the appearance of the document/template (EG. Letterhead), but now they arn't able to use any WordArt... Is there a way of allowing the users to use WordArt on a protected document? Tag: auto insert a date that is two weeks away Tag: 86484
  - 22
    - Converting the first character of a name to a capital? Good day all, I have a problem of which I hop you can help me out with. I have a userform to put in personal data of a client. The data my collegues put in will be ending up in al letter. Now, in one ocasion Someone's name is for example Guus van Waardenburg. When you write the name with the first name 'van' needs to be written in lower case, when you only write the last name, 'van' needs to be starting with a capital like this: 'Van Waardenburg', how can I put this in my code? My Code: Selection.GoTo What:=wdGoToBookmark, Name:="Aanhef" If TextBox4.Value = "" Then If Not TextBox3.Value = "" Then Selection.TypeText TextBox10 & " " & TextBox3 & " " & TextBox1 & "," Else Selection.TypeText TextBox10 & " " & TextBox1 & "," End If ElseIf Not TextBox17.Value = "" Then Selection.TypeText TextBox10 & " " & TextBox17 & " " & TextBox4 & "," Else Selection.TypeText TextBox10 & " " & TextBox4 & "," End If Can someone help? (TextBox17 = van) Tag: auto insert a date that is two weeks away Tag: 86480
  - 23
    - Error 4198 wdfieldlink and wdfielddocvariable - breaking & unlinki I have a word template which has a number of graphs (wdfieldlinks created by inserting manual Excel graph links with copy/paste special/link) and variables taken from a user form (wdfielddocvariable). I have tried a number of ways to get the newly created word doc to update the graphs and docvariables, and then break the links - but have reached a dead-end. The unlink method, if sent to the fields property of the active document, appears to stop the update method for wdfieldlinks, but not wdfielddocvariables - so I end up with a doc that has incorrect graphs - but correct, updated data. So, I have used the following code after the general update command in order to break the links / unlink the links by field type: Activedocument.fields.update For Each fldElement In .Fields Select Case fldElement.Type Case wdFieldLink fldElement.LinkFormat.BreakLink Case Else fldElement.Unlink End Select Next This gives me the error 4198. I am new to VBA programming and am learning from books (which I'm finding can be quite vague) so apologies if this is an elementary problem. Any help would be very gratefully received. jag777 Tag: auto insert a date that is two weeks away Tag: 86479
  - 24
    - Put each letter on a seperate line? Hi all, I want to get a vertical list of letters in a word document and cant figure out how to do it... Basically I want 'The quick brown fox' to end up looking like" t h e q u i c k b r o w n f o x Using ^l (Manual Line Break) can get it to do: The quick brown fox But thats not what Im after, I need each letter to be on a seperate line of its own. Its to sort a paragraph of Chinese or Japanese text so each character is on a seperate line. The list will then be copied and pasted to an excel worksheet so I dont know if I can bypass word altogether and do it all in excel. I'd really appreciate any help on this, it's driving me crazy! Thanks in advance :>) Tag: auto insert a date that is two weeks away Tag: 86476
  - 25
    - Text in Help Hi, When I use Help, the symbols above, for example Examples, are just empty buttons. It wonâ??t help to repair Office XP. I get the same error if I open the file FM20.CHM directly. Any hint will be very much appreciated. / Ulf Tag: auto insert a date that is two weeks away Tag: 86474
- Next
  - 1
    - Word 2003 Saving template Hello all, When I open a template in Word 2003 and I want to save it always gives a warning that autext entries will not be saved. The only way is to use Save as... any suggestions? Tag: auto insert a date that is two weeks away Tag: 86473
  - 2
    - Document length and print options I'm setting up a macro for form printing and I need help with the final details. 1. How would you go about determining a document's length and default the auto print to exclude the last page. 2.Then giving the user the option (via InputBox) for including the last page. Thanks in advance for any help! -ithaca Tag: auto insert a date that is two weeks away Tag: 86470
  - 3
    - word i install word on my desktop which no longer works so now i'm trying to install it on my laptop but when i put in the product key it says the key is not invalid Tag: auto insert a date that is two weeks away Tag: 86466
  - 4
    - Save changes to Document 1? Help - I can't get rid of this question. Using an AutoExec module, there is a subroutine to ensure that the Normal style has correct font and font size as per our company standards. However, this gives rise to the 'Save changes to Document 1?' question on exit from Word - even when changes are not made. The "ActiveDocument.AttachedTemplate.Saved = True" code was my attempt to get rid of the pesky message! Sub SetNormalStyle() If (ActiveDocument.Styles(wdStyleNormal).Font.Size = 11 And _ ActiveDocument.Styles(wdStyleNormal).Font.Name = "Arial") Then GoTo EndLabel With ActiveDocument.Styles(wdStyleNormal) .AutomaticallyUpdate = False .BaseStyle = "" .NextParagraphStyle = "Normal" End With With ActiveDocument.Styles(wdStyleNormal).Font .Name = "Arial" .Size = 11 End With EndLabel: ActiveDocument.AttachedTemplate.Saved = True End Sub -- Patricia D Tag: auto insert a date that is two weeks away Tag: 86461
  - 5
    - works word 'play' w/ 97word????? I like and have used word 97 but when I moved to a computer that has 'works word', and then download my , 'word 97' I get problmes. Do these two word programs not mix? I hve alot of old files that I used 97 word with, and I wold like to stay with word 97. The word 97 came with my old DELL, and the computer I am using now is a 2000 with Windows ME. Is there any way to make "them" play nice? thanks. cl. Tag: auto insert a date that is two weeks away Tag: 86459
  - 6
    - Arabic letters I load a text file, encoded, with the first two bytes being xFFFE. I type in Arabic and see the Arabic letters be changed into their correctly formed shapes as I type. These displayed characters are in the Arabic UNICODE range of xFE80 to xFEFF. But when I save the file, the characters that are saved in the file are in the UNICODE range of x0600 to x06FF. These are only the isolated forms of the Arabic characters - these are the keystrokes as delivered by the keyboard. I need to save the well-formed characters that are displayed, not the isolated forms. I need to use the well formed characters in another application. How can I do this? Why does MSWord display one thing and save another? Thanks Tag: auto insert a date that is two weeks away Tag: 86458
  - 7
    - jpg files to display on Form I have a series of radio button choices on a form. When the user selects one of these and the OK button clicked, a particular macro is run. I also want to have a corresponding jpg image to appear on the right side of the form, to give the user a visual of the style they are choosing, so they can click through the radio buttons and see the different choices. What would be the best approach for this? Thank you for your time. Tag: auto insert a date that is two weeks away Tag: 86457
  - 8
    - Closing Word Documents When closing the last open document, the program should continue to run instead of closing Word completely. Excel seems to do this correctly. I personally like having two sets of buttons where the bottom set is the document and the top set is the program. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=9594957b-5424-4c0a-b277-e6a333fa63da&dg=microsoft.public.word.vba.general Tag: auto insert a date that is two weeks away Tag: 86455
  - 9
    - printer In a single file i have the main document and then 5 parts attached. Every single part attached starts with the word "Included" I would like to know how can i print from page "n1" to page "n2" testing the word included cause i need different printers for it. thanks Tag: auto insert a date that is two weeks away Tag: 86453
  - 10
    - Dumb question about MS Forms I just set up a new computer and for the life of me can't figure out where to change the default font for objects put on forms. It seems that with this computer, I keep getting Tahoma 8 pt. I want something different. Whenever I edit a control on this computer, it changes the font of whatever object I am on. Thanks Suzette Tag: auto insert a date that is two weeks away Tag: 86452
  - 11
    - Creating a COM Addin I don't know if I am posting in the right place or not. I downloaded the Word2007 Beta2 on Friday and have spent much of the past weekend frustrated over how difficult MS has made it for a user to make simple customizations to the UI. At first I thought that it simply wasn't possible but to my relief I have stumbled upon several MSDN articles that claims it can be done and done easily. After reading these articles i have no doubt that the ribbon UI can be customized, the easy part remains to be seen. It does appear that a user can not make customizations to the ribbons simply by exploring and using the available commands. To do so, you have to become a "developer" of some degree of skill. For the present I need to learn enough developer skill to make simple customizations. For example, I would like to create my own tab and then be able to assign buttons to that tab that will fire macros. This would be similiar to creating a toolbar and assigning macros to buttons on the toolbar earlier Word versions. I read in one of the articles that in order to apply Ribbon UI customizations application wide they need to be created as a COM Addin and that these add-ins could be created using VBA. First question: Can anyone provide guidance for creating a COM Add-in? The other part of the process is developing XML code that actually does the customization. The documentation indicated that this XML code could reside in an exterally XML file or withing the Add-in itself. It appears that making customization is only going to be easy if you know a little bit more than absolutely nothing about XML (my case). However, applying to concept monkey see, monkey do, I think that I could gain enough proficiency to get by if I could only see enough to get started. My objective is to see how an COM Add-in is coded, loaded, applied, etc. that then applies XML (either in the Add-in or from an external file {actually both ways would be most helpful}) to customize the Ribbon. Just a simple example to add a custom tab, with a button, that calls a macro. If there is a better place to post this question then please advise. Tag: auto insert a date that is two weeks away Tag: 86446
  - 12
    - Enter "example" once then auto replicate through document. Hi Hoping you can help - i've dealt with excel alot in the past but not word. I have a template document I use alot at work. What I'd like is to have a table or something on the first page with say: City: Device name: I'd then come along and fill in: City: myCity Device name: myDevice Then throughout the document "City" would be replaced with myCity and likewise with Device. Is this possible in word? It'd save me having to do a million cut and pastes every other day. Perhaps it's possible to like the document to excel? Thanks for your help John Tag: auto insert a date that is two weeks away Tag: 86445
  - 13
    - pasting OLE objects from SQL/ADODB I have a project where users enter information into an Access front-end with an SQL Server backend (a project run by another group). I need to pull the information from SQL and insert it into a Word document. All is going well, except for a field within the database which contains an image of a chemical structure. According to the database owner, the control in Access is an OLE object where users "paste" these images that they copy directly from Chemdraw or ISIS, two programs for generating the chemical structure images. the OLE Data is saved to the database in an IMAGE field. I'm currently using GetChunk to grab the LongVarBinary field and save it to a file, but I can't get the image to display. I have no idea what type of content was pasted into the OLE field for each record, it may be one of several data types and none of the possible extensions seems to be working. So my question for any gurus is: Is it possible to utilize this OLE/image data? How would I go about bringing it into Word? Tag: auto insert a date that is two weeks away Tag: 86444
  - 14
    - how to find out path of template the Document is based on HI, I wrote templates and is saved in one folder Templates on Server. In Templates is Folder Address and there are *.doc files with addresses,which I use in my Templates to generate diferennt address in Document. My Path to the files was complety path example "C:\Doc\..\Templates\Address but I would like to do relative path. It should find out the Path of .dot file the document is based on + \address and that would be. Q1: can I find out Path of the template the doc is based on. or you have just another solution. take in mind that the location of templates could change and that adress folder/files have to be in seperates doc due to administration.Can happent that address change and then there is no need of changing the macros. just update the file or path. thanks Tag: auto insert a date that is two weeks away Tag: 86439
  - 15
    - Word Reference header/footer files Greetings All- PHP, CSS, HTML and other formats can use include or references to pull in other files as part of a document. My question is can Word pull files for a header and footers, and possibly content for a disclaimer? We currently have hundreds of templates, and to edit our disclaimers takes a good amount of time opening, editing, and saving each individual document. This method could ideally edit one file, and reference it to all the other documents. We are currently running the Office 2000 Suite and I assume if this is going to be possible, it will require vb. Thanks, Esteban B. Tag: auto insert a date that is two weeks away Tag: 86438
  - 16
    - A lot of KeyBindings Hi All, I defined a lot of keybindings. Only the first one is working. Any idea? Sub Toetsen() CustomizationContext = ActiveDocument.AttachedTemplate KeyBindings.Add KeyCode:=BuildKeyCode(wdKeyAlt, wdKeyT), KeyCategory:= _ wdKeyCategoryMacro, Command:="Invoegen.Tip" CustomizationContext = ActiveDocument.AttachedTemplate KeyBindings.Add KeyCode:=BuildKeyCode(wdKeyAlt, wdKeyW), KeyCategory:= _ wdKeyCategoryMacro, Command:="Invoegen.Waarschuwing" CustomizationContext = ActiveDocument.AttachedTemplate KeyBindings.Add KeyCode:=BuildKeyCode(wdKeyAlt, wdKeyI), KeyCategory:= _ wdKeyCategoryMacro, Command:="Invoegen.Visionummer" CustomizationContext = ActiveDocument.AttachedTemplate KeyBindings.Add KeyCode:=BuildKeyCode(wdKeyAlt, wdKeyH), KeyCategory:= _ wdKeyCategoryMacro, Command:="Invoegen.Helpfunctie" CustomizationContext = ActiveDocument.AttachedTemplate KeyBindings.Add KeyCode:=BuildKeyCode(wdKeyAlt, wdKeyR), KeyCategory:= _ wdKeyCategoryMacro, Command:="Invoegen.Rapport" End Sub Tag: auto insert a date that is two weeks away Tag: 86436
  - 17
    - second combobox in form won't dropdown I have two comboboxes in my form and I use the dropdown property to display both (not at the same time). The second dropdown command is ignore however. It will drop down if I click the down-arrow. A possible hint - when I exit word after running this macro, it tells me I have an open dialog box and that I must first close it. I can find no dialog box to close. Tag: auto insert a date that is two weeks away Tag: 86435
  - 18
    - How do I incorporate this into one macro. Hello from Steved Sub Win2() Selection.HomeKey wdStory Selection.Find.ClearFormatting With Selection.Find Do While .Execute(FindText:="F [0-9]:[0-9]:[0-9]", MatchWildcards:=True, Wrap:=wdFindContinue, Forward:=True) = True Selection.Range.Delete Loop End With End Sub How do I turn on the extend then find Font 30 and once found and highlited move back by -2 count and then delete, and now put this in the above macro please. Please look at the below to give yourself an Idea as to what I am trying to do. Selection.Extend Selection.Find.ClearFormatting With Selection.Find.Font .Size = 30 .Bold = True End With With Selection.Find .Text = "" .Replacement.Text = "" .Forward = True .Wrap = wdFindAsk .Format = True .MatchCase = False .MatchWholeWord = False .MatchWildcards = False .MatchSoundsLike = False .MatchAllWordForms = False End With Selection.Find.Execute Selection.MoveLeft Unit:=wdWord, Count:=1 Selection.Delete Unit:=wdCharacter, Count:=1 Thankyou. Tag: auto insert a date that is two weeks away Tag: 86430
  - 19
    - Toolbar in Add-inn visible when a specific template is open Hi All, As default an add-inn is open when Word starts. In the add inn a toolbar is visible=false. When the user open a specific template (Proposal template) in Word the toolbar in the Add-inn must be visible. Anyone any idea? The VBA code in the Proposal template can't be changed. Tag: auto insert a date that is two weeks away Tag: 86429
  - 20
    - WDReportGen 3.2 Released! - Report Generator for Microsoft Word WDReportGen is a report generator for Microsoft Word that outputs reports in Microsoft Word document format. If you know how to use Microsoft Word and write SQL statements, you can use WDReportGen to create all kinds of reports as you need. Benefit: * Use Microsoft Word as your reporting tool. * Easy to use. Just Microsoft Word and SQL. * Powerful and flexible. Microsoft Word are powerful and flexible. * Saves money. Do not need to buy extra costly reporting tools. * Saves time. Reduce development time and training time. * Improves productivity. Reports are in familiar formats. * For various users: IT users, business users and developers. Features: * Using Microsoft Word as your reporting tool * Making report template directly using Microsoft Word * Accessing databases using SQL * Creating reports without programming experience * Connection to all databases using ODBC * Supporting multi-databases in one report * Generating reports with parameters * Supporting Windows mode and command line mode * Creating complex reports * Creating reports with charts * Creating reports with pictures * Many reports in one Microsoft Word document * Conversion of file formats * Generating reports automatically * One time configuration * Flexible deployment Contact: WEB: http://www.ljzsoft.com Email: support@ljzsoft.com Tag: auto insert a date that is two weeks away Tag: 86424
  - 21
    - using Word I want to use Word to design web pages yet I do not want Word as the default web editor is this possible? Tag: auto insert a date that is two weeks away Tag: 86414
  - 22
    - Paste as HTML into a cell Hi, I'm doing a macro that connects to a web site, reads one page, and save its contents inside a cell of table. Basically I'm doing the following; Set objHTTP = CreateObject("MSXML2.XMLHTTP") objHTTP.Open "GET", strURL, False objHTTP.Send Selection.Text = objHTTP.ResponseText The problem is that Word doesn't recognize the text as html, so, I can see the source of the page. I want to paste it as a HTML. Another problem is that I'm using a table. So, I tryied to use Selection.Paste, but it doesn't work. TIA, Tag: auto insert a date that is two weeks away Tag: 86412
  - 23
    - Insert WMF file in the word document Hi all, I'am trying to insert WMF file in the word 2000 through code. If there are more then 2 pages in the document it gives me error and the autoshape property gets lost of the WMF file.This WMF file can be inserted through insert picture-> from file option. when you do this manually the WMF gets inserted as autosahpe or else it get inserted as picture. The error which i get is as follows:- Microsoft Visual Basic --------------------------- Run-time error '-2147467259 (80004005)': Can't move focus to the control because it is invisible, not enabled, or of a type that does not accept the focus. --------------------------- OK Help Please let me know solution for this. Thanks in advance. -Sajin Tag: auto insert a date that is two weeks away Tag: 86402
  - 24
    - Attach a web page Hi! Is it possible to get the source code from an active web page using VBA-Word? I have an open web page in IE, and need to catch some info from the source code and put it into my active Word-document. -Ole Tag: auto insert a date that is two weeks away Tag: 86400
  - 25
    - Wildcards and templates Hi all, If a specific template is active a toolbar must appear. The template has one little thing: It has a versionnumber. So I am looking for a code something like: If Activedocument.attachedtemplated="Proposal" & * then CommandBars ("test").visible=true end if The first line doesn't work. Anyone any idea? Tag: auto insert a date that is two weeks away Tag: 86390

I'm working on a letter that will generally be used as a form letter. In the
letter we refrence a date that is always two weeks from the date that the
letter is written. Is there a way to automatically insert this date?

Thanks in advance,

Top

Re: auto insert a date that is two weeks away by garfield-n-odie

garfield-n-odie
Thu Jun 01 14:07:07 CDT 2006

See http://www.gmayor.com/insert_a_date_other_than_today.htm .

RobbyVegas wrote:

> I'm working on a letter that will generally be used as a form letter. In the
> letter we refrence a date that is always two weeks from the date that the
> letter is written. Is there a way to automatically insert this date?
>
> Thanks in advance,
>

Top

Re: auto insert a date that is two weeks away by Charles

Charles
Thu Jun 01 16:39:28 CDT 2006

This is more complex than you might imagine, but it can be done. See
http://addbalance.com/word/datefields2.htm for information on the different
kinds of ways to make a date calculation work. It includes links to
utilities to create the fields and an explanation of different macros that
can be used instead of fields. It also has a link to
www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902 which is a document
with various fields already created. Another resource is
http://www.gmayor.com/insert_a_date_other_than_today.htm.

--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"RobbyVegas" <RobbyVegas@discussions.microsoft.com> wrote in message
news:CD49FED8-57B5-4250-877F-5CB544E194BD@microsoft.com...
> I'm working on a letter that will generally be used as a form letter. In
> the
> letter we refrence a date that is always two weeks from the date that the
> letter is written. Is there a way to automatically insert this date?
>
> Thanks in advance,
>

Top