Using VBA to work with Office search results

Tutorials Win: Microsoft Windows Forum

- Previous
  - 1
    - Tracking Document modification Event! I want to track Document modification event. i.e if someone modify the document i want to track it. I tried to find out the TLB file of MS Word. but couldn't find any event. Isn't there any event? Ahmad Jalil Qarshi Tag: Using VBA to work with Office search results Tag: 66717
  - 2
    - word Serait-il possible que word puisse finir les mots automatiquement. On commencerait Ã frapper le mot 'travail' en commenÃ§ant par 'tra' et word propeserait 'travail' automatiquement. Tag: Using VBA to work with Office search results Tag: 66711
  - 3
    - How to select whole document including header and foter I have the following code Selection.WholeStory Selection.Fields.Update that i use to update fields, but it does not updatefields in the header and footer. I have tried adding Selection.HeaderFooter But gives an error (Ivalid use of property). How can I update all the fields, not matter where they are? Jan Tag: Using VBA to work with Office search results Tag: 66704
  - 4
    - saving problems I am currently opening a document from a short which then opens my ducument on a network drive. i am then using a maro to save it from a command button on the doc, with a dated prefix so i have a daily back up. my problem is it keeps saving to it my documents, not its original location, and also changes the name of the original document to the dated prefix one thus making my shortcut to the old document without the changes. can anyone help pleae? Tag: Using VBA to work with Office search results Tag: 66701
  - 5
    - to get date and time from a website Hey all.. I programmed a code in word VBA and access to the word-document depents on the date when someone logs in. But people who know this can easily change the date in the Operating System (the system clock) I want to get the date and time from a website as a check that runs when someone logs in, or tries to (if the date has expired). Can anyone help me with this? Tag: Using VBA to work with Office search results Tag: 66700
  - 6
    - saving a backup I've been trying to save a ducument from a macro as follows Private Sub CommandButton1_Click() With Dialogs(wdDialogFileSaveAs) .Name = Format(Date, "dd mmm yyyy") & (" t-l information and handover050411.doc") .Show End With End Sub problem is that we access the original file from a short cut and when the file is backed up it obviously puts the date at the front and changes the name. problem is the shortcut we use then takes us back to the unsaved document of the original name. Can anyone help please? Tag: Using VBA to work with Office search results Tag: 66698
  - 7
    - tabular order I'm populating a table using predefinded autotext chosen by selecting checkboxes on several forms, the table has a blank row with a single bookmark that all checkboxes reference. See example below. If chk1.Value = True Then ActiveDocument.Bookmarks("ActionItems").Select ActiveDocument.AttachedTemplate.AutoTextEntries("Electrical SafetyGFCIs") _ .Insert Where:=Selection.Range End If I'd like the order of entries in the table to reflect the order chosen on the forms. Currently the first option chosen shows up last, and the last option shows up first. I don't believe there's an insert before or after with the method I'm using above. Does anyone have any suggestions on I can influence the order? I hope this makes sense. Any help would be greatIy appreciated. Thanks, Dave dww8450@sbcglobal.net Tag: Using VBA to work with Office search results Tag: 66695
  - 8
    - Can Word characters can be presented in a reversed format? (i.e.. Is there a method whereby a symbol or character can be reversed in a word formula (for subsequent use in developing a user-defined special/combination character? If so, are similiar techniques available in other "MS Office" programs(including XP platforms)? Tag: Using VBA to work with Office search results Tag: 66694
  - 9
    - Range.insertafter Hello, Could someone out there please tell me what the significance of Range and InsertAfter in the following statement? I'm soooooo good at using selection.everything but Range puzzles me. Thanks! oDoc.Range.InsertAfter Tag: Using VBA to work with Office search results Tag: 66681
  - 10
    - How to pop MsgBox in front of all other windows? I have a vb.net program that is doing some stuff with Word. I want to pop up a MsgBox from time to time to get the user's interaction. When I do, it is behind other windows and I have to find the window to see the MsgBox. How can I make it pop in front of all the other windows? Thanks. Tag: Using VBA to work with Office search results Tag: 66680
  - 11
    - Inserting text at ranges..... Hi folks, I never was very good at using Ranges to insert text. In this particular case I am populating a template from a form. I was using paragraphs(25) to insert text at paragraph 25 and then insert some different text in a list on the next line, but because the text above paragraph 25 can change sometimes paragraph(25) ends up being paragraph(28). I could use bookmarks, or evena table, but I was wondering if their was a beter way? Ultimately what I am inserting looks like: This report relates to the interview with SMITH. He has access to markets: * Market 1 * Market 2 * Market 3 etc...... Cheers, -Al Tag: Using VBA to work with Office search results Tag: 66679
  - 12
    - Can one Filter File types in wdDialogFileOpen? I'd like to filter the file selection in the wdDialogFileOpen dialog. I know you can do it in MSO File Dialogs, but I can't find a way to do it with the Word dialog. Any ideas? Tag: Using VBA to work with Office search results Tag: 66678
  - 13
    - Updating list from macro using form I have a dropdown list box within a Word 2000 table. When the user clicks on the field, the list of values is propegated with values listed in the on click event macro. I would like the user to be able to edit the macro's list of values without requiring them to know how to use the VBA editor. Is it possible to use a user form to get those values from the macro and allow the user to edit the values and save those changes back to the macro? If so, I need some help in the process and linking the form fields to the macro list. Is there a better way? Thank you. Tag: Using VBA to work with Office search results Tag: 66675
  - 14
    - how to format outlook email? hi, in a word template, i want to format the body of an email and send it out using outlook. how can i create an outlook obj., and make the body text italic, bold, and etc. in word xp? using range obj. like that in word? use HTML tags? thank you, will. -- Tag: Using VBA to work with Office search results Tag: 66674
  - 15
    - Hyperlink, form and TOC ! Hello, I want to keep active hyperlinks in a protected form and I find the article from word.mvps.org (a gold mine!!!) to do it...but I want to keep possible navigating between the TOC and titles of the documents (I inserted hyperlink for each!)!!! With title's hyperlinks : no problem ! But the method don't work when I try to nest the toc field with the macrobutton calling the "followLink" sub ! A little bit more complicated !!! Any idea to adapt the MVPS method or another to solve this TOC problem? Thanks in advance for your help (with word.mvps.org, a few others and your help with this forum ...my first word macro is almost finished ...just this navigationt... but important for my doc) Tag: Using VBA to work with Office search results Tag: 66670
  - 16
    - Word 2003 SaveAs wdFormatDOSText bug When I run a macro, such as this: ActiveDocument.SaveAs FileName:="c:\temp\testdoc.txt", FileFormat:=wdFormatDOSText It is not removing all of the non-DOS characters. When I do it interactively, it works, but it prompts me with Security warnings. It appears interactively, it's setting the FileFormat=100 instead of wdFormatDOSText, which = 4. (Obtained by recording a macro) I need to be able to do this without security warnings and without non-DOS characters. Anyone know of a fix? Thanks for any help. -cp Tag: Using VBA to work with Office search results Tag: 66667
  - 17
    - Delete Current Bookmark Hey Gang, back with another question: Word XP I have a bookmarked document that I am trying to manipulate various bookmarks to create subdocuments. I have code that bookmarks selected paragraphs with incremented bookmark names, and it works fine. I also have code that goes through and deletes all bookmarks in the document, if needed. What I can't seem to get is to delete the current bookmark. For example, if a user selects text and assigns a bookmark to it (bma_8, for example). I know they can select the text, click "Insert", "Bookmarks", click the "Delete" button and that bookmark is deleted. I also know that you can select a bookmarked set of text and assign a different bookmark to it (bmb_5, for example). But I am trying to create a macro that does the following (after a selection of bookmarked text has been made): - Determine the bookmark name, then delete that bookmark (not the text, just the bookmark itself). Using the recorder, simply includes the bookmark name of the selected text. I want it to be variable so whatever bookmark is selected, it can be deleted. The concept of the code I need (which I obviously can't get to work) is below: ======== Sub DeleteCurrentBookmark() Dim Mybm As Bookmark With Selection.Bookmarks If .Count = 1 Then Set Mybm = .Item(1).Name ActiveDocument.Bookmarks(Mybm).Delete End If End With End Sub ======== TIA! -- Bill Foley, Microsoft MVP (PowerPoint) Microsoft Office Specialist Master Instructor - XP www.pttinc.com Check out PPT FAQs at: http://www.rdpslides.com/pptfaq/ Check out Word FAQs at: http://word.mvps.org/FAQs/General/index.htm Tag: Using VBA to work with Office search results Tag: 66665
  - 18
    - Possible to Store some hidden binary data in Word Document???????????? hi! is it possible to store some binary data into the Word document using VBA or C++. Actually i have to store some binary data read from some files into the word document through my Word Plugin. This binary data will be hidden from the user. Other people will not be able to access it. only my Addin will access it. This binary data may be placed once, twice, or more inside the Word document. Anybody have idea about it. Thanks. Ahmad Tag: Using VBA to work with Office search results Tag: 66661
  - 19
    - How did I lose "Paste Special" in text boxes?? I wondered why my macro kept throwing an error: it adds a text box and then does a Paste Special inside it. Or it did, until a few weeks ago. I thought I was messing up with the manual Copy beforehand or something. Then I manually drew a text box and went to the Edit menu - and Paste Special was grayed out??!? Outside the text box, the Paste Special works fine, and it *used* to work inside the box as well! (Word 2000) Did I accidentally check or uncheck something? Where do I start looking to resolve this? Ed Tag: Using VBA to work with Office search results Tag: 66659
  - 20
    - How to build the search string to find numbers from 75 to 99? Hi, I do not know if this is the right group to post this message. I needed to search for the numbers between 75 and 99. I built 2 search strings using wildcards (I am not using VBScript regular expressions). One for numbers from 75 to 79, and the second for the numbers from 80 to 99. It works fine. Anyway, I wonder if it is possible to build one search string that would find numbers between 75 and 99 using wildcards. Thank you very much. Regards, Robert Tag: Using VBA to work with Office search results Tag: 66656
  - 21
    - Styles Is there an equivalent of .clearformatting with respect to styles? How do I programatically clear all the current style options, use the default style and apply my settings on to it? I want to base my style on "no style" and then add some formatting to it. I am not sure how to do this through VBA. Thanks for your time. Vince Tag: Using VBA to work with Office search results Tag: 66651
  - 22
    - Word Addin Hello All, I am making a Word Add-in in VB.NET. I am willing to have my own Menu Item in the Menu Bar like File, Edit, Etc and under my Menu item i will be having some more items as File->New, Edit->Copy, etc. Now i am getting 2 problems: 1/ When I run the program for 1 document things are fine but when i open more than 1 document simultaneously than I did not get that menu working (menu is shown but its not functioning) in other documents than the 1st document. I have solved this problem by creating the menu item at AppObj_WindowActivate function but this function is called whenever the document is activated even i minimize or maximize the document. 2/ When I uninstall the package that I install then the Menu Item is not removed. Its functionality are removed but with that the menu item should also be deleted which is not deleted. So i have to manually remove it so that it is not visible later on. Please help me with these 2 problems as I am in great trouble. GS Tag: Using VBA to work with Office search results Tag: 66649
  - 23
    - Find older file version I created a file in Word XP, saved it and then opened it again, but unwittingly hit OK to the pop-up question "Do you want to revert to the original saved file?" Now all I have are 3 lines on the file which had some 1000 words. Help please! Tag: Using VBA to work with Office search results Tag: 66647
  - 24
    - Restore Find box settings I am trying to save and then restore the settings for the find box. I've tried the following code, but the .style setting is always left as 'sdPart' instead of whatever the style name was before the procedure is run. Thanks for any advice. --------------------------------------- Sub MessWithFindBox2() Dim fFind As Find Set fFind = Selection.Find '********************* With Selection.Find .ClearFormatting .Text = "" .Style = "sdPart" .Execute End With '********************* Selection.Find.Style = fFind.Style End sub Tag: Using VBA to work with Office search results Tag: 66642
  - 25
    - Adding CommandBarControls in VBA with Word Hi All I'm automating showing the "Mail Merge" menu and if it is nor visible then adding the "Insert Merge Field" pop up. I have mastered showing the command bar but I am having problems with getting the pop up to work. I've added the pop up but there ar no fields in the list. Having recorded a macro to check what is happening I get: Sub Macro2() ' ' Macro2 Macro ' Macro recorded 13/04/2005 by Tim Davies ' CommandBars("Mail Merge").Controls.Add Type:=msoControlPopup, ID:= 30076 End Sub But if I remove the pop up and run the macro it is added but does not list the field in the merge data source. Any pointers would be great. Cheers Tim Davies using Word 2002 SP3 Tag: Using VBA to work with Office search results Tag: 66634
- Next
  - 1
    - y a part of data stored into previous ActiveX control loses if i insert new ActiveX hi! i have written an activex control for word that stores some binary data. now when after placing my control into word doc i store binary data (varry between 25KB to 10MB). control persists it. when i close it and reopen the document it is there. but when i place another control and store data into it, the data stored into the first control is truncated, not the whole data but only few KBs. I tried to find out the reason but couldn't. Is there any Guru to give me a hand. I am in too much tension about this problem. Plz help me. Thanks in advance. Ahmad Jalil Qarshi Tag: Using VBA to work with Office search results Tag: 66625
  - 2
    - Using Word instead of web form interface for entering data into SQL Server database Hello all! I would like to as for an advice: what's the most suitable way, if it's indeed possible at all, to use a Word document as an interface for entering the data into a SQL database, just as it would have been done by using a web form? I would like the data to be saved in SQL database when the Word document is saved. Also, I would like to put this Word document as a template in the SharePoint Portal Server site.... Thank you in advance, Hrvoje Tag: Using VBA to work with Office search results Tag: 66624
  - 3
    - Embedded word tables in Powerpoint Hi there, I have a macro that copies embedded word tables in PPT to a WORD document, but with large PPT files I get a Word error "Insufficient Memory or Disk space. Close extra windows and save your work", but I have a lot of RAM and disk space. Also, if I try to debug VBA, the 'Set oDoc = shp.OLEFormat.Object' becomes yellow. Does anybody have a clue what's going on here? something I forgot to clean-up in the code? Thanks so much! JS ==================================== Sub CopyPastePPT2Word() Dim shp As Shape Dim sld As Slide Dim wdApp As Word.Application Dim oDoc As Word.Document Set wdApp = New Word.Application With wdApp .Documents.Add .Visible = True End With For Each sld In Application.ActivePresentation.Slides For Each shp In sld.Shapes If shp.Type = msoEmbeddedOLEObject Then If shp.OLEFormat.ProgID = "Word.Document.8" Then Set oDoc = shp.OLEFormat.Object oDoc.Select Selection.Copy With wdApp .Selection.Paste .Selection.TypeParagraph End With Set oDoc = Nothing End If End If Next shp Next sld End Sub Tag: Using VBA to work with Office search results Tag: 66615
  - 4
    - Can I automate dropping access tables into a word template? We have a word template we use for generating monthly reports. Much of the data for these reports resides in Access databases. Presently we run a query in access and paste the results into the word document. If the queries are standard is it possible to set up the word template to place the query results in the appropriate place each time a doc is created from the template? I've only done a few lines of VB in word (but lots of it in other apps), but if there's a way to do it and someone can point me in the right direction, that would be great! Tag: Using VBA to work with Office search results Tag: 66613
  - 5
    - GetAddress differences I have a small template which creates a customized envelope (special return address w/ logo) and Bar Coding. The template uses the GetAddress function to lookup names in one of two Contact lists of Outlook. The template used to work fine until my hard-drive crashed and I had to rebuild using a new version of Windows (XP-Pro). I reinstalled Office 2000 and was able to recover all of my templates. I am having two problems now: 1) The Select Name dialog box does not sort/display the names by {Last Name}, {First Name} (it is sorting/displaying by {First Name} {Last Name}. 2) It no longer uses the "default" mailing address as the PR_STREET_ADDRESS field even though it is selected in Outlook. It only uses the Business Address (this never happened before). Iâ??ve tried looking at a bunch of options in Outlook but Iâ??m not sure why it worked before. Iâ??m running the latest "patched" version of Office 2000. Thank you for your time in advance. Sincerely, Paul D. Goldstein Tag: Using VBA to work with Office search results Tag: 66608
  - 6
    - Converting RTF to DOCs I have a folder full of RTF files saved with .doc extensions created by the Adobe Acrobate 6.0 Standard Save As feature. I found the following macro code at http://support.microsoft.com/default.aspx?scid=kb;en-us;242875: Sub convert() Dim strFile As String Dim X As String Dim Y As String Dim Z As Object 'Collect Drive and directory to convert Word Docs in. X = InputBox("Please enter the drive the documents are on.", "Drive Letter", "C") Y = InputBox("Please enter the path to the directory the files are in.", "Path to files", "My Documents") 'seed the string to the first file in the directory strFile = Dir(X & ":\" & (Y) & "\" & "*.rtf") ' Start looping through files opening and saving as current version of Word. On Error Resume Next Do While strFile <> "" Documents.Open X & ":\" & (Y) & "\" & strFile, Format:=wdOpenFormatRTF ActiveDocument.SaveAs (X & ":\" & Y & "\" & strFile), FileFormat = wdFormatDocument ActiveDocument.Close strFile = Dir Loop 'Alert user operation is complete MsgBox "done" End Sub How do I convert this code into a stand-alone script file so I can distribute it? -- Regards, Ward Tag: Using VBA to work with Office search results Tag: 66607
  - 7
    - Close EXCEL.EXE process Hi I need to kill Excel process totaly. After excel is close a Excel.exe process stays on. How can I close excel for good ? Regars Mikko I have used this macro to open workbook Sub chart() Dim oXL As Excel.Application Dim oWB As Excel.Workbook Dim oSheet As Excel.Worksheet Dim oRng As Excel.Range Dim ExcelWasNotRunning As Boolean Dim WorkbookToWorkOn As String 'specify the workbook to work on WorkbookToWorkOn = "C:\Documents and Settings\All Users\Huoltoraportti\ chart.xls" 'If Excel is running, get a handle on it; otherwise start a new instance of Excel On Error Resume Next Set oXL = GetObject(, "Excel.Application") If Err Then ExcelWasNotRunning = True Set oXL = New Excel.Application End If On Error GoTo Err_Handler 'If you want Excel to be visible, you could add the line: oXL.Visible = True here; but your code will run faster if you don't make it visible 'Open the workbook Set oWB = oXL.Workbooks.Open(FileName:=WorkbookToWorkOn) 'Process each of the spreadsheets in the workbook 'For Each oSheet In oXL.ActiveWorkbook.Worksheets 'put guts of your code here 'get next sheet Sheets("Taul1").Select Range("B2").Select ActiveCell.FormulaR1C1 = Me.TextBox1.Value Range("C2").Select ActiveCell.FormulaR1C1 = Me.TextBox2.Value Range("D2").Select ActiveCell.FormulaR1C1 = Me.TextBox3.Value Range("E2").Select ActiveCell.FormulaR1C1 = Me.TextBox4.Value Range("F2").Select ActiveCell.FormulaR1C1 = Me.TextBox5.Value Range("G2").Select ActiveCell.FormulaR1C1 = Me.TextBox6.Value Range("H2").Select ActiveCell.FormulaR1C1 = Me.TextBox7.Value Range("I2").Select ActiveCell.FormulaR1C1 = Me.TextBox8.Value Range("J2").Select ActiveCell.FormulaR1C1 = Me.TextBox9.Value Range("K2").Select ActiveCell.FormulaR1C1 = Me.TextBox10.Value Range("L2").Select ActiveCell.FormulaR1C1 = Me.TextBox11.Value Range("M2").Select ActiveCell.FormulaR1C1 = Me.TextBox12.Value Range("B3").Select ActiveCell.FormulaR1C1 = Me.TextBox13.Value Range("C3").Select ActiveCell.FormulaR1C1 = Me.TextBox14.Value Range("D3").Select ActiveCell.FormulaR1C1 = Me.TextBox15.Value Range("E3").Select ActiveCell.FormulaR1C1 = Me.TextBox16.Value Range("F3").Select ActiveCell.FormulaR1C1 = Me.TextBox17.Value Range("G3").Select ActiveCell.FormulaR1C1 = Me.TextBox18.Value Range("H3").Select ActiveCell.FormulaR1C1 = Me.TextBox19.Value Range("I3").Select ActiveCell.FormulaR1C1 = Me.TextBox20.Value Range("J3").Select ActiveCell.FormulaR1C1 = Me.TextBox21.Value Range("K3").Select ActiveCell.FormulaR1C1 = Me.TextBox22.Value Range("L3").Select ActiveCell.FormulaR1C1 = Me.TextBox23.Value Range("M3").Select ActiveCell.FormulaR1C1 = Me.TextBox24.Value Range("M4").Select Sheets("Kaavio1").Select 'Next oSheet If ExcelWasNotRunning Then 'oXL.SaveWorkspace oXL.DisplayAlerts = False oXL.Application.Workbooks.Close oXL.Quit End If 'Make sure you release object references. Set oRng = Nothing Set oSheet = Nothing Set oWB = Nothing Set oXL = Nothing 'quit Exit Sub Err_Handler: MsgBox WorkbookToWorkOn & " caused a problem. " & Err.Description, vbCritical, _ "Error: " & Err.Number If ExcelWasNotRunning Then oXL.Quit End If End Sub -- Message posted via http://www.officekb.com Tag: Using VBA to work with Office search results Tag: 66606
  - 8
    - macro to print wide table on successive pages Can a macro be created to print a wide table on successive pages. I have a wide table (it is already landscape). Can a macro split it (say at 10 in.) and print the second part on a successive page? Excel does this easily, but I need to do it in word (I have formatting in the table that needs to be retained). Tag: Using VBA to work with Office search results Tag: 66601
  - 9
    - Help getting size box on pasted-in tables? I generate a lot of tables in Excel and paste them into Word (using Excel and Word 2000). I've gone through several methods of trying to do this, most driven by the size and functionality of the table after it's pasted in. I can paste in an Excel table, and it becomes a Word table, but often the size is way too big. I've been doing this for years, and I have just now discovered the little sizing box in the lower right corner of a table!! This could be great - except for one thing. When I paste in a table that overflows the right margin, I can't get to the sizing box! Can someone give me tips on how to manage this, either in the document or with VBA, to get a handle on this handle when it's off the edge? Ed Tag: Using VBA to work with Office search results Tag: 66598
  - 10
    - Form Load error on some machines Hello, I am really stumped... I got a form that loads up when a user opens a word template .dot file that has some VBA to run in it. the first form show up and has a very simple button that when click clears the start form and shows another...using variations of the code below. All machines are running Word 2003 on Windows Xp service pack 2 Private Sub CommandButton1_Click() ''Unload Me Unload frm_warning UserForm1.Show (False) ''Form.Show UserForm1 End Sub Again most machines work, but a couple of computer have errors such as "Type Mismatch" and stop on the UserForm1.Show line... If anyone has any idea why this might happen, please let me know all the computers are running Visual Basic 6.3 . would there be another dll or scripting automation plugin which might be missing? Thanks, yurps Tag: Using VBA to work with Office search results Tag: 66595
  - 11
    - Can I setup a TOC to update programatically? Instead of manually hitting the F9 key to update a Table of Contents page numbers, is there a way to automatically set this up? I would hope to write some VBScript code to do this, but am not sure if it is possible. Thanks. Tag: Using VBA to work with Office search results Tag: 66594
  - 12
    - If statement results inconsistent I have a userform where the user enters some numbers. I want to check that the number identified as "mininum temp" is lower than the one identified as "maximum temp". I wrote: Private Sub CommandButton2_Click() 'next button ActiveDocument.FormFields("mintemp").Result = mintemp.Value ActiveDocument.FormFields("maxtemp").Result = maxtemp.Value ActiveDocument.FormFields("cur").Result = cur.Value ActiveDocument.FormFields("minpres").Result = minpres.Value ActiveDocument.FormFields("avgh").Result = avgh.Value ActiveDocument.FormFields("maxh").Result = maxh.Value ActiveDocument.FormFields("process").Result = process.Value ActiveDocument.FormFields("contam").Result = contam.Value If mintemp.Value = "" Then MsgBox ("Please enter minimum temperature.") mintemp.SetFocus ElseIf maxtemp.Value = "" Then MsgBox ("Please enter maximum temperature.") maxtemp.SetFocus ElseIf cur.Value = "" Then MsgBox ("Please enter current temperature") cur.SetFocus ElseIf avgh.Value = "" Then MsgBox ("Please enter average humidity.") avgh.SetFocus ElseIf maxh.Value = "" Then MsgBox ("Please enter maximum humidity.") maxh.SetFocus ElseIf mintemp.Value > maxtemp.Value Then MsgBox ("Minimum temperature cannot be greater than maximum temperature.") mintemp.SetFocus Else ambient.Hide AirTreatDetail.Show End If End Sub This works the first time, and maybe the second time, but the more times I go through it the less it works. Sometimes I can only avoid the message box when both numbers are equal. What is wrong? Tag: Using VBA to work with Office search results Tag: 66593
  - 13
    - Inserting a radio button in a document I'd like to be able to use option buttons in a document that I can click on to turn on or off. I don't know what the macro code is to do this when I insert one from control toolbox. Any assistance much appreciated. Using Word 2003 Tag: Using VBA to work with Office search results Tag: 66592
  - 14
    - MS Word drop downs I am not vb programmer. Can anyone help define method to associate 2 drop down list boxes? As example, suppose first drop down is Area (i.e., work area (Procurement, Finance, Logistics, etc.)). Second drop down is Title (i.e., job title (clerk, manager, director, etc.)). Title list of values is dependent upon Area (i.e., noted titles only pertain to Procurement Area). Thanks in advance for any help you can provide. Tag: Using VBA to work with Office search results Tag: 66590
  - 15
    - Why can't I post, answered It turns out I had to disable ie's popup blocker. Is it possible, that I'm the first person this happened to? -- papagru Tag: Using VBA to work with Office search results Tag: 66589
  - 16
    - Document Map To change the document map, Word help says to right-click on the map, but when I do, nothing happens (my right click works every where else). Any ideas? Also, can the Document Map be changed with VBA? Thanks. Tag: Using VBA to work with Office search results Tag: 66586
  - 17
    - How do I get the current line number in a macro? In Word 2002, I need to locate and list locations at which a string is found in the document. Once find locates the string, how do I assign the then current line number to a variable? Thanks for any suggestions, Larry Tag: Using VBA to work with Office search results Tag: 66585
  - 18
    - Macro Security Level ! HI ! I know it's not possible to check the security level with VBa when the doc is open by a user. ...but I want the user changes this security level and so ...I would like to avoid the user doing anything else in the opening doc excepted: - reading a message explaining the user must change the security level to the "middle" level if an above level is checked -checking the security level -closing the doc without saving it ..or anything else to get similar results ... ...until the security level is middle or under ...and so the doc will open normally at this time ! Any help to try writting this? Thanks in advance! Thierry Borgne Tag: Using VBA to work with Office search results Tag: 66577
  - 19
    - run some code before doc opening Hi I would like to parse the doc name to be opened and run some code before document opening if when parsing the document name I found some particular stuff.. Within the (document_open event) if instr("key string",activedocument.name) >0 then run some code else end if I can't get it working , can someone give me some help ? Am I doing something wrong ? How can I achieve that ? Tag: Using VBA to work with Office search results Tag: 66576
  - 20
    - Insert date and time? I have one textfield in my word document. I want when I open my document to automticly insert date and time in textfield. Tag: Using VBA to work with Office search results Tag: 66574
  - 21
    - checking if a folder exists before using rmdir to delete it Calling RMDIR to delete a folder that does not exist results in an error ... what is the easiest way to test if a folder exists? Thanks, in anticipation of assistance, Peter E Tag: Using VBA to work with Office search results Tag: 66572
  - 22
    - Disappearing bookmarks Hello, I've encountered strange bookmark behaviour. The code is in C# but it should not matter: // myWordApp variable points to the Application object // myBookmark variable points to a bookmark. myBookmark.Select(); Word.Selection selection =3D myWordApp.ActiveWindow.Selection; selection.Text =3D "\xD6"; So far so good, but if I do: selection.Font.Name =3D "Wingdings"; or selection.InsertParagraphAfter(); The bookmark disappears. Can anyone explain what's going on and how to overcome this issue? Thanks, Alex. --=20 Address email to user "response" at domain "alexoren" with suffix "com" Tag: Using VBA to work with Office search results Tag: 66562
  - 23
    - prevent template macros copying to new documant I have macros in a template used to create a specific naming convention when saved. I do not want these templates in the newly created document. Is it possible to set Word to not copy the macros? If so how? Please respond to my email address preflyght-1@yahoo.com Thanks! Tag: Using VBA to work with Office search results Tag: 66560
  - 24
    - UserForm Data Capture in Word I have designed a UserForm in a word document that has a couple of comboboxs with drop down lists and a few text boxes. What do I need to do in VBA to transfer the data the user has entered into specified places in the document? Am I also able to insert other documents depending on the result of a combobox? -- Dave Tag: Using VBA to work with Office search results Tag: 66550
  - 25
    - GetSpellingSuggestions -- 9132 Hello, I have successfully used the wdWildcard and wdAnagrams constant with the SuggestionMode argument for the GetSpellingSuggestions method for Word in Office 98. But these constants cannot be used with Word 2000 and Word 2003 (see: http://support.microsoft.com/default.aspx?scid=kb;en-us;224722 ). Is there any way I can use the dll and other files from Office 98 to beef-up my Word 2003 so that I get support for these constants? If so, how? Thanks, --Suresh Tag: Using VBA to work with Office search results Tag: 66546

When I run a search using one of the Office programs I get a list of file
titles that I can't seem to do anything with other than copy them one by one,
e.g., to a spread sheet. With some searches yielding a hundred or more files,
this is not workable.

I would think that I would be able to access and work with this list via
VBA, but I can't find anything that tells me how to do this.

I'd like to be able to save the results of various searches in an Excel
spread sheet (and ultimately in an Access DB), where I would be able to add
additional information about the various files.

I think what I need to know is how to reference that result window in the
Office object model and what things I can do with it once I can reference it.

Thanks.

Top

Re: Using VBA to work with Office search results by Howard

Howard
Fri Apr 15 13:02:14 CDT 2005

Use the object browser and search for "Search".

--
http://www.standards.com/; See Howard Kaikow's web site.
"Windowed" <Windowed@discussions.microsoft.com> wrote in message
news:37A7EB27-8D51-47F5-BF90-44E7FFA70FC0@microsoft.com...
> When I run a search using one of the Office programs I get a list of file
> titles that I can't seem to do anything with other than copy them one by
one,
> e.g., to a spread sheet. With some searches yielding a hundred or more
files,
> this is not workable.
>
> I would think that I would be able to access and work with this list via
> VBA, but I can't find anything that tells me how to do this.
>
> I'd like to be able to save the results of various searches in an Excel
> spread sheet (and ultimately in an Access DB), where I would be able to
add
> additional information about the various files.
>
> I think what I need to know is how to reference that result window in the
> Office object model and what things I can do with it once I can reference
it.
>
> Thanks.

Top