XML seed file, "lost" VB macro and WML2XSLT.EXE

Tutorials Win: Microsoft Windows Forum

- Previous
  - 1
    - How can I represent a Greek character and Unicode in a macro? How can I represent a Greek character and Unicode in a macro? Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81220
  - 2
    - Table text wrapping property from VBA? Is there any way to retrieve/set the "Text Wrapping" property (None/Around) of a table programmatically? I have weird problems inserting text into text-wrapped tables and need to temporarily change this option while I manipulate the table's contents. Thanks, Chris Peacock. Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81219
  - 3
    - Out of memory I have created a template which runs a macro containing a form and some code in a module. But if Word has (or have had) several instances of a document created from the template open the user gets a â??out of memoryâ?? error when the macro runs. If all instances of word are closed the macro runs again and functions probably. I figure itâ??s because the form and the module isnâ??t unloaded probably. I have tried to insert an â??Unload Meâ?? statement in the form instead of hide. But itâ??s the same. How can I avoid getting â??Out of memoryâ?? errors? Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81215
  - 4
    - Insert Graphics and other objects in a Word Document I've been reading the help and I'm still confused. I'm trying to get a grip on the Word Document Hierarchy, but to no avail. Section, Range, HeaderFooter ??????? The specific issue is, I want to insert a graphic at a specific point in an existing Word document. In my case, the graphic will go in the header of the first page, where from there it should of course show up on the remaining page's header area. I'm using a VBA in an Access module, opening the document.... from there I would like to insert the graphic (from a file) then position and resize, etc. ...save the document and move on to the next. I would like to start with a document where there is a pre-existing graphic that says "Insert Graphic Here". This "blank" graphic will be in the exact same place where the new graphic will be inserted. So...I would like to open the doc, find the "blank" graphic, delete it, insert the new graphic, position and resize (if necessary), save, and move on to the next doc. The "blank" graphic is not really necessary because the following code works (though I'm sure, it cant be proper method), without a "blank". However, there are some docs where there is a graphic in the header already (btw there are sometimes 2-3 total, even distributed, ie non-overlapping), so I would need a method to "find" the existing graphic and delete it. Here's the code I'm using now 'The app and doc are open already, at this point... Dim objShp As Word.Shape Dim objRng As Word.Range Set objRng = objDoc.StoryRanges.Item(wdPrimaryHeaderStory) ' I'm guessing here... Set objShp = objDoc.Shapes.AddPicture(filename:="C:\My.gif", LinkToFile:=False, Anchor:=objRng) With objShp .Height = InchesToPoints(1) .Width = InchesToPoints(1) .Left = InchesToPoints(0.25) .Top = InchesToPoints(0.25) 'Do I need to use relative positioning? End With I'm expecting a way to insert an object at any "coordinate" onthe document in general or within a specific "section" (a word I use to describe, Header, Footer, or Page Body) I'm just not sure how to specify the Header, Footer, Body, or just the document in general. The general idea is to start with a base set of documents with a "blank" graphic in the header. For any reason (a new project, client, etc), create a new set of documents from the originals where the appropriate graphic is inserted in the same place where the "blank" graphic was, thus creating a set of docs specific to a client or project or whatever. The point is, I feel that my current method is a lucky guess, or a "hack" and I can't seem to glean any proper methods from the confusing, help. Any ideas or references would be appreciated. TIA Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81207
  - 5
    - PAGEREF field help! Please We are in the process of creating a directory book at work with about 5000 resources in it. Now the problem is: When it originally was merged after hand tweaking (removing some items, spaces, etc.) it seems it was merged with errors such as page numbers don't match in the <pageref></pageref> field. My desparate question is - Is there an easy way to resort the document so that the PAGEREF fields are corrected? ie - right now let's say the product Window Pane is on page 45 but the merged document Table of Contents says it's on page 256 (this is what is in the tags <pageref></pageref>. I cannot start from scratch as too many fields have been edited but I'm going crazy now and need an easy way to correct. PLEASE HELP! -- Mich Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81204
  - 6
    - enable option buttons at runtime i have a userform with two listboxes, and six optionbuttions. the options buttons are split into 3 pairs of two. at the outset only the first pair of option buttons is enabled. the following code tests to see if more than one selection is made in a listbox, and if it is, then enables a relevant pair of option buttons. Private Sub Listbox1_change() 'check to see if there is a multiple selection Dim i As Integer Dim Acount As Integer Acount = 0 With Userform1.Listbox1 For i = 0 To .ListCount - 1 If .Selected(i) Then Acount = Acount + 1 End If Next i End With If Acount > 1 Then Userform1.OptionButton5.Enabled = True Userform1.OptionButton6.Enabled = True End If Userform1.Repaint End Sub this code works fine, when i run the code, by stepping through it. In fact i don't need the Userform1.Repaint line, when i run it this way. But the appearance of the userform doesn't change when i run the code normally. Is there some other trick to getting this change to happen? thanks for your help. Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81202
  - 7
    - Re-post Chad, This message refers to a previous post dealing with auto popoulating multiple pages of forms with repetitive info. I am trying to create a single document that has four separate forms. The of the two of the forms use the same information. I form is built on pleading paper. 1. How do I add these forms into one document? 2. I would like to auto populate the two similar for forms. My attempts at this have failed thus far. I also discovered while trying to copy the form built on pleading paper, the vertical lines running the full length of the paper do not transfer. I also discovered that trying to add a new page after this form resulted in the new page being formatted as pleading paper. Any help would be verrrrrrrrrrrry appreciated!!!!!!!! Thank You, mojr Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81200
  - 8
    - Send mouse event in Word? Is there anyway to send a left mouse click event? I just need to have it click down once where my cursor is. The reason behind this is that I am using a webbrowser to display my Word Document and it is losing focus after I insert a bookmark from my ActionsPane. Anyway, is it possible to send a mouse event that way? Thanks! -- Brenda Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81194
  - 9
    - Form Fields & UserForms Interactions HeLp! Great Forums for everthing Office but sometimes there is a lot of reading required when you want to do something that seems simple and to no avail! Here is the issue: Our firm uses templates to create Functional Analsys Documents. The first two pages of the FA Doc have on them two types of form fields. (Hopefully I got all the terminology correct as I am a newbie to this type of programming.) Ones that can be edited by the user and ones that can get updated by refrence when pressing the <F9> function key from within the field. I wanted to simplify this by creating an optional user form that can be called up through a Custom Menu. I have manage to do so but I'm running in to updating the text fields in the user form correctly. The first time I use the user form the defaulted values from the form fields get displayed in the user form correctly. I used the following code when initailizing the user form; Private Sub UserForm_Initialize() With UserForm1 .TextBox2.Text = ActiveDocument.FormFields("Text2").Result .TextBox1.Text = ActiveDocument.FormFields("Text1").Result .TextBox3.Text = ActiveDocument.FormFields("Text6").Result .TextBox4.Text = ActiveDocument.FormFields("Text4").Result .TextBox5.Text = ActiveDocument.FormFields("Text3").Result .TextBox6.Text = ActiveDocument.FormFields("Text5").Result End With End Sub Which I obtained through reading in this forum. I attached the follwoing code to a command button that update the form fields without killing them ( I had some trouble keeping the form fields in tact until once again you forum came to the rescue); Private Sub CommandButton1_Click() With ActiveDocument .FormFields("Text2").Result = TextBox2 .FormFields("Text1").Result = TextBox1 .FormFields("Text6").Result = TextBox3 .FormFields("Text4").Result = TextBox4 .FormFields("Text3").Result = TextBox5 .FormFields("Text5").Result = TextBox6 End With UserForm1.Hide End Sub All runs A-Ok until I change the value on the actual FA Document by clicking on the form field then calling up the user form through the custom menu. The values in the user form recall the previous values that I entered the last time I used the user form. It's as if the user form has a buffer that doesn't get reloaded after the first time the user form is called up. How can I have the user form reflect the changes of the FA Doc fields No mater how menay time the user form is called up? I want to be able to edit these field from either the FA Doc form fields or the new user form but alway displaying the correct values! I have done quite a bit of reading that my eyes a bugging out and can't hurdle this one yet! HeLp! -- Thanks, Bugs Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81187
  - 10
    - how does a check box work? clk'ng on it = nothing ? boswell6@sbcglobal.net <- recently new Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81175
  - 11
    - Word VBA Code Cleaner I've seen several suppliers of Excel VBA Code Cleaners, but none that is focused on Word VBA. Any knowledge/opinions out there? /BosseH Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81174
  - 12
    - track changes and Reviewer (WP) - compatible? I've got WP 12 and use Reviewer (which is Track Changes in WORD). Has anyone been able to view both the Word and WP "changes"? ex. If I Review a document in WP then send it to a Word person for them to Track Changes will they see my WP Reviewer edits? thx. krista Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81164
  - 13
    - Large Document Creation We have created a program in VB & VBA that assists users in creating midsize documents daily. There will be one file for each day anywhere from 3-25 pages in length. We need to combine these documents once a year into one large file to be published into a book. The document is straight text. No images. In the end it will be approximately 1500-2000 pages in length including table of contents and index. We hope to index and do TOC using Word's automated features. Before we attempt this I would like to know any limitations of Word. Can Word handle a document of this size? What do we need to do to prevent file corruption? Are there any special steps we need to take? What is the easiest way to combine all the daily files into one at the end? We looked at Master Docs but read about corruption. Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81163
  - 14
    - Filling in School Dates in Word? Hi all-- I think I've reached the point where I need to program in Word. I teach a class, and my syllabus lists each class number, the day and date, and the assignment. I get tired of manually replacing the dates each semester and would like to do it automatically. This is what I'd like: Class #1 <Day>, <Date> Assignment So if I teach every Tuesday in fall of 2006, I'd like to give it the start and end dates (8/22/06 first day of class, 12/12/06 last day of class) and have it fill in the proper dates for each class throughout the semester. If I were to teach every Monday and Wednesday, I'd like it to fill in everything from 8/21 to 12/13 that semester. To add to the confusion, it would be nice, but maybe not possible, to have it skip spring break holidays or other days off. Maybe I could input which dates classes are canceled and have it adjust accordingly. Am I asking too much? Thanks for any help. --- Peg ladypegasusgarbage@yahoo.garbage.com Take out the garbage!! Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81162
  - 15
    - Word VBA causing my outlook to freeze up. I am having problems with my Outlook freezing when I run macros containing WORD VBA in them. I posted this to the Outlook forum, but the MVP there suggested I try here as it is the Word VBA code that seems to be causing this. Since outlook is set up to use word as my email editor I want to be able to take advantage of macros stored in my Normal.dot template to perform some simple text searches & replacements. After running a macro in an email message window (new messages or replies) , the send button along with every other button/tool on that row of Outlook toolbars (i.e. the Accounts drop-box, the attachment icon, address book button, options, etc.) becomes disabled. I kind of need the SEND button! I click, but nothing happens. The buttons are all dead. They no longer change color when hovered over, or animate, etc. I've tested it on 3 machines at work as well as my computer at home and can replicate it 100% of the time. I have isolated the problem to one Selection.Find statement, but haven't done any exhaustive testing to be sure something else can't trigger it as well. Here's the example: Sub RemovePhone() ' ' RemovePhone Macro ' Macro recorded 2/14/2006 by JG ' Selection.Find.ClearFormatting Selection.Find.Replacement.ClearFormatting With Selection.Find .Text = "^#^#^#-^#^#^#-^#^#^#^#" .Replacement.Text = "" .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = False .MatchWholeWord = False .MatchWildcards = False .MatchSoundsLike = False .MatchAllWordForms = False End With Selection.Find.Execute Replace:=wdReplaceAll End Sub The last statement in the sub -- the Select.Find -- is the only one that, if commented out or removed, stops the freezing behavior. Any help would be greatly appreciated as this is driving me crazy and slowing me down having to manually replace text in each message. Thanks! Jim (Using Office XP Pro SP3 with windows XP Pro.) Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81161
  - 16
    - Word VBA causing my outlook to freeze up. I am having problems with my Outlook freezing when I run macros containing WORD VBA in them. I posted this to the Outlook forum, but the MVP there suggested I try here as it is the Word VBA code that seems to be causing this. Since outlook is set up to use word as my email editor I want to be able to take advantage of macros stored in my Normal.dot template to perform some simple text searches & replacements. After running a macro in an email message window (new messages or replies) , the send button along with every other button/tool on that row of Outlook toolbars (i.e. the Accounts drop-box, the attachment icon, address book button, options, etc.) becomes disabled. I kind of need the SEND button! I click, but nothing happens. The buttons are all dead. They no longer change color when hovered over, or animate, etc. I've tested it on 3 machines at work as well as my computer at home and can replicate it 100% of the time. I have isolated the problem to one Selection.Find statement, but haven't done any exhaustive testing to be sure something else can't trigger it as well. Here's the example: Sub RemovePhone() ' ' RemovePhone Macro ' Macro recorded 2/14/2006 by JG ' Selection.Find.ClearFormatting Selection.Find.Replacement.ClearFormatting With Selection.Find .Text = "^#^#^#-^#^#^#-^#^#^#^#" .Replacement.Text = "" .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = False .MatchWholeWord = False .MatchWildcards = False .MatchSoundsLike = False .MatchAllWordForms = False End With Selection.Find.Execute Replace:=wdReplaceAll End Sub The last statement in the sub -- the Select.Find -- is the only one that, if commented out or removed, stops the freezing behavior. Any help would be greatly appreciated as this is driving me crazy and slowing me down having to manually replace text in each message. Thanks! Jim (Using Office XP Pro SP3 with windows XP Pro.) Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81160
  - 17
    - VBA code merge Word doc with Excel data Trying to come up with VBA code from within Excel that will mail merge a MS Word document called NewComerTaxLeads.doc with the opened data sheet called 2006 in a workbook called NewComerTaxLeads.xls. I would really appreciate any & all help you can give me. mikeburg Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81159
  - 18
    - Copying field headers when exporting data I'm creating a VBA script in Access that will take data selected by a basic query, place it in an Excel worksheet, and format the data. I cannot figure out how to take the headers from the fields I select in the query and place them at the top of the Excel sheet. I do not want to hardcode the field names, as this script will be reused on various datasets. Anyone have a suggstion? Thanks, Andrea Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81158
  - 19
    - Command line arguments for "Open and repair" ? Hello, I would like to know if this is possible to open a file with the "Open and Repair" option with some command line argument. It would be something like: Winword Mydoc.doc /[open and repair tag] Thanks Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81155
  - 20
    - Template causes Word to Crash--Recompiling fixes problem We have a fairly sophisticated MS Word template. The last version that we sent to our users gave us a real surprise. Many of our users had Word crash when they opened a document that was based off the Template. Word would give the error that reads something like "couldn't read memory at location xxxxxx to yyyyyyy". It would also crash with the same error when they created new documents based off the template. To fix it, we went to their PC, opened the template, compiled the template, then saved the template. Word worked fine after that. Can anyone offer any general troubleshooting techniques? I don't even know where to begin on what could be causing this. Thanks in advance for the help! Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81150
  - 21
    - macro help I created a macro in bold type, the strange thing is that it only comes out bold every other time! How do I resolve this..Thank you Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81142
  - 22
    - common dialog control in word VBA Hi I have written a macro that pulls data in from an excel sheet and puts it in a word doc. I want to allow the user to select which excel file they want to use by ideally using the common dialog control to allow them to navigate to the file they want. Is there any way of doing this, particularly without using a form to trigger the dialog control. I have had a look round the net and it seems a WinAPI call(s) are required. Any help would be appreciated. Thanks Martin Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81132
  - 23
    - How to copy all textbox content of doc1 to doc2 - and back? In a document, various text boxes with formatted text, even with tables in them, exist. I would like to cut all textbox content in all text boxes and copy it to a second document for editing, and once edited, move the content back to the original textboxes. I have this macro (see below), but it copies (it should cut) and it deletes all formatting and tables. Is there a better way to cut? How do I get the content back to the original textboxes? Shirley Nomey. Sub CopyFromTextBoxes() Dim I As Integer, Boite As Shape, ThisDoc As Document Set ThisDoc = ActiveDocument Documents.Add For Each Boite In ThisDoc.Shapes If Boite.Type = msoGroup Then For I = 1 To Boite.GroupItems.Count With Boite.GroupItems(I).TextFrame If .HasText Then Selection.InsertAfter .TextRange Selection.InsertParagraphAfter Selection.Start = Selection.End End If End With Next Else With Boite.TextFrame If .HasText Then Selection.InsertAfter .TextRange Selection.InsertParagraphAfter Selection.Start = Selection.End End If End With End If Next End Sub Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81131
  - 24
    - putting signature in document I would like to know how to sign a document after completing my work Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81130
  - 25
    - Populating a document form a userform I have a userform which populates an address formfield on a letter, the trouble with it is when the second and subsequent lines are entered then a square precedes the text. Is there anyway that these squares can be removed? To have the userform populates just a bookmark would normally resolve the situation but I have a textbox which needs to be populated which is over a picture and all the text is populated into that unless I use formfields! Any other solutions would be greatly appreciated though. -- Mark Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81126
- Next
  - 1
    - Accessing VBA code from external program through Automation Hi, is it possible to extract the VBA source stored in a DOT from an external program using the Word Automation interface? Second, is it possible to alter this source code from an external program? Thanks in advance, Jo Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81124
  - 2
    - Disable X Hi all, is there any way to hide or disable X button (at the top right of the window) to avoid a user to close Word? Thanks in advance. Mauricio Barcelona, Spain Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81122
  - 3
    - range horizontal position on page I am using the Information property with the parameter wdHorizontalPositionRelativeToPage in order to get the position of all the hyperlinks in a document, However, starting with the second page it always return -1. I think because the second page is not on the screen. But how can I get around this? Thanks, Cris Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81121
  - 4
    - Repagination Hello, Well, I have an unusual repagination problem. I understand that background repagination (in Normal View) may be turned off along with the screen updations. Sub MakeAllFast() ActiveWindow.View.Type = wdNormalView ActiveDocument.Repaginate Application.ScreenUpdating = False Application.Options.Pagination = False End Sub Sub MakeAllNormal() Application.ScreenUpdating = True Application.Options.Pagination = True ActiveDocument.Repaginate End Sub I am working on a huge 200 page document which needs automation and I simply call 'MakeAllFast' before the Find and Replace loops and 'MakeAllNormal' after the loops. This works as expected and I do not see the "Word is repaginating ..." message on my computer which runs Microsoft Word 2003. However, the problem occurs when I install the template on Word 2000 based machines. Inspite of ensuring that background pagination is turned off and Normal View is being used, I still keep getting the "Word is repaginating..." message on these computers. I have no idea why. What takes 30 seconds on my computer takes around 6-7 minutes on the other computers that use Word 2000. I thought that background repagination in normal view should work the same in all versions of Word. Can somebody please shed some light on this? I did break the code and ensure that the options.pagination was false and activewindow.view.type was 1 (Normal) on the 2000 machines before the main loop got executed. I still got the "Repagination" message. Thanks a lot for any help. Vince Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81118
  - 5
    - Adding watermark to the document I recorded a macro to insert watermark in a document. The document has multiple sections and different first page and primary headers. Word adds the watermark perfectly but when I run the macro the watermark is not available on many pages and also it is not centered on the page. Has anybody else faced this problem too? Any comments will be appreciated Thanks, Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81112
  - 6
    - Adding watermark to the document I recorded a macro to insert watermark in a document. The document has multiple sections and different first page and primary headers. Word adds the watermark perfectly but when I run the macro the watermark is not available on many pages and also it is not centered on the page. Has anybody else faced this problem too? Any comments will be appreciated Thanks, Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81111
  - 7
    - msgbox html I have a file "summary.html" that i use as "htmlbody" for sending emails created in html with personal functions. I'd like to show this file as a msgbox. If i open it as an object of filesystem i have as message "<body><Table ..." and so on How can i display the fle html as a messagebox before creating emails? tia, marco Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81108
  - 8
    - VBA vs. VB6? I'm just curious: how similar/different are VBA and Visual Basic 6? I'm more or less functional in VBA at this point and have just seen a job posting where Visual Basic 6 is a "nice to have". I'm wondering if it would be reasonable to cite my experience with VBA as proof that VB6 would not be a big challenge? Or are they totally different animals? -- Rhino Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81104
  - 9
    - Copying a range from excel into word I have an excel sheet in which there are several named ranges. I would like to write a macro to copy the information, create a new word doc and then paste into the new word doc. Do I write it from excel or from word. How do I control the paste function? Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81101
  - 10
    - font color how can i change color for example font.color = wdColorRed for the text i replace? like this Dim rDcm As Range Set rDcm = ActiveDocument.Range With rDcm.Find .Text = strfind .Replacement.Text = strReplace .Execute Replace:=wdReplaceAll .... end with tia Marco Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81097
  - 11
    - Getting to the end of range Hello I use Range object to insert text in paragraphs. when text is inserted, the cursor still stays at the beginning (at the book mark). Set rBMRange = .Bookmarks("P1_WhatYouMightGetBack").Range rBMRange.Text = Trim(rsMYS!para_text) I want to carry on typing more text from database, without having unnecessary bookmarks. How do I get to end of text, and how do I type carriage return (selection.typeparagraph with selection). Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81089
  - 12
    - Error automatically adding bookmarks in Word 2003 Hi, i am having trouble creating a macro that creates a bookmark, then uses the selection as the name. I have written the following macro... Sub AddBookmarkUsingSelection() Dim strSelection40 As String Dim lngBookmarkCount As Long strSelection40 = Left(Replace(Selection, " ", ""), 40) lngBookmarkCount = Application.ActiveDocument.Bookmarks.Count With ActiveDocument.Bookmarks .Add strSelection40, Selection.Range .DefaultSorting = wdSortByLocation .ShowHidden = False End With MsgBox "Bookmark number " & lngBookmarkCount + 1 & " added: " & strSelection40, vbInformation End Sub ... but as soon as i run it, it gets to the '.Add strSelection40, Selection.Range' range then stopps with an error: 5828 - Bad bookmark name. If i analyse the contents of the variable strSelection40 in the Immediate window it confirms that the string contains no blanks. If i then assign the same string value back to the string, the macro runs as required, see Immediate below: ? strSelection40 Mainnut strSelection40 = "Mainnut" Does anyone know a workarround for this? Thanks in advance. Mark Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81088
  - 13
    - Totaling Columns I have a document that i am in the process of formatting, however i need to total up columns of data. I know where the bottom on the data will be and can activate the cell either at the last column with data or the column below this. this action is then repeated within my loop. Can anyone help?? Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81085
  - 14
    - Can i change the Expansion Pack Dyanamically for diff Templates? Hi, I am working on WORD 2003 Smart Document Solutions. I am using Vertigo Managed Smart Document wrapper. Is it possible for me to change the XML Expansion pack dyanamically based on the template i open, If i have multiple templates on the same machine. I want to know if this can be done? Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81084
  - 15
    - Is there a mouseover VBA event I can use to tickle a hot spot comm Good morning and happy VD: In Excel, I can insert a comment into a cell, and excel puts a little red flag in the corner of the cell, and you can mouseover that flag and see the comment. Does anyone know how to make a "hot spot" in word such that when you mouseover a flag, it displays some text not visible otherwise? I already know how to insert comment in word and then do the show-hide trick, but then you see all the junk in the entire document, which is not the behavior we desire. Thanks in advance for any suggestions. -- Ron Ehrlich -- Ron Ehrlich Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81077
  - 16
    - VBS sript to remove menu items Hello, all: We have recently installed ADOBE ACROBAT 7.0. Hard-coded into one of their DLLs is an instruction to add the 'Adobe PDF' and 'Acrobat Comments' menus to the WORD Menu Bar. Short of uninstalling part of the product, there is no way to stop Adobe from adding these menu items. Is it possible to run a simple script that removes the ADOBE menu items when WORD starts up? Or would a macro be better? Right now, I'm manually removing these menu items whenever I start the application. Thanks! Mike Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81073
  - 17
    - Macros disappearing Can someone direct me to an easy to read article on transporting macros with your document. I have written on several occasions about this project and keep getting more frustrated. Latest.... I have a large forms template with many macros in it. When the template is accessed as the basis for a new word document some of the macros disappear. I made sure all of the macros were in the template by going to the organizer and copying them over. Security is set to low and when the form was first created...it worked great. It has however been through several iterations and passed from person to person through email....which I stopped them from doing because I think server rules were stripping the macros. I need to get this project finished and assure the endusers that they will have the macros needed to make the form work. I would appareciate any advice you can give. The endusers will need to email completed forms to each other, because they may use that form with minor content changes as the basis for another study, etc. Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81066
  - 18
    - How to find differences in images while comparing 2 word documents Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81062
  - 19
    - i have a major problem hey i need to get a document that was replaced during saving this project is due 2/16/o6 so i really need ur help Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81055
  - 20
    - cannot activate product? Hi um i was about to activate the office 2003 product when all of a sudden I get this message ( Your installation cannot be activaged because you have activated up to the imit for you product key). i would like to know what they are talking about Help please Thank you. Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81053
  - 21
    - AttachedTemplate is missing...please help me find it! Hey everyone, I am trying to change the AttachedTemplate property of a document using C# and the office2003 PIA. in VBA, the property is there, and no problem using it. in C#, with the referances to the com dll, the document object doesnt have the property! I saw tons of code samples in C# using that property, so I must be doing something wrong. my project does not compile! help! Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81050
  - 22
    - how to run a macro in another active document Is it possible to have a button on my custon toolbar run some code in another document that is open. the other document that has the code is called "Schedule.dot". The code is sub Finder() thanks, ck Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81037
  - 23
    - creating a taskpane Is there any examples of how to create your own taskpane. Is would serve much better than a toolbar for me. I'd like to put some links on it to run different macros. You you customize this new taskpane like changing the font size and color? thanks, ck Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81035
  - 24
    - How do I capitalize the letter following "Mc" or Mac" in a name? Mail merging from an Excel list with names in all caps, some caps and all small. First, used "PROPER" in Excel to convert names to standard initial capital letter, the rest small. How can I then capitalize the letter following "Mc" or "Mac" in Scottish names? Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81034
  - 25
    - VBA access to Header references ? I am writing a macro that translates Word documents to PmWiki format. I want to convert cross-references to internal page links. I find no information about any collection of the existing references. The only information I find is about how to insert new references. Any ideas ? Tag: XML seed file, "lost" VB macro and WML2XSLT.EXE Tag: 81032

# my WordML source file has a working VB macro
# the XSL output file generated with WML2XSLT.EXE includes this entry:
w:macrosPresent="yes"
# I then open from Word 2003 an XML data file and apply the XSL, I answer
yes to the Security Warning to enable macros and the transformation completes
as expected except the resulting file doesn't contain my macro (why not?!)
# any ideas what I need to do in order for the resulting file to have a copy
of my macro? is it correct to assume my macro code is also contained in my
XSL file?

Thanks!

Top

RE: XML seed file, "lost" VB macro and WML2XSLT.EXE by mg2468

mg2468
Mon Feb 27 15:03:27 CST 2006

I found that if I implement this same procedure by using a macro I do get the
expected results, this is, unlike using the Word UI.

"mg2468" wrote:

> # my WordML source file has a working VB macro
> # the XSL output file generated with WML2XSLT.EXE includes this entry:
> w:macrosPresent="yes"
> # I then open from Word 2003 an XML data file and apply the XSL, I answer
> yes to the Security Warning to enable macros and the transformation completes
> as expected except the resulting file doesn't contain my macro (why not?!)
> # any ideas what I need to do in order for the resulting file to have a copy
> of my macro? is it correct to assume my macro code is also contained in my
> XSL file?
>
> Thanks!

Top