Recent content by cllpmc

It certainly does, Thanks again, Loomah Regards claus

Thanks both, How about going to the previous row ? (I've made some attempts without luck) Regards Claus

Hi Skip, Im not sure i can se through that code, but it works. (what type of Dim is c?) GREAT, Thanks a lot. Claus

Hi all, in an excel sheet I have made the following: A dblclick event shows a userform. The userform picks up values from cells in the same row where the activecell is (where the dblclick is made). Now I want to have a commandbutton in the userform that clears the userform and pick up value from...

Hi I'm having exactely the same wish. So if you are having any success please share your experiences. Claus

I have figured this solution out: Private Sub tabcon1() Selection.HomeKey Unit:=wdStory Selection.Fields.Add Range:=Selection.Range, Type:=wdFieldTOCEntry, Text:= _ Chr(34) & "text1" & Chr(9) & "text2" & Chr(9) & "text3" & Chr(9) & "text4" & _...

Hi all I have a weird problem with TOC The following (simplified) code put a TC field and make a TOC from that: Private Sub TabCon() Selection.HomeKey unit:=wdStory ActiveDocument.TablesOfContents.MarkEntry Range:=Selection.Range, _ Entry:="text1" & Chr(9) & "text2" &...

Thanks John, but it's not working for me - dragging the checkbox size (changing the properties height and width) does not affect the square. Could there be some settings I'm missing (I'm in Word97)? Regards Claus

Hi all: How do I change the size of a checkbox, and by that I mean the size of the (little) square box, where you do the checking. If I change the fontsize it´s a bit odd that the checkbox remains the same (little) size. Hope for an answer Regards Claus

Exactely - but thanks anyway for your great help!! Claus

If Application.DisplayAlerts=True (as it is by default without setting it) it is possible to choose No in the alert box and this will cause no saving (tested). When closing the workbook I get another chance (alert box) where I can choose No, causing no saving (tested). It does'nt seems odd to me...

It was a good try, BUT as the default for the warning is not to save, I won't get my file saved - and thats no good! (The full text of the warning: "(i) Microsoft Excel This file is created in a newer version of Microsoft Excel. If you save the file from Microsoft Excel 97, you risk to...

Hi Rob, Great, this works for me too, and I notised that no reference to Word 8.0 Library is needed. I've unchecked that Library in my code and it seems to work out fine. I must make some further testing tomorrow. A problem is still there: Even though I save my Excel workbook in FileFormat...

Thanks Rob, but it does'nt matter if I specify version number or not! The code is rather simple, using .Documents.Add, .Selection.GoTo, .Selection.InsertAfter, .ActiveDocument.Printout and .ActiveDocument.Close. Could you give an examplecode that from Excel opens a Word doc, print it and close...

Hi all, I need some help. Problem: I have written a code in a Excel97 worksheet, which calls Word97. This have been working for half a year on daily use. Now some users have new versions installed: Excel 2002 and Word 2002. When used from Excel 2002 (works out fine) and properly saved (part of...