Recent content by cll

You're right! I must give the database solution a closer look. Thanks a lot for your input! Regards Claus

OK, maybe I'm not very good to explain the matter. What I have made is, that when the workbook is opened, the user is asked (in a userform) for username and password. When User1 enter Password1 the workbook opens in one way. When User2 enter Password2 the workbook opens anotherway. When User3...

Hey!! Thanks for replying. The first I've got (have asked in several forums). The link desribes the "normal" way of protecting cells, sheets and workbook. What I want is a more dedicated "passwording" (which I have made as described), with possibility for the users to change password (which I...

Hi all I have a workbook (Excel2002) with an "entrance userform" where users fill in name (pre-defined) and password (pre-defined). The code opens then the workbook accordingly (some sheets hidden, some protected and so on) Can anyone show me how the user can manage their own password, or give...

Thanks to the hints, 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) &...

Thanks, You might be right! (- already tried EngTips). Have found another promising link www.mvps.org/word. Regards cll

This question was announced mid october but noone replied, maybe because a wrong subject? Cant anyone help me ?? 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...

Try this one: http://www.tenlinks.com/CAD/users/autocad/vba.htm I can also recommend participating www.augi.com, where you find a forum dedicated to AutoCad. Good luck Claus

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

Hey mark47, no, this was just an example. At the moment my list starts with 0S (but it could be 0A or anyother). As a workaround I have implemented the code: ExcelServer.SendKeys "%ki{enter}" DoEvents before sorting to make excel sort correct from my list. Another problem I...

Thanks vlhijlke! Actually I made it by combining some vba-samples and specialize them to my needs. I can update four named old titleblocks to our newest. I've worked a little with vba, but never got into lisp, thats why I prefer vba. Regards Claus

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

Correction to above: Selection.Sort Key1:=Range("A8"), Order1:=xlAscending, _ Header:=xlNo

Hi jproj, i've tried to copy the code from Excel to VBA and vise versa, but no result. Here's the Excel makro (works): Range("A8:F250").Select Selection.Sort Key1:=Range("A24"), Order1:=xlAscending, _ Header:=xlNo, OrderCustom:=6, MatchCase:=False, _...

Hi jproj Thanks anyway. I am aware of the standard sort method in Excel. But Excel has a cuctom sort method too, where it is possible to specify a sorting list. My problem is, that even when I can do the sorting correct in Excel (1Z1, 1Z2, 1Z11, 1Z12) this dosn't work from VBA ! Best regards cll