Linking Excel files that could have a variable path name?

Tutorials Win: Microsoft Windows Forum

- Previous
  - 1
    - How to move the active document? SaveAs does not change ActiveDocument How does one move the active doc; this issue is givimg all sorts of problems. I've tried several solutions but not work reliably. For instance, I thought I'd perform a SaveAs from within Word; that should move the Active Document pointer or whatever it's called to the newly saved doc; the orig doc should be closed. Then, use Kill to delete the orig file. This approach works fine on some machines, on other machines it fails with error 70 permission denied. The orig file is still open on some machines (but not others). On those machines I can see that the file exits in both locations, and the open file is the orig file. Why is word so inconsistent with this fundemental behavior? Via menu choices, in all cases SaveAs moves the current file to the "new" file. I am programming in Word 2002 and the machines that have this issue are Word 2000 - but the saveas behavior is so basic that I can't imagine that it's deliberately different programming this in the two versions. I have doevents all over the place. And, if I try to close the word doc in it's original location, I error out with "Bad File Name", when I can see the file is still at that location. Frankly programming word is a real pita. Handy when it works but terrible getting it there. Tag: Linking Excel files that could have a variable path name? Tag: 56919
  - 2
    - How to move the active document? SaveAs does not change ActiveDocument How does one move the active doc; this issue is givimg all sorts of problems. I've tried several solutions but not work reliably. For instance, I thought I'd perform a SaveAs from within Word; that should move the Active Document pointer or whatever it's called to the newly saved doc; the orig doc should be closed. Then, use Kill to delete the orig file. This approach works fine on some machines, on other machines it fails with error 70 permission denied. The orig file is still open on some machines (but not others). On those machines I can see that the file exits in both locations, and the open file is the orig file. Why is word so inconsistent with this fundemental behavior? Via menu choices, in all cases SaveAs moves the current file to the "new" file. I am programming in Word 2002 and the machines that have this issue are Word 2000 - but the saveas behavior is so basic that I can't imagine that it's deliberately different programming this in the two versions. Frankly programming word is a real pita. Handy when it works but terrible getting it there. Tag: Linking Excel files that could have a variable path name? Tag: 56917
  - 3
    - Showing bookmark names I have created a form in Word 2003 which has both fields and bookmarks, I know how to show where the bookmarks are, but is there any way to show the names of the fields and bookmarks on the page? Tag: Linking Excel files that could have a variable path name? Tag: 56916
  - 4
    - How do i create a document wizard? I'm working on a publication through microsoft word 2003. I want to be able to have the same basic format for a document everytime i open it, but i need a wizard at the beginnin that will ask for Date, Issue number, etc...then will automatically plug that info into the template. Help! Tag: Linking Excel files that could have a variable path name? Tag: 56907
  - 5
    - Word VBA book recommendations I would like to buy a Word VBA book. In looking at Amazon, the "Word VBA 2000 Developers Handbook" (something like that) seems to be the best. Would anybody agree or disagree? Also, all the WOrd VBA books are a little dated. Does anybody know if any new editions are slated to come out? If I am running Word 2003 on XP Pro, what kind of problems may arise from using a book meant for Word 2000? Thanks for any responses. Tag: Linking Excel files that could have a variable path name? Tag: 56903
  - 6
    - Project Unviewable Word 2000 Recently, I have been getting a lot of errors in the VB editor that state something along the lines of "Project is unviewable." If I simply close the document and re-open it, I can get back into the project. This happens 4 or 5 times a day, and it's REALLY annoying. What causes this, and how can I fix it for good? --Tom Tag: Linking Excel files that could have a variable path name? Tag: 56886
  - 7
    - Run-time Error '4608' Value Out of Range Word 2000 This has been driving my nuts for the last couple of days. I have the code below in a set of fairly extensive macros. This code has been working flawlessly for months. Recently, I've been working on adding some error trapping to the project, but I haven't touched this particular subroutine. Now when I run this code it sometimes gives me the following error: Run-time Error: '4608' Value Out of Range Here's the code (I've marked the line that causes the error with ">>>"). ***************** Sub PasteLocate() ' Checks for the existance of the required bookmarks and document variables. CheckRequiredBookmarks ' Pastes the Locate into the document. Selection.EndKey Unit:=wdStory Selection.Paste ' Bookmarks the record in the document using the MIN or NIC as part of the bookmark name. Selection.GoTo what:=wdGoToBookmark, Name:="StartOfRecord" Selection.Extend Selection.EndKey Unit:=wdStory BookmarkName = "Record" & RecordNumber If Override Then BookmarkName = "Override" & BookmarkName ActiveDocument.Bookmarks("\Sel").Copy BookmarkName ' Finds the MIN or NIC in the selected text, creates a range covering that location, and ' bookmarks the range using the MIN or NIC as part of the bookmark name. StartPos = InStr(1, Selection.Text, Chr(13) & RecordType & "/", vbTextCompare) + 4 RangeStart = Selection.Start + StartPos RangeEnd = RangeStart + RecordNumberLength >>> Set RecordNumberRange = ActiveDocument.Range(Start:=RangeStart, End:=RangeEnd) <<< BookmarkName = RecordType & RecordNumber If Override Then BookmarkName = "Override" & BookmarkName ActiveDocument.Bookmarks.Add Name:=BookmarkName, Range:=RecordNumberRange ' Finds the MRI in the selected text, creates a range covering that location, and ' bookmarks the range using the MRI as part of the bookmark name. StartPos = InStr(1, Selection.Text, MRITag, vbTextCompare) + 3 RangeStart = Selection.Start + StartPos EndPos = InStr(StartPos + 1, Selection.Text, " ", vbTextCompare) - 1 RangeEnd = Selection.Start + EndPos Set RecordNumberRange = ActiveDocument.Range(Start:=RangeStart, End:=RangeEnd) BookmarkName = "MRI" & cbMRI If Override Then BookmarkName = "Override" & BookmarkName ActiveDocument.Bookmarks.Add Name:=BookmarkName, Range:=RecordNumberRange ' Collapses the selection, inserts a paragraph, and redefines the StartOfRecord bookmark. Selection.Collapse (Down) Selection.TypeParagraph ActiveDocument.Bookmarks("\StartOfSel").Copy "StartOfRecord" BottomOfDocument = True End Sub ***************** I've checked the values of RangeStart and RangeEnd, and they are well within the block of text being processed (i.e. Neither value is beyond the end of the document or anything like that). I also tried putting RecordNumberRange in the declarations, but that didn't make any difference one way or the other. Curiously, the second Set RecordNumberRange command has never caused an error. The bizzare thing is that the error doesn't happen all the time. For the last two days, I've been getting the error about 90% of the time. But just now I completed a test that ran this subroutine more than 50 times, and I didn't get a single error. The thing is, I didn't change anything! The code that just ran 50+ times without an error is the SAME code that was previously causing an error 90% of the time. There were literally NO changes. Now, I could just trap this error with On Error Resume Next, but I would prefer to know what's causing of the error. One thing that I am wondering about is the document itself. I've been using the document for months--adding and deleting large section of text, creating the deleting bookmarks, running my code and then undoing everything, etc. I'm wondering if the document is becoming corrupt, and maybe the code needs to be copied to a fresh document. Is that possbile? Another thing that I'm wondering about is the fact that I've added more modules. Initially, all the code was contained in the ThisDocument module. With the addition of the error trapping features I've been developing, I've added 2 more modules--one that declares a couple of public variables, and one that contains and Option Explicit statement and declares a function for passing information from the Err object to a button on a custom form. Could it be that something about one of those modules is causing the problem? Any ideas? --Tom Tag: Linking Excel files that could have a variable path name? Tag: 56885
  - 8
    - Updating text boxes..... Hi Folks, On my form, users can enter data directly into a text box, or they can past it into the text boxs from the clipboard data with a special "Paste from 3rd Party App" button that I have done. When they type the data in themselves I have a little Procedure : Private Sub TextBox1_Change() TextBox1 = StrConv(TextBox1, vbProperCase) End Sub To make sure the names are property formatted etc. The problem is that when I : "Paste from 3rd Party App" none of the formatting is applied to the text boxes! How would I go about getting them all updated? The only way I came up with was to maybe have a new procedure that updated every textbox every time it was ran, so something like: Sub Update() TextBox1 = StrConv(TextBox1, vbProperCase) TextBox2 = StrConv(TextBox1, vbProperCase) TextBox3 = StrConv(TextBox1, vbProperCase) TextBox4 = StrConv(TextBox1, vbProperCase) End Sub and also still have; Private Sub TextBox1_Change() Call Update End Sub Private Sub TextBox2_Change() Call Update End Sub Private Sub TextBox3_Change() Call Update End Sub Private Sub TextBox4_Change() Call Update End Sub But their must be a better way? Thanks -Al -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- Tag: Linking Excel files that could have a variable path name? Tag: 56875
  - 9
    - word installed. create spellcheck icon in IEbrowser for highlited. word installed. create spellcheck icon in IEbrowser for highlighted text. Tag: Linking Excel files that could have a variable path name? Tag: 56865
  - 10
    - dashes in phone nos I am automating word from access, office 2000 winxp My access table contains 2 phone numbers and a social security number (500) 222-2222, (500) 333-3333, 444-44-4444 I am storing these values in the tables with the dashes and parantheses in place, but when I use the value and set it in a bookmark in an msword doc, the dashes and parens are not displayed. How can I remedy this, please? Thank you Joanne Tag: Linking Excel files that could have a variable path name? Tag: 56857
  - 11
    - Updating the screen MS Word 2003 A macro contains the following statements: ActiveDocument.ShowGrammaticalErrors = False ActiveDocument.ShowSpellingErrors = False After issuing the above two statements, what statement will update the screen? The colored underlining remains in the currently-viewed text. Only after I scroll the document so that a new area of text is displayed is the colored underlining gone. (If I scroll one-half the screen height, the coloring remains in the previously displayed area, and is gone only from the newly displayed area.) Thanks, Fred Holmes Tag: Linking Excel files that could have a variable path name? Tag: 56854
  - 12
    - Less View in Find I always want the "Less view" in find (and not be given the advanced find criteria unless I ask for it). Here's the code I'm trying, unsuccessfully: SendKeys "%{l}" (or) SendKeys "%{L}" Please help, guys. TIA Tag: Linking Excel files that could have a variable path name? Tag: 56850
  - 13
    - Bookmarks from access I'm trying to get an example from a book (Wrox - Accesss 2002 VBA) running. It's supposed to insert text into a word document at pre-set bookmarks. However it keeps crashing at the line: m_objDoc.Bookmark(strBkmk).Select In the InsertTextAtBookMark prodecure. The error message is: Run-time error '91'; Object variable or With Block variable not set I've included the full code below. Any help greatly appreciated. ------------------------------------------------------------------- Option Compare Database Option Explicit Private Const m_strDIR As String = "C:\BegVBA\" Private Const m_strTEMPLATE As String = "Order.dot" Private m_objWord As Word.Application Private m_objDoc As Word.Document Public Sub CreateOrderLetter(recSupp As Recordset, recItems As Recordset) ' instantiate the word application and create a new ' document based upon the supplied template Set m_objWord = New Word.Application Set m_objDoc = m_objWord.Documents.Add(m_strDIR & m_strTEMPLATE) ' insert the customer details InsertTextAtBookMark "ContactName", recSupp("ContactName") InsertTextAtBookMark "CompanyName", recSupp("CompanyName") InsertTextAtBookMark "Address", recSupp("Address") InsertTextAtBookMark "City", recSupp("City") InsertTextAtBookMark "State", recSupp("State") InsertTextAtBookMark "ZipCode", recSupp("ZipCode") InsertTextAtBookMark "Country", recSupp("Country") ' now the order items InsertItemsTable recItems ' print the order, not using background printing ' otherwise code continues and we try to quit whilst still printing m_objWord.PrintOut Background:=False ' now save and quit m_objDoc.SaveAs FileName:=m_strDIR & recSupp("CompanyName") & _ " - " & FormatDateTime(Date, vbLongDate) & ".DOC" m_objDoc.Close m_objWord.Quit ' clean up Set m_objDoc = Nothing Set m_objWord = Nothing End Sub Private Sub InsertTextAtBookMark(strBkmk As String, varText As Variant) ' selects the bookmark and inserts the text m_objDoc.Bookmark(strBkmk).Select m_objWord.Selection.Text = varText & "" End Sub Private Sub InsertItemsTable(recR As Recordset) Dim strTable As String Dim objTable As Word.Table ' create columns separated by tabs ' it's easier to convert this to a table than to create ' a table and worry about the table cells strTable = "Item" & vbTab & "Quantity" & vbCr recR.MoveFirst While Not recR.EOF strTable = strTable & recR("Name") & vbTab & _ recR("ReOrderPoint") & vbCr recR.MoveNext Wend ' now insert the text, convert it to a table, and format it InsertTextAtBookMark "Items", strTable Set objTable = m_objWord.Selection.ConvertToTable(Separator:=vbTab) With objTable .AutoFormat Format:=wdTableFormatClassic3, AutoFit:=True, _ ApplyShading:=False End With ' clean up Set objTable = Nothing End Sub Tag: Linking Excel files that could have a variable path name? Tag: 56848
  - 14
    - Mail Merge Disaster I need to automate a mail merge from a form in my access 2002 database. I've tried importing the code from a recommended site http://www.attcanada.net/%7ekallal.msn/msaccess/msaccess.html but keep getting an error - 424 -object required, something to do with the line ... Set WordDoc = wordApp.Documents.Add I have no coding experience but i need this to work - any help would be greatly appreciated!! Thanks Tag: Linking Excel files that could have a variable path name? Tag: 56844
  - 15
    - Any way to "size" an INCLUDEPICTURE when it's included? Hi, I'm using Mail Merge to include pictures from a directory like so: { INCLUDEPICTURE "{ MERGEFIELD thePath }" } Is there any way I can set the size of the included picture apart from by scaling it on disk when I write it in the first place? I would gain a lot of speed by not having to scale the jpegs as I write them. What I would like to do is something like this: { INCLUDEPICTURE " { MERGEFIELD thePath }" \Width=120 \Height=256 } Is anything like this possible? Thanks. Robin Tag: Linking Excel files that could have a variable path name? Tag: 56837
  - 16
    - How do I create a pathname that doesnt disappear when I email my . Hi! Trying to create a form of macro to put my pathnames of documents in the footer. Each time I get something created and email the document out the end user gets the pathname as either a code or in their temporary internet folder. Is there a way to put a pathname on a document so that it is forced to stay there when emailled (other than manually typing!!!). Hope someone can help! Tag: Linking Excel files that could have a variable path name? Tag: 56835
  - 17
    - Tab 'colors' for Multipage forms I have created several user forms with Multipage objects. I have a nice, soft 'background picture' to give texture to the multipage, but the picture does not run into the tabs. The result is a blotchy looking screen. Is there anyway to cause th tabs to look like the page without the page being a simple solid color? Thanks, Roy Tag: Linking Excel files that could have a variable path name? Tag: 56832
  - 18
    - Word 2K Just Blinks When Printing I am using Word 2K on a W98 machine and have had it installed for years. It just started this problem. When I attempt to print, the border around the Word application blinks. It never prints and I have to end-task to force it to stop. This does not occur with all documents. Any suggestions? Thanks. IC Tag: Linking Excel files that could have a variable path name? Tag: 56817
  - 19
    - How to place text blocks from another program? I'm running Word from an MS Access app, iterating through a file of people and information on them, and formatting the Word doc as I go. No problem just plugging in names, addresses, comments as long as I start at the top and work down. What I'd like to do, however, is place a block of text on the left of the page that contains the person's mailing address - and then place another block of text on the right side of the page that contains the person's telephone numbers and email addresses. The two blocks would be of varying sizes/lengths for each person and different sizes/lengths between themselves. Each block is already formatted (line feeds and all) in the input recordset. Is there a way to do this without parsing each block into separate lines, counting the lines and then tabbing across the doc? I'm not looking for a total solution - just an idea of what's possible and maybe a few keywords to start searching on. -- PeteCresswell Tag: Linking Excel files that could have a variable path name? Tag: 56815
  - 20
    - Save As UserName Hi. Thanks for your reply, however, I'm not sure exactly what you are saying. I understand that the username on your example is "administrator" but how would I get that by using code? I'm new to this VBA stuff... The normal template is saved in each staff members personal drive (P:\). The personal drives are named \\alchemy\private\(username) but I am unsure how to get that username... I appreciate your help.. Thanks >-----Original Message----- >There are some very involved ways to derive the username. >However, the easiest way is to parse it from where the >normal template is stored. The following will give you >the bona fide username, not something that was a shortcut >in Word itself (unless the normal template was re- directed >to a non-default folder). > >strPath = Application.NormalTemplate.Path > >So, on my computer, this is what it provides: > >C:\Documents and Settings\Administrator\Application >Data\Microsoft\Templates > >So, you can parse what's between documents and settings\ >and \applcation data. > >Hope this helps. > >dz > >>-----Original Message----- >>I have a template add-in which I need to save with a >>username. The template automatically counts what >templates >>users access. >> >>The code I have is: >>'<----------------------Start of Module Code------------- - >- >>-------------> >>Option Explicit >> >>Public gccTemplateUsageCounter As clsCounter >> >>Public Sub AutoExec() >>Const cCounterFileFullPath As String >>= "M:\TECHNOLOGY\TemplateUsage\CountUsage\count_usage.cnt " >> >>' Instantiate class to perform template usage counting >> Set gccTemplateUsageCounter = New clsCounter >> >>' Hook up event handler to that we can catch application >>level events >> Set gccTemplateUsageCounter.appWord = Word.Application >> >>' Log the existing counter file (if any) >> gccTemplateUsageCounter.Initialise >cCounterFileFullPath >>End Sub >> >>(There is a lot of class modules code with this as well - >>let me know if you need to view that). >> >>The Line: >>Const cCounterFileFullPath As String >>= "M:\TECHNOLOGY\TemplateUsage\CountUsage\count_usage.cnt " >>is where I need to put the username, e.g. >>\CountUsage\username_count_usage.cnt >> >>Any ideas? Do you need to see the full code? I am >>running Word 2002. Thanks in advance. >>. >> >. > . Tag: Linking Excel files that could have a variable path name? Tag: 56814
  - 21
    - Bookmarks I am running word from access - using msoffice2000, winxp I have 22 docs with bookmarks in them. I need to fill in the bookmarks from my access app. Everything works as expected on 18 of the 22 files. The other 4 files cause all kinds of problems. I have set the recordset to just access these 4 files, wondering if I was over-taxing the whole system, but even if they are the only 4 files, they cause problems. Here are the problems. If I try to do all 22 files, I get the 18 files correct, then the app stops, everything is in 'not responding' and I have to shut it all down. If I try to do just the 4 rogue files, the routine that sets the bookmarks gets the 4 files in a recordset, opens them, skips over the portion of the routine that sets the bookmarks.text and closes them back up, this time without any 'not responding' system problems. I have checked the docs, and all bookmarks are actually present. Using debug.print, I see the routine set all 18 files but then it fails on the first of these 4 files. The debug.print suggests that the app is working on the files in an ascending alpha sort, and it does the good 18, and then crashes on the first of the 4 bad files, which is located in the middle of the alpha sort. I am dumbfounded at this action, but am wondering if I perhaps have four corrupted files. I thought I would beg some information before just jumping in and recreating these files. Is there something I can do about this short of recreating the files? Thanks for your expertise. I appreciate it a great deal. Tag: Linking Excel files that could have a variable path name? Tag: 56797
  - 22
    - Ready to give up... I have created 2 Word documents. Both have radio buttons and text boxes. In one I used VBA controls and the other I used Web Controls. Both are protected. I sent both to another computer as attachments. The operator at the other computer opened both attachments but cannot click on any of the radio buttons and have it register. He is uable to enter any text in the text box. In clicking on the text boxes and radio buttons the properties dialog box opens. What is going on? How difficult is it to create a user form and actually have it work? BTW I do not know if it makes a difference but my OS is XP and the other is W98. Mike C. Tag: Linking Excel files that could have a variable path name? Tag: 56796
  - 23
    - Printing to paper trays I have posted this problem to the PAge Layout forum but I first encountered it with VBA. I am having a problem with paper trays, re the following: - in a new document type some text, put in a next page section break and type some text on page 2 (section 2) - In File, Page Setup choose Tray One for first page and Tray Two for the other pages, making sure you've got apply to Whole Document seleceted - if you then print the document, both pages come from tray 1!!. If you look in File Page, Setup again it has first page from tray 1 and other pages from tray 2 for This Section, but if you change it to Whole Document no trays are selected. If seems to print the first page of each section from tray 1 and the rest of the pages from each each section from tray 2. As each section only has 1 page they all print from tray 1. Is this true and how do I get around it? This VBA code seems to do the same thing as manually changing the trays in Word: ActiveDocument.PageSetup.FirstPageTray =somecode working out tray ActiveDocument.PageSetup.OtherPagesTray = somecode working out tray Tag: Linking Excel files that could have a variable path name? Tag: 56794
  - 24
    - Help debugging code Using Word 2002 and 2003. Have a routine that loops through an array, builds up a string and then puts the string in the document. Occasionally this doesn't work properly and only part of the array appears in the document. The problem is that I can't just see any reason why this would be happening. I have dumped the array to a textfile to have a look at it, but it all looks normal or in any case no different from other arrays that appear in the document fine. The array is an 0-based 2D array with 4 or 5 columns and up to about 100 rows. It contains dates, numbers and strings. As I have no idea still what the problem is here I just post the full Sub in the hope that somebody has some suggestion as to where the problem could be. Leaving out the Exit Sub bits doesn't make a difference. Any assistance greatly appreciated. Sub ArrayToWordText(ByRef arr As Variant, _ ByVal lStartCol As Long, _ ByVal lEndCol As Long) 'converts a 2-dimensional array to a Word as plain text 'note that the start and end column are always 1-based 'even when the arrray is 0-based '----------------------------------------------------- Dim rng As Range Dim tbl As Table Dim LB1 As Byte Dim LB2 As Byte Dim UB1 As Long Dim UB2 As Long Dim lRows As Long Dim lCols As Long Dim i As Long Dim c As Long Dim LB1corr As Byte Dim LB2corr As Byte Dim colCorr As Integer Dim strTemp As String LB1 = LBound(arr) UB1 = UBound(arr) LB2 = LBound(arr, 2) UB2 = UBound(arr, 2) LB1corr = 1 - LB1 '0-based array >> LB2corr will be 1 '1-based array >> LB2corr will be 0 LB2corr = 1 - LB2 colCorr = lStartCol - (LB2corr + 1) lRows = (UB1 - LB1) + 1 lCols = (lEndCol - lStartCol) + 1 Application.ScreenUpdating = False Set rng = Selection.Range rng.Collapse Direction:=wdCollapseEnd On Error GoTo ERRORADDINGTABLE 'for debugging '------------- If bArray2Text = True Then SaveArrayToText2 "C:\NotesDump.txt", arr End If For i = 1 To lRows If BPArray(i - LB1corr) = 1 Then 'dealing with BP entry '--------------------- For c = 1 To lCols If strNoteSubject <> "Q" Then If arr(1 - LB1corr, 1 + colCorr) = Empty Then Exit For End If End If Select Case c Case 1 strTemp = strTemp & arr(i - LB1corr, c + colCorr) Case lCols If lCols = 4 Then If Not arr(i - LB1corr, c + colCorr) = Empty Then strTemp = strTemp & "/" & arr(i - LB1corr, c + colCorr) & Chr(13) End If Else If arr(i - LB1corr, c + colCorr) = Empty Then strTemp = strTemp & Chr(13) Else strTemp = strTemp & ", " & _ arr(i - LB1corr, c + colCorr) & Chr(13) End If End If Case Else If c = 4 Then If Not arr(i - LB1corr, c + colCorr) = Empty Then strTemp = strTemp & "/" & arr(i - LB1corr, c + colCorr) End If Else If Not arr(i - LB1corr, c + colCorr) = Empty Then strTemp = strTemp & ", " & arr(i - LB1corr, c + colCorr) End If End If End Select Next Else 'not dealing with BP entry '------------------------- For c = 1 To lCols If strNoteSubject <> "Q" Then If arr(1 - LB1corr, 1 + colCorr) = Empty Then Exit For End If End If Select Case c Case 1 strTemp = strTemp & arr(i - LB1corr, c + colCorr) Case lCols If TestArray(i - 1) = 1 And c + colCorr = 3 Then 'dealing with test value and unit, so no comma '--------------------------------------------- strTemp = strTemp & " " & _ arr(i - LB1corr, c + colCorr) & Chr(13) Else If arr(i - LB1corr, c + colCorr) = Empty Or _ arr(i - LB1corr, c + colCorr) = Chr(32) Or _ arr(i - LB1corr, c + colCorr) = vbNull Or _ Trim(arr(i - LB1corr, c + colCorr)) = "" Then strTemp = strTemp & Chr(13) Else strTemp = strTemp & ", " & _ arr(i - LB1corr, c + colCorr) & Chr(13) End If End If Case Else If TestArray(i - 1) = 1 And c + colCorr = 3 Then 'dealing with test value and unit, so no comma '--------------------------------------------- strTemp = strTemp & " " & arr(i - LB1corr, c + colCorr) Else If Not arr(i - LB1corr, c + colCorr) = Empty And _ Not arr(i - LB1corr, c + colCorr) = Chr(32) And _ Not arr(i - LB1corr, c + colCorr) = vbNull And _ Not Trim(arr(i - LB1corr, c + colCorr)) = "" Then strTemp = strTemp & ", " & arr(i - LB1corr, c + colCorr) End If End If End Select Next End If Next 'not sure why this is still needed, should have been filtered out above '---------------------------------------------------------------------- strTemp = Replace(strTemp, ", " & Chr(13), Chr(13), 1, -1, vbTextCompare) strTemp = Replace(strTemp, " <-| ", Chr(13) & Chr(9), 1, -1, vbTextCompare) strTemp = Replace(strTemp, " <-|", "", 1, -1, vbTextCompare) 'to indent after linebreak '------------------------- With Selection.ParagraphFormat .LeftIndent = CentimetersToPoints(2.1) .FirstLineIndent = CentimetersToPoints(-2.1) End With With Selection .TypeText Text:=strTemp .MoveDown Unit:=wdLine, count:=2 End With 'back to normal linebreak '------------------------ With Selection.ParagraphFormat .LeftIndent = CentimetersToPoints(0) .FirstLineIndent = CentimetersToPoints(0) End With Application.ScreenUpdating = True Exit Sub ERRORADDINGTABLE: Application.ScreenUpdating = True MsgBox "COULDN'T PUT THE ARRAY HERE!", vbInformation, "" On Error GoTo 0 End Sub RBS Tag: Linking Excel files that could have a variable path name? Tag: 56793
  - 25
    - picture question I have a picture in a Word document. Is there a way to save only the picture as a TIF file? Thanks Tag: Linking Excel files that could have a variable path name? Tag: 56792
- Next
  - 1
    - How to find the new document created by a mail-merge? Hi, I am splitting my document into several new documents (by section) and then performing a mail merge with each section (usually with different data sets). How do I find the document object that was created as a result of the mail merge? I can't find it in the original documents merge object anywhere. I can't assume it is the last document in the application documents collection, as the user may be doing other things with another word document while the merge is proceeding. Any hints about this? Thanks robin Tag: Linking Excel files that could have a variable path name? Tag: 56789
  - 2
    - How to create the range between two field codes? Consider the following field codes: «SECTION_START» .... Some text .... Maybe an image .... «SECTION_END» How is it possible for me to create a range starting from the end of the section_start mergefield and end at the section_end merge field start? At present, I'm writing the following: Dim theRange As Word.Range theRange.Start = theFirstField.Result.End + 1 theRange.End = theSecondField.Result.Start - 1 However, it always seems that the range contains the second field code. All I want is the stuff inbetween, NOT including the field codes. Thanks for any tips you can give me on this, Robin Tag: Linking Excel files that could have a variable path name? Tag: 56783
  - 3
    - macro to add line I am trying to design a macro that will create a new row in a table. Is this possible? I actually want it to create a row, and then have form fields in the row? Is either one possible? p.s. THIS IS A WORD PROGRAMMING QUESTION, CORRECT????? Tag: Linking Excel files that could have a variable path name? Tag: 56770
  - 4
    - Get text strings from closed docs? I have a folder with over 14,000 Word docs. I would like to extract a few text strings from each doc to build a table in a "master list" doc (for instance: for each doc, find "Title" and get the following 24 characters; find "Date" and get the following 8 characters, etc). Can this be done without opening and closing each doc? Ed Tag: Linking Excel files that could have a variable path name? Tag: 56767
  - 5
    - How do I remove a section break from a document? Hi, I'm trying to split my document up into new documents, one for each section in the original master document. To do this, I am more or less executing the following code: ' Create a new document. Dim theNewDocument As Word.Document = m_WordApplication.Documents.Add(Visible:=True) ' Add the new document to the list of documents we should keep track of. m_Sections.Add(theNewDocument) ' Get the current section. theSection = m_LoadedDocument.Sections.Item(Index + 1) ' Now copy the section into the new document. theRange = theSection.Range.FormattedText ' Copy across. theNewDocument.Range.FormattedText = theRange This is all well and good. Consider a master document with 2 sections. In this case, the second (last) section is cut and copied correctly into the new document, however, the first section when copied into the new document still contains the section break at the end of it. So I am having to write: ' Got more than one section? If theNewDocument.Sections.Count > 1 Then ' Somehow remove all section breaks from the document End If Any ideas on how to remove this section break? Thanks, Robin Tag: Linking Excel files that could have a variable path name? Tag: 56765
  - 6
    - macro/form to prompt user for input (in WORD) Simple request: Want to create macro/form to prompt user to imput a "word". This word will then be placed on a formated page that allows fifteen different words/phrases arranged in three columns, five rows. These can be printed out to create flash cards for language study. By having an input box, it eliminates all of the tabbing & entering to put these words in the correct place on the page. KNOW it's possible & simple. Can't remember enough about creating a macro to do it and the macro directions in Word just don't apply at all. Thanks! Tag: Linking Excel files that could have a variable path name? Tag: 56763
  - 7
    - Remembering Values Hi I have created a user form for memos and faxes. I would like to be able to remember the last 4 recipient details entered. Initially I thought of creating 4 documents, each with a name and job title bookmark, when i click button number 1 on my user form it would look in document1 read the bookmark values and pop them into the text boxes in the user form. If the user overtypes the text in the text boxes it rewrites the text in the bookmarks in the relevant document. I can't seem to find any mention of how to read bookmark values - do I need to use something else?? would autotext or a table or even excel be any easier for storing data. I would really appreciate some advice. Thank you very much for your time. Kerry. Tag: Linking Excel files that could have a variable path name? Tag: 56762
  - 8
    - Need Help in VBA --Word Basic.. -- Desperate Hi All, I have an application, which is written using WORD BASIC> I want to edit the footer and want to user EDITREPLACE function to replace the string inside the footer also. Could any one let me know the command how to edit footer in WORD BASIC. Please let me know if anyone has any idea. I am desperate for solution. I have tried many ways but it does not do it. Thanks Kiran Tag: Linking Excel files that could have a variable path name? Tag: 56753
  - 9
    - MS Word objects list Word allows us to access to it's objects like tables (ole_object.application.activedocument.tables), paragraphs, sentences and other. But is there an object that keeps all the Word objects ((or) references to them) as they appear in the document. For example: Having the collection of tables (ole_object.application.activedocument.tables) I don't know where exactly that tables are in the document. If the Range or Selection object selects the whole table, how to get to know that it is the table? What is more interesting: How to get to know (when the cursor is in the beginning of the document) what kind of object will be the next: table, sentence or sth else? How can I read my document from top to toe? Thanks in advance... Tag: Linking Excel files that could have a variable path name? Tag: 56737
  - 10
    - Code for WordXP and Word2003 Hi everyone, we have an app written in C# to automate WordXP, pretty complex. On one of the machines, someone has been trying to make the app work against Word2003, but it doesn´t work. I haven´t had access to the error yet, so I don´t know exactly what the message says, but muy questions are... 1. Are there significant differences between WordXP and Word2003? 2. Is the oject model different substantially, or the functions called differently? 3. Is there a web site where this (possible) differences are documented? Thanks, from Spain Tag: Linking Excel files that could have a variable path name? Tag: 56736
  - 11
    - Closing MSWord Read-Only file I have created a merge template ("Document.dot") that contains a macro to perform the merge and other subsequent actions. The last macro step is to close the original merge document without changes: ' Close the original merge form Documents("Document.dot").Close SaveChanges:=wdDoNotSaveChanges This works fine. Now I want to make the template Read-Only to protect it from inadvertent user changes. When I do that, I get an error message saying the document doesn't exist. I've tried including "(Read-Only)" in the document name, which is how the document name appears in Word, but that doesn't work. Is there a way to do this using the simple code above? If not, what do I need to do? Tag: Linking Excel files that could have a variable path name? Tag: 56735
  - 12
    - horizontal ruler How do I make the horizontal ruler fit the window Tag: Linking Excel files that could have a variable path name? Tag: 56734
  - 13
    - opening email attachments from yahoo I can't open attachments in my mic word/ofc 2000. when i scan and dwnld doc/attchmnts i receive this error msg: This file could not be found. Try one or more of the following: *check the spelling of the name of the document. *try a different file name. I can access my yahoo on a different computer and open my messages just fine. Has anyone else experienced this and come up w/a solution? Tag: Linking Excel files that could have a variable path name? Tag: 56733
  - 14
    - Replace Stirng of Length > 256 Hi , I need to replace some text in a word document with a string of length greater than 256.It cannot be done with Find.Execute methods ... coz it truncates the replacing string upto 256 characters. so how can i do it ? Thanx ,Regards Tag: Linking Excel files that could have a variable path name? Tag: 56732
  - 15
    - Page numbering what i want to do is more than just inserting the number of pages in a document. I want to use the format "Page 1 of XX" where XX is the number of pages in the document MINUS the title page(s). Is there a way of doing this automatically? Tag: Linking Excel files that could have a variable path name? Tag: 56730
  - 16
    - Page numbering what i want to do is more than just inserting the number of pages in a document. I want to use the format "Page 1 of XX" where XX is the number of pages in the document MINUS the title page(s). Is there a way of doing this automatically? Tag: Linking Excel files that could have a variable path name? Tag: 56729
  - 17
    - How to restrict certain fields on a form? I am being asked to create a form that encompasses several different forms. The forms are for different types of contracts. Most of the fields are the same for all of the forms, but there are some fields that are not needed depending on the type of contract. I am being asked to create one form for all of the contracts and depending on what type of contract is selected from a drop down menu, fields that are not pertinent to that type of contract will then be 'grayed out' or unavailable. I know that this will involve some programming, but i don't know where to start. PLEASE HELP. Tag: Linking Excel files that could have a variable path name? Tag: 56728
  - 18
    - e mail template how do I create an e mail template? Tag: Linking Excel files that could have a variable path name? Tag: 56727
  - 19
    - Function to give text in extense, of a number WORD 2002 Is there any function to give us back the result of a convertion of a number to a extense text? Example: We have EUR 1.000,50. Is there any possibility to write after the number (A Thousand euros and fiffty cents) automatically in Portuguese, on Word 2002? Tag: Linking Excel files that could have a variable path name? Tag: 56725
  - 20
    - Word should include a dictionary in it It would be nice if word includes a dictionary option too along with spell check and thesauraus. The user if wants to look up a word's meaning can simply click on the dictionary option and gets the meaning Tag: Linking Excel files that could have a variable path name? Tag: 56724
  - 21
    - Word should include a dictionary in it It would be nice if word includes a dictionary option too along with spell check and thesauraus. The user if wants to look up a word's meaning can simply click on the dictionary option and gets the meaning Tag: Linking Excel files that could have a variable path name? Tag: 56723
  - 22
    - Repeating a Macro I've got a macro that does this; Look for a text object Mark the Line it's on and then delete the line. I'd like this to repeat to the end of the file. Any suggestions? TIA Robert Tag: Linking Excel files that could have a variable path name? Tag: 56722
  - 23
    - How do I avoid blank pages in setting up a leaflet? I'm trying to set up a leaflet in Word - 4 page A5 (A4 Landscape with 2 pages per sheet). In doing so I can't make the pages run on from each other - there are always blanks in between the print, although print preview tells me I'll get what I want. The result is a three sheet document rather than a leaflet over 2 sheets. What am I doing wrong? Tag: Linking Excel files that could have a variable path name? Tag: 56721
  - 24
    - macro security warning using print button in one template I am getting the macro security warning when using the print button on the standard toolbar in one of my templates. This template does not have any other toolbar customizations and the macro security is set to low in the template. Tag: Linking Excel files that could have a variable path name? Tag: 56719
  - 25
    - Capitalization I think that WORD should have an option to highlight already typed phrases and capitalize them as you can italize/highlight/underline. As a student, this would be a helpfu in studying my notes. Tag: Linking Excel files that could have a variable path name? Tag: 56718

I am working on a large document with multiple linked spreadsheets. This
document and spreadsheet will always have the same file names but will be
located in different directories depending on the user. I thought I could do
an ASK field then a REF field but it does not recognized the REF field inside
the quotes of the LINK field. I do know that all the files will be in the
same directory so if I could tell it just to look where the Word document is
for all the spreadsheets it would work. Does anybody have any other ideas or
help me figure out to get the REF field inside a LINK field to work?

Top

Re: Linking Excel files that could have a variable path name? by Word

Word
Thu Sep 30 03:29:17 CDT 2004

G'day "Brown4girls" <Brown4girls@discussions.microsoft.com>,

You will need a little VBA UserForm to browse, select and insert.

Steve Hudson - Word Heretic
Want a hyperlinked index? S/W R&D? See WordHeretic.com

steve from wordheretic.com (Email replies require payment)

Brown4girls reckoned:

>I am working on a large document with multiple linked spreadsheets. This
>document and spreadsheet will always have the same file names but will be
>located in different directories depending on the user. I thought I could do
>an ASK field then a REF field but it does not recognized the REF field inside
>the quotes of the LINK field. I do know that all the files will be in the
>same directory so if I could tell it just to look where the Word document is
>for all the spreadsheets it would work. Does anybody have any other ideas or
>help me figure out to get the REF field inside a LINK field to work?

Top