Adding help to Excel user defined function | Tek-Tips
Aug 26, 2006 · I am wondering if I can add helpful tips to my user defined functions in excel. Currently the "Insert Function" dialog says "No help available." I would like to change all that. I …
Default Field Text Value to Proper (Sentence Case) | Tek-Tips
Oct 18, 2002 · Some are using all caps, some don't capitalize at all, and others do. Problem is, when reports/labels, etc are printed out, this is an issue. I would like to force the value of these …
Forcing Caps Lock On | Tek-Tips
Apr 16, 2001 · Is there any way to use code to turn caps lock on if it is not already on? I am trying to keep consistency in the data entered in the database. I need it to be entered in all caps and …
Opening an Excell file in VFP6.0 | Tek-Tips
Feb 8, 2001 · Well, when you open your Excel file NOT from VFP just the normal way, do you need to do anything to get your table updated?? If yes, before you do that, start recording a …
Get vbscript to extract last pwdLastReset from AD | Tek-Tips
May 13, 2011 · I have a pretty good script I downloaded that extracts a lot of good info about users from Active Directory and puts it into and Excel file, however I am having trouble getting …
Tek-Tips is the largest IT community on the Internet today!
Feb 7, 2003 · Please excuse my newbie naivite, but I'm struggling here! I need to write some VBA code in a client Excel file to search a folder ("server") for filenames matching my criteria (e.g …
Lines not printing correctly | Tek-Tips
Nov 8, 2005 · I have a document with High resolution tiff's that have straight lines, which print out as dots. Also a line created in InDesign does the same thing. I have all of the settings set to …
Excel sheet for key caps - Nortel: Norstar systems | Tek-Tips
May 28, 2003 · Set your Excel row heights to 17.5 and your column width to 10.14. you may have to experiment a bit, depending on what printer you are using. Also, if you are making any …
Excel keeps selecting cells it is like left mousebtn is stuck
Jun 13, 2000 · Open excel Press F8 try it again As an aexplanation, there are some options that excel displays as part of the bar on the bottom of the application. These are shown to the right …
Word table, counting occupied cells | Tek-Tips
Mar 1, 2011 · Hi telephoto, I assume that the Word table is long, but static - unlike Excel spreadsheets, where cell contents may change. Then why not select column C, replace X by 1 …