Search results for query: *

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

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

Hi Adrian, Thanks a lot for your answer. I've just tried the ddmodify - it brings up the properties dialog box, where, as I described I can modify a lot, except what I pointed out (systemdate). I will try redefine the order at a later moment. I will consider the other good ideas. Thanks again...

Hi all, I have found out (correct me if i am wrong) that the titleblock consist of stand-alone attributes. To edit them I can use DDedit (for Tag, Promt and value) and Properties to edit a number of properties. Now: The date is inserted automaticly as systemdate, but is not among the above...

From Tek-tips I got this answer: "Have you tried the Protect Method? From VBA Help: Protect Method Protects the specified document from changes. When a document is protected, the user can make only limited changes, such as adding annotations, making revisions, or...

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