Search results for query: *

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...

Add this: I've found that if I do a manual sorting my macro will function thereafter. Or if I do a manual recalculation or even if I just go into the properties dialog in Excel and select OK - then my sortingmacro will work. For me it's a bit strange, but could give someone a clue. Regards Claus

Thanks Andrew, I am aware that the normal sort-method will not do - thats why I made my own precribed sort-list. Your workaround will do, but to my use not satisfying. Still I don't understand why Excel will, but VBA will not. Regards Claus

Hi all, in a VBA code I am sorting data: objWorksheet.Range("A8:F250").Sort _ Key1:=objWorksheet.Range("A8"), _ Order1:=xlAscending, _ Header:=xlNo, _ OrderCustom:=6, _ MatchCase:=False, _ Orientation:=xlTopToBottom The CustomOrder:=6 prescribe sort-order to be: 1Z1 1Z2...

Help ! Problem: I want to replace a block (OldTitleblock) that have attribute (OldTagValue), with another (NewTitleblock) and transfer the attribute to NewTagValue. The OldTitleblock have Tag which value shall be transfered to another Tag in the NewTitleblock. I think it should be easy done...

Hi Leslie, in combination with the UnProtect method it works out fine. Thanks for the lead. Hope Softwareguy can use it too. :-D regards