Store and Retrieve Network Path for Word Add-in

Tutorials Win: Microsoft Windows Forum

- Previous
  - 1
    - VBA equivalent of StyleRef Is there a VBA equivalent of StyleRef? I am searching through a document for a specific style and once found I am adding the text in that style and page number to a table. I would also like to add the content of the previous heading1 to the table. The current method is to use StylRef in the header and then once the specific style is found, open the header and then "read" the value placed by the Styleref. John... Visio MVP Tag: Store and Retrieve Network Path for Word Add-in Tag: 105224
  - 2
    - empty paragraph Hi everyone, I want to change font name,font size , space before and after each paragraph in each document in a folder with hundreds of documents( now they have different fonts and sizes so i want them to look the same). Because in some documents there are extra empty paragraphs first i need to remove them then apply formatting and here is where i have a problem I used two method for removing empty paragraphs first find /replace ^p^p with ^p and also the following macro Dim parag As Paragraph For Each parag In ActiveDocument.Paragraphs With parag.Range If .Words.Count = 1 Then parag.Range.Delete End If End With Next parag For some reason ^P^P method is not able to remove all the empty paragraphs ( move most) anythoughts? -- Best regards, Harvey Tag: Store and Retrieve Network Path for Word Add-in Tag: 105221
  - 3
    - open word 2007 template like memo hi all i want to open word 2007 template like memo, and then write some text into it using ATL C++, how to do that any help is welcomed. Tag: Store and Retrieve Network Path for Word Add-in Tag: 105219
  - 4
    - opening word template like memo hi all, i want to open word doc template like memo and then write into it, i want to do that with word 2007. Tag: Store and Retrieve Network Path for Word Add-in Tag: 105218
  - 5
    - Runtime 91 error for ActiveDocument in AutoExec macro I am trying to invoke MS word in the following manner: start winword.exe /lc:\glb\myglobal.dot /tc:\tmp\doctemplate.dot / myglobal.dot - My global template - contains the following logic Public Sub AutoExec() If ActiveDocument.Bookmarks.Exists("CSWB") Then If (InStr(1, ActiveDocument.FullName, ".rtf") < 1) Then ActiveDocument.RunAutoMacro (wdAutoNew) End if End If doctemplate.dot - A document template that contains the AutoNew macro defined. Problem scenario: When I run - "start winword.exe /lc:\glb\myglobal.dot /tc:\tmp\doctemplate.dot /" from command prompt it works fine. I install Adobe Acrobat writer on my machine, and run the same command, It fails with a Runtime 91 error - Object variable not set Looks like ActiveDocument object is not initialized and fails when I try to access ActiveDocument.Bookmarks collection. When I uninstall Adobe acrobat writer, the problem goes away. This is happening in production as well (that actually triggered this analysis) but I don't necessarily see Adobe writer installed in production. Is there anything else that when installed would change the behaviour of AutoExec as I have mentioned ? If you have any ideas as to how can I avoid this, that would be great. Tag: Store and Retrieve Network Path for Word Add-in Tag: 105217
  - 6
    - Delete line containing a form field Hello, I have a template that is used to create recipes for upload to a website. The person typing in the recipes is not very computer literate, so I made a form with fields for him to fill in with ingredients. The fields' default text is "Ingredient". I put in 15 lines for ingredients. Obviously, not all recipes have that many ingredients. I'd like to write a macro to delete the lines that don't have ingredients in them, i.e., they say "Ingredient" in the form field. To make it more complicated, I'd like to delete the entire line, not just the form field. Is there a way to do this? I've tried a find and replace, but that doesn't seem to work with form fields. Anyone have any guidance? Thanks! Melinda Tag: Store and Retrieve Network Path for Word Add-in Tag: 105213
  - 7
    - change colour in title of userform Is it possible to change the background colour of the title in a vba user form (the one that defaults to UserForm1 when you create a new userform)? I know how to change the colours of the form itself and of any text boxes etc. placed on the form but not the title. thanks, Tag: Store and Retrieve Network Path for Word Add-in Tag: 105205
  - 8
    - How can I delete accent mark form select character and whole text? I want to back of subject about set mark of accent (emphasis mark or acunt accent). How can I delete accent mark form select character and whole text? I have next code: Sub accent() Dim selChar As Long selChar = AscW(Selection.Range.Characters(1)) If Selection.Type = wdSelectionIP Then MsgBox prompt:="Nothing selection", Title:="Select a character" Else ' How delete accent mark? With Selection .Collapse direction:=wdCollapseEnd .InsertSymbol CharacterNumber:=769, Unicode:=True End With End If End Sub Now I need delete Character (769) from selection text (if it exist). How I can find it and delete it? Tag: Store and Retrieve Network Path for Word Add-in Tag: 105201
  - 9
    - Passing Word documents with macros as Sharepoint content types Hi I have been trying to nut this problem out for awhile now but not making alot of progress. I am trying to integrate Word 2003 with Sharepoint 2007 as follows: I have a site with a template library. I have developed a content type in another site and use it in a library. I want the user to be able to select a content type in a library and have an auto open event fire to open the sharepoint properties dialog. The user populates the field presented and these cascade though fields in the document. The fields are also available (as metadata) at the library list for filtering grouping and sorting Everything works fine except one thing. The problem is that when the content type is chosen from the library the macro doesn't fire and on inspection the macro is no longer available in the document. It does however fire and works fine in the template library. Does anyone know what is happening and how I can resolve this Thanks IanB Tag: Store and Retrieve Network Path for Word Add-in Tag: 105200
  - 10
    - Loop I have a macro that I have been working on. It works exactly as I want to as long as I run it once. Basically I have a document that contains many notices. Each notice is 3 to 5 sections long based on criteria that I can identify. The macro correctly identifies the number of sections for each notice, prints it and deletes it so that the second notice is now the first. I can start the macro and print the first notice. Then start the macro again and print the second notice and so on until it reaches the end. So I know the macro is working. The problem is, I want to be able to run the macro with no user interaction. So a simple loop should work. But no matter how I try to make it loop, it does not run properly. (It prints part of them correctly, and part of them not correctly) I have tried: Start: (at the beginning of the macro) goto Start: Doesn't work I have tried do while selection.find.execute ("refer to:") = true macro Loop Doesn't work I have tried Do Macro Loop Doesn't work I have tried do until selection.find.execute ("refer to:") = false macro loop That doesn't work. I have stepped through the macro repeatedly. Everytime I step through it, it works perfectly. Then I can add a loop to it and it does not work correctly. Tag: Store and Retrieve Network Path for Word Add-in Tag: 105196
  - 11
    - Automate the saving of rtf files to doc files Hello everyone: There are hundreds of Word rtf files saved on a shared drive that are taking up an enormous amount of disk space. These files are just copies of letters containing only text (from mail merges) that have been sent out to clients. If I save an rtf file as a doc file, the size of the file decreases considerably (from serveral thousand kb to several hundred kb). To conserve disk space, I would like to save all these files as doc files. If I were to do this manually, I would have to open each rtf file, save it as a doc file and then delete the rtf file. Assuming that all these files are in one folder, is there an easier way to do this? The name of the new file would be the same as the old file except for the extension. For example Filename.rtf to Filename.doc. Just renaming the filename does not appear to decrease the file size. Thank you for any help. Amy Tag: Store and Retrieve Network Path for Word Add-in Tag: 105195
  - 12
    - Creating Word 2007 Forms and calcluated fields. I want to create a Word 2007 form, where I use a DatePicker for the user to select a date (let's call it WeekEndingDate). Then I want 7 cells in a table to be updated with WeekEndingDate - 6, WeekEndingDate - 5, etc... Is that possible to do without having to use VBA, and if so, how would one go about doing that? I've exhausted my limited Word Form Development knowledge. :-) Thanks, Sergi Tag: Store and Retrieve Network Path for Word Add-in Tag: 105190
  - 13
    - Disable AutoCorrect Options dialog box Hello, I try to limit user access using Word template. One of the issue is limiting access to AutoCorrect Options dialog box. Currently, our users can right click on misspelled words and choose AutoCorrect- >AutoCorrect Options... from a shortcut menu. I did not see this menu listed in Customize->Toolbars->ShortCut Menus either. Is there a way to suppress the AutoCorrect Options dialog box using VBA? Thank you, Tag: Store and Retrieve Network Path for Word Add-in Tag: 105187
  - 14
    - How do you create a .dot file with Toolbar and Macro, but not from the Normal.dot? All, I would like to create a .dot file containing a toolbar and associated macro. Currently, I am adding the macro and toolbar manually to the Normal.dot file. Then I save and rename a copy of the normal.dot file. Is there a way to create this file without the extra baggage of my normal.dot file? Thanks Tag: Store and Retrieve Network Path for Word Add-in Tag: 105183
  - 15
    - need help with AutoOpen print macro on mail merge document We use an application which allows us to generate and print mail merge documents via Word. As near as I can tell, trying to print a mail merge document via this application opens Word, populates the merge fields with the appropriate data, then prints the document to the system default printer. One such document we use is a label document, and we use the following AutoOpen macro to divert the print job to their label printer without making them change their default printer each time: Sub AutoOpen() Application.WordBasic.FilePrintSetup Printer:="Dymo LabelWriter 330 Turbo-USB", _ DoNotSetAsSysDefault:=1 End Sub With this macro in place, the document is opened, the data is merged, and it's printed to the label printer. In most situations, this is adequate. However, we've been getting requests from people who want to be able to specify how many copies to print, and I've been having a lot of trouble figuring out how to make that happen. I've tried various methods of showing the print dialog box, so they could specify how many copies to print and be happy. Unfortunately, any time I've been able to get the print dialog box to pop up with AutoOpen, it will print the mail merge document before the data is merged in (it prints the merge field names rather than the data). If I tell the print dialog to print 3 copies, it will print 3 copies of the pre-merged document, then print one copy of the merged document. I'm pretty new to WordBasic and macros, and basically gave myself a crash course yesterday. I had also tried using an inputbox to prompt for the number of copies, then try to pass that to FilePrint (I think... I tried so many different things it's hard to keep track now) using the NumCopies argument, but that just resulted in errors. I'm open to suggestions at this point. Unfortunately, I have no control over the program that actually invokes Word to open and print the mail merge document, so I'm basically limited to what I can do with macros during the brief period the document is opened. Tag: Store and Retrieve Network Path for Word Add-in Tag: 105181
  - 16
    - Problems with opening TextStream files I run a macro which selects sections of a Word document, then opens a TextStream file object and pastes in the text. The code I'm using is: Set docNew = fs.CreateTextFile(strNewDoc) docNew.Write (strNewFile & vbCr & vbCr & _ "This doc created on " & _ Format(Now, "dd mmm yyyy")) docNew.Close (fs is FileStreamObject). I have another macro in Excel that opens a selected doc created this way using: WD.Documents.Open doc (all variables are set good and the code works). Occasionally, the File Conversion dialog opens. I know these are not "real" Word docs, but simply text files with a .doc extension, but saving each of hundreds of files as Word docs adds an enormous amount of time to the loop. Is there anything I might be able to do to these files to prevent the Conversion dialog from opening? Or is there something I can add to the Excel code to assist these files in opening without the user having to mess with this? Ed Tag: Store and Retrieve Network Path for Word Add-in Tag: 105178
  - 17
    - Running Word Macro from iSeries I've created a Document Template that contains a Macro. This Macro reads a file from the iSeries and populates bookmarks within the Template and prints the Document. Currently, the user has to open the document, click Tools, Macro's, Marco's, Run to produce the report; very messy. I want to fire off the document from the iSeries so the user doesn't have to mess with Word. I'm able to bring the document up from the iSeries, but it's not running the macro. I've tried everything I can think of, including things on this board and others. My code is running in an ILE program. I'm loading the command line from an array. My array looks like: STRPCCMD PCCMD('C: \Progra~1\Micros~3\OFFICE11\winword O:\COMMON\TEMPLATES\MQE*.* /mMQE()') . Everything works fine up to the /m. My document is MQE Letters.dot, and the Macro is MQE. In addition to the /m, I've also tried Call MQE, Call "MQE", Application.Run MacroName:="MQE", Run MacroName:="MQE", Call MacroName:="MQE"....the list goes on. Any help would be GREATLY appreciated. Tag: Store and Retrieve Network Path for Word Add-in Tag: 105176
  - 18
    - How do I customize a toolbar for an addin template I've just created a few macros and now I'd like to create a toolbar to go along with it. This seemed very simple in 2003, but I'm having trouble creating one in 2007. Tag: Store and Retrieve Network Path for Word Add-in Tag: 105169
  - 19
    - Copy Paste (special-unformatted) from Excel to Word Hi I'm trying to copy-paste (unformatted), a series of cells from excel into Word. I've got the below macro which does some of this but it keeps pasting the whole table either as a picture or a normal table (if you use the disabled line instead of the enabled paste line). However, if I manually copy-paste special and select unformatted text I get a load of text and no tables or borders which is what I want. Any ideas how to achieve this with the below macro? Sub OpenAWordFile() Dim wordApp As Object Dim fNameAndPath As String ActiveSheet.Range("I5:I51").Copy fNameAndPath = "C:\Documents and Settings\tom.jordan\My Documents\Projects\FFEC Headed Paper.doc" Set wordApp = CreateObject("Word.Application") With wordApp .Documents.Open (fNameAndPath) .Visible = True .Selection.PasteSpecial DataType:=wdPasteText '.Selection.PasteAndFormat (wdPasteDefault) .Selection.WholeStory .Selection.Font.Name = "Arial" .Selection.Font.Size = 11 End With Set wordApp = Nothing Application.CutCopyMode = False End Sub Tag: Store and Retrieve Network Path for Word Add-in Tag: 105165
  - 20
    - Word 2002 TOC format does not update correctly I have a big document and I inserted a table of contents. I selected specific formatting for each TOC level, but my formatting is not applied. Instead the formatting of the TOC (fonts type, font size, Bold, Italic, ...) is all wrong. Can you please tell me how can I modify those styles? Thank you P.S. If there is already a response to this question please help me find it. thanks Tag: Store and Retrieve Network Path for Word Add-in Tag: 105161
  - 21
    - Extracing scetions of a document Hi I am after some advice on how to proceed. I would like to write some code to extract certain sections out of a document and copy them into a new document. Is it better to use sections or bookmarks? These sections may span multiple pages. Any advice would be very gratefully received. Cheers Dan Tag: Store and Retrieve Network Path for Word Add-in Tag: 105159
  - 22
    - changing a certain word in many files. Hi everyone , I have a folder with hundreds of one page word documents. I want to use VBA to search through all these files and change a certain name (e.g. New York) to something else (e.g. los angeles) and save the file and go to the next file. Any thoughts? Any help greatly appreciated. -- Best regards, Harvey Tag: Store and Retrieve Network Path for Word Add-in Tag: 105146
  - 23
    - EXE that invokes Word won't run macros I have a Windows 2003 scheduled task parsing process that calls Word 2003 and runs a specified Word macro, however, the macro will not run unless the user is logged in. I know you can configure the Word Document Properties, via the identity tab, to use a specific user to run the application, however, I want to use the launching user and not require a user to be logged into windows. I've tried security settings in macros with no luck. Any ideas?? Tag: Store and Retrieve Network Path for Word Add-in Tag: 105143
  - 24
    - Spawned document from Template (Dot) loses macros Here is a screenshot I am working on: http://www.jkfweb.com/files/Example.JPG The file is a .Dot template file. It works great normally when a user opens from the Template and fills in the appropriate information. I have a few users who want to open the file, fill in there name and the Company Name and other appropriate fields and then save that as a .dot file. This would allow them to not have to re-type and look up the information everytime. The problem is the macros are apparently not being copied when word spawns document1 from the template. I'm assuming this is normal word behavior, but haven't been able to find a solution on word.mvps.org and a quick search in newsgroups didn't find the solution either. Any ideas how to get the macros to go into the newly spawned document as they are used to create new rows, do some error correction, and formatting of fields. Thanks in advance for any help. Tag: Store and Retrieve Network Path for Word Add-in Tag: 105140
  - 25
    - Toggle symbols with VBA I'm trying to set up a roster where I can click on a symbol in front of a person's name and it will change from an "X" to a "O". I'm an expert at Excel VBA, but not familiar with Word VBA. Can someone give me some ideas on how I could set up a macro to allow the user to check on a symbol (or character) in front of a person's name in a list and it would toggle between 2 or 3 symbols? The list will be dynamic, so I need to write some generic code that can identify which symbol is clicked on and toggle it to the next symbol. Thanks. John Tag: Store and Retrieve Network Path for Word Add-in Tag: 105134
- Next
  - 1
    - Remove character style with direct formatting I have text styled with a custom character style. Some of that text also has direct formatting applied (bold, ital, etc.). I need to remove the character style, but retain the direct formatting. Possibly I also need to retain any font formatting provided by the style as. I can do this: For Each c In Selection.Characters Set f = c.Font.Duplicate c.Font.Reset c.Font = f Next c but this is slow and I keep thinking I'm missing a simpler, faster way to do this. Any suggestions? Tag: Store and Retrieve Network Path for Word Add-in Tag: 105132
  - 2
    - Adding in an XML Schema I am using Office 2003 Professional. I am trying to follow an example for adding an XML schema to a Word document and I get the following error: "The XML expansion pack or schema file could not be installed". I can't see anything wrong. Here is the xsd code: <?xml version="1.0" encoding="UTF-8" ?> <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="urn:schemas-microsoft-com.office11demos.WordProductsSD" targetNamespace="urn:schemas-microsoft-com.office11demos.WordProductsSD" elementFormDefault="qualified" attributeFormDefault="unqualified" id="Contract"> <xsd:complexType name="contract"> <xsd:complexContent> <xsd:restriction base="xsd:anyType"> <xsd:sequence> <xsd:element name="CaseCode" type="xsd:string" /> <xsd:element name="Casediscription" type="xsd:string" /> <xsd:element name="element1" type="xsd:string" /> <xsd:element name="Nextdateofhearin" type="xsd:string" /> <xsd:element name="summary" type="xsd:string" /> </xsd:sequence> </xsd:restriction> </xsd:complexContent> </xsd:complexType> </xsd:schema> Tag: Store and Retrieve Network Path for Word Add-in Tag: 105130
  - 3
    - DSO file fails with word 2007 docx files of size zero byte. Hi I am using dsofile.dll(latest, which supports office 2007 formats) to set attributes of office files. The dsofile fails with .docx files if the file size is 0 bytes(Such a file can be created by rightclicking on desktop and selecting New ->Microsoft Office Word Document. If you right click on the created file and select Properties, It shows Seze as 0 bytes). Is there any fix/workaround available for this bug? Thanks in advance, Tag: Store and Retrieve Network Path for Word Add-in Tag: 105127
  - 4
    - Conditional macro to change font Macro programmers - I need a macro that changes fonts in a document from: Goudy Old Style to Garamond -and- Avenir 45 to Gill Sans MT If there are other fonts in the document I want to leave them as is. I am only concerned with the above 2 fonts. Thanks in advance for your help. Tag: Store and Retrieve Network Path for Word Add-in Tag: 105126
  - 5
    - User to Specify Starting Number for Sequential Numbering I am using this macro (courtesy of Doug Robbins with help from Jay Freedman) to sequentially number certificates where data other than the serial numbers is in ask fields. The macro is in a template and runs automatically on Document_new. My problem is that I need the user to specify the starting serial number every time, without opening the settings.txt. Can this be done with a user form? Grateful for some help with this, thanks. Sub SEQserialnumber() ' ' SEQserialnumber Macro ' Macro created 11/09/2007 by Sharon ' Dim Message As String, Title As String, Default As String, NumCopies As Long Dim Rng1 As Range ' Set prompt. Message = "Enter the number of copies that you want to print" ' Set title. Title = "Print" ' Set default. Default = "1" ' Display message, title, and default value. NumCopies = Val(InputBox(Message, Title, Default)) SerialNumber = System.PrivateProfileString("C:\Settings.Txt", _ "MacroSettings", "SerialNumber") If SerialNumber = "" Then SerialNumber = 1 End If Set Rng1 = ActiveDocument.Bookmarks("SerialNumber").Range Counter = 0 While Counter < NumCopies Rng1.Delete Rng1.Text = SerialNumber ActiveDocument.PrintOut SerialNumber = SerialNumber + 1 Counter = Counter + 1 Wend 'Save the next number back to the Settings.txt file ready for the next use. System.PrivateProfileString("C:\Settings.txt", "MacroSettings", _ "SerialNumber") = SerialNumber 'Recreate the bookmark ready for the next use. With ActiveDocument.Bookmarks .Add Name:="SerialNumber", Range:=Rng1 End With 'Next line added to update { REF SerialNumber } ActiveDocument.Fields.Update ActiveDocument.Save End Sub Tag: Store and Retrieve Network Path for Word Add-in Tag: 105125
  - 6
    - Macro/Code to Delete Current Section Anybody know the code to delete the current section in a Word 2000 document. I know the code for deleting section 1, 2, 3, etc. but I need the code for the current section. Thanks in advance. Mickey Tag: Store and Retrieve Network Path for Word Add-in Tag: 105123
  - 7
    - Word file with 6 links to one excelfile with vba code, run that code 6 times on update Hi, I have a word file with six links to a excel sheet. That excel sheet run vba code on workbook_open event. When opening the word file, it seem like the excel code run for each link. Any workarounds? Kind regards Tskogstrom Tag: Store and Retrieve Network Path for Word Add-in Tag: 105118
  - 8
    - How do I compare dates in Word 2007? Is there some esoteric programming practice within Word 2007 that allows the comparison of dates? I.E., {Date1} <= {Date2} {Date1} is merged field and {Date2} is today's date {DATE}. So far, I have found nothing that works. I am attempting to create a Mergeformat renewal document when today's date has passed a merge field date. Tag: Store and Retrieve Network Path for Word Add-in Tag: 105110
  - 9
    - select all rows of a table except the first row Hi I have a macro that does a bit of formatting to any table that the cursor is placed in. I can select the whole table easily: Selection.Tables(1).Select and can select individual rows too: Selection.Rows(1).Select but I now need to select every row except the first one (2-x) where x could be any number, depending on how big the table is. Maybe some way of counting the rows in the table first (x) and then using that number to select rows 2-x? Or maybe select row 2, perform the action, and move to next row and repeat until there are no more rows in table 1? Any other suggestions? What would the syntax be? thanks. Mike Bourke Sales Information Designer IBM New Zealand Limited Internet email : mbourke@nz1.ibm.com +64 4 462 3534 DDI +64 4 576 5615 fax +64 21 679 746 mob -- MB. Tag: Store and Retrieve Network Path for Word Add-in Tag: 105108
  - 10
    - cant open paper says selection is locked paper due tomorrow it said somethin like program options update definitions. what does it mean? help!!!! i need my paper now!!!!!!!!!!!!!!!!!! Tag: Store and Retrieve Network Path for Word Add-in Tag: 105105
  - 11
    - Macro to auto update bookmark dates Hi All, I have created a template which uses bookmarks and fieldforms to get data from our database. we are a school and we have students always starting on mondays except for public holiday. here is my problem below is a macro found at woody's (great website) I have 2 bookmarks (E_ST_DATE) & (public holiday) but when the macro is ran it seem to caculate before e_st_date is updated because I get a return of 31/12/1899 as my result Sub AutoNew() Selection.GoTo What:=wdGoToBookmark, Name:="publicholiday" Selection.InsertAfter Format((E_ST_DATE + 1), "dd/mm/yyyy") End Sub What I want to achieve is e.g (e_st_date = 10/09/2007 then publicholiday = 11/09/2007) The trouble is thou e_st_date will always change and I just want to add 1 to wat ever date that is. Please help Tag: Store and Retrieve Network Path for Word Add-in Tag: 105098
  - 12
    - Calling a macro I have a VBA macro that I am using and I want to call another macro. I have been tried the two versions of calling a macro below. Application.Run MacroName:="[PrintHRFormsRep]" Application.Run "'Shreveport.doc'!NOH.PrintHRFormsRep" But I keep getting an error message that says: Unable to run the specified macro. The document that I am working in has a range set called noticeplus. Then I want to call a macro that will open another document, print it, close it and revert back to the previous active document. Both macros work independently, but I want to be able to use them together. It occurred to me on the way home tonight that maybe it had something to do with the range being set. Is there another way to call a macro when a range is set? Both macros are in the same template and module. Thanks for any help. Tag: Store and Retrieve Network Path for Word Add-in Tag: 105096
  - 13
    - Form repaint problem I have a VBA form to provide the user with status on a long-running macro. Normally, the status updates happen every few seconds without error. Sometimes, however, the form doesn't update at all, and can even generate a "(Not Responding)" error in the form's title bar. The macro completes successfully, but the user thinks it's frozen. I'm calling form.Repaint after I update the status text. Why might that be working some of the time and not all of the time? It does seem to be related to switching from Word to another app and back again, but it's not consistent. I've also heard of the DoEvents command, to yield control to the OS, but I've seen conflicting advice about how and when to use that. Any suggestions? I can provide code samples, but really, I'm just updating the text in the form and then calling .Repaint. Thanks, Ben Tag: Store and Retrieve Network Path for Word Add-in Tag: 105095
  - 14
    - Word from Excel PasteSpecial Bitmap Problem Dear All, I am having a very strange and odd problem with Excel and Word. If you could kindly propose any solution ideas, I shall appreciate it very much. I have a reporting VBA application on the Excel. Smoothly produces all the reports. I have to put the reports in a Word application. The reports are not fixed row and column sizes. I have to generate a Bitmap image of the Excel report and tried to Paste it in the Word Application. Very strangely, on the very first runs no problems. It worked, I had the reports Bitmap pics on Word beatifully as I wanted but then later something happened, may be the ghost in the machine. Excel VBA is copying the range and sending it to the Word application but, the pasted bitmap is a blank object, sadly, very sadly nothing inside. In order to complete my reports on time, I tried a backdoor tactic and created a Word macro doing the PasteSpecial Datatype:=wdPasteBitmap and assigned it to a keyboard shortcut macro. Bingo! It worked. However it is taking so long to complete a full set of report with approx. 200 x 30 Cntrl-Qs and shifting between the applications is awfully open to error. I have tried another backdoor route because I were running short on time, I tried the Sendkeys method but unfortunately, the same ghost in the same machine, very first few runs it worked, then generated empty objects. I cleaned the Clipboard if incase there is a memory related problem. No progess. I tried to pause the code before and after the PasteSpecial steps. No progess. Then I wondered if the Excel Bitmap function is not working properly so I tried a code to generate my own bitmap pictures, which worked fine, but the same ghost in the same machine, blank pages were there after the second or third runs so sadly and so misfortunately. I tried the 2007 and 2003 vers. of Excel but sadly, very same. I am working on a licenced XP Pro and licenced Office Pro Pentium 4 with 4GbRAM and lots of disk space. If you may need to see the code, I shall send the code as well. If some Guru could help fiding the ghost in the machine, I shall be more then gratefull. Regards, VBANovice trying to find the Ghost in the Machine Tag: Store and Retrieve Network Path for Word Add-in Tag: 105091
  - 15
    - microsoft word Hey i really want to download Microsoft word for Xp computers and i was wondering how i did this. If you use a website can someone tell me what i have to do. Now i'm starting my coursework i really want to get started with WORD! i would be grateful if anyone can tell me how to download microsoft word from the website. Kind Regards L x Tag: Store and Retrieve Network Path for Word Add-in Tag: 105089
  - 16
    - nextPage sectionBreak hello everyone I have a document which I need to break into sections(nextPage). Im doing a search for 3 asterix marks and when found, insert the sectionbreak. I need to run the code until the end of document only once everytime it is run. Do I have to delete the existing section breaks first. heres the code I have so far. It keeps looping nonstop Sub letsDivide() Selection.HomeKey wdStory Selection.Find.ClearFormatting Selection.Find.Replacement.ClearFormatting With Selection.Find Do While .Execute(FindText:="***", Forward:=True, Wrap:=wdFindContinue, MatchWildcards:=False _ ) = True Loop End With Selection.InsertBreak Type:=wdSectionBreakNextPage End Sub Any help will be appreciated. thanx ahmed Tag: Store and Retrieve Network Path for Word Add-in Tag: 105088
  - 17
    - calculate values from a content control hello all, i have a content control in word that accepts values such as High, Medium and Low. I'd like to add a summary at the top of this table that calculates the total High Medium and Low. How do I go about doing this automatically? Tag: Store and Retrieve Network Path for Word Add-in Tag: 105085
  - 18
    - Sequential numbers to appear twice on each document I have a simple form that I to print want multiple copies of. I have looked at Doug Robbins macro at http://word.mvps.org/FAQs/MacrosVBA/NumberCopiesOf1Doc.htm and would like to use it. What I can't work out is how to get the same sequential number to appear in 2 places on each copy. e.g. Copy 1 has: 123456 & 123456 Copy 2 has: 123457 & 123457 Tag: Store and Retrieve Network Path for Word Add-in Tag: 105083
  - 19
    - How can insert acute accent for selection of character into word? Hi. How can insert acute accent for selection of character into word? For example, I inserting acute accent like this: Selection.InsertSymbol Font:="Times New Roman", CharacterNumber:=769, Unicode:=True But it replace my selection character. If I add: Selection.Collapse direction:=wdCollapseEnd That nothing do. There is screenshot that show what I want: http://img.photobucket.com/albums/v190/baston/toaccent.gif P.S. Acute accent is diacritical mark. Tag: Store and Retrieve Network Path for Word Add-in Tag: 105078
  - 20
    - Office 2007: How to programatically add commands to the "Quick access Toolbar"? Hi all, how can I programatically add commands/items to the Quick Acces toolbar? TIA, Peeter Tag: Store and Retrieve Network Path for Word Add-in Tag: 105077
  - 21
    - Printers Is it possible to reference a Printer in vba by IP address? I want to be able to change paper tray/bin dependant upon what type of printer it is printing to but across the office the names of each printer vary so wondered if i could refer to its ip address instead. Many thanks for any help on this Tag: Store and Retrieve Network Path for Word Add-in Tag: 105076
  - 22
    - hyperlinks in a paragraph Anyone know how to insert hyperlinks in a blank word paragraph from .net - Using vs2005SE and office 2007 I need to programatically replace parts of a paragraph with hyperlinks that I know the texttodisplay and address of Tag: Store and Retrieve Network Path for Word Add-in Tag: 105063
  - 23
    - How to make a new website with a link? I can make a webpage in word, and then view it in internet, but the hyperlink to get to it is always: C:\Documents and Settings\All Users\Documents and so on and so forth. How do you make that an actual link? Tag: Store and Retrieve Network Path for Word Add-in Tag: 105062
  - 24
    - Security and VB References I have a sales person who install Office 2007 on there computer. The quoting software we use uses Word to create order forms. But I need to turn the Security level to low and go into VB area and check the approraite dll files under references. I don't have 2007 and trying to talk over the phone to find them has been interesting. I can't find the Security Area, I was able to get into the VB area but the references are grayed out or not available. So where is the secuity area and how can I make the references available? Thanks..... Tag: Store and Retrieve Network Path for Word Add-in Tag: 105059
  - 25
    - Using Distributed Link Tracking to fix Hyperlinks Does anyone have references or experience with using Distributed Link Tracking to fix hyperlinks to documents in your domain. This works for OLE references and short cuts, but it appears not to work automatically for hyperlinks. -- Old Ed Tag: Store and Retrieve Network Path for Word Add-in Tag: 105055

Hello,

I developed an add-in I plan to sell. The add-in loads stored images from
the program files directory on the host computer. The program works fine
with a local install. However, I would like to be able to offer the program
for network installations. I can't figure out the best way for the installer
to provide the path so the add-in knows where to retrieve the files. My
first thought was to have a bookmarked place in the add-in file itself where
the network path could be stored but I can't figure out how to retrieve the
contents from that bookmark.

Any input is appreciated.

Microsmith

Top

Re: Store and Retrieve Network Path for Word Add-in by Russ

Russ
Thu Sep 20 04:35:17 CDT 2007

Microsmith,
Does this help:
Windows Environmental Variables:
http://www.analogduck.com/main/node/298

VBA code:
strDrive = Environ("HOMEDRIVE")
strPathDocs = strDrive & Environ("HOMEPATH") & "\My Documents"

> Hello,
>
> I developed an add-in I plan to sell. The add-in loads stored images from
> the program files directory on the host computer. The program works fine
> with a local install. However, I would like to be able to offer the program
> for network installations. I can't figure out the best way for the installer
> to provide the path so the add-in knows where to retrieve the files. My
> first thought was to have a bookmarked place in the add-in file itself where
> the network path could be stored but I can't figure out how to retrieve the
> contents from that bookmark.
>
> Any input is appreciated.
>
> Microsmith

--
Russ

drsmN0SPAMikleAThotmailD0Tcom.INVALID

Top