Search results for query: *

I found the Function: under Object Browser and Module 2 and WhatInteriorColorIndex. After I add the Text and save the Workbook (Personal.xls) The text never appears. Am I forgetting something do I need to change the Help Context ID or something? Your assistance will be greatly appreciated.

Is there a way to Display Help when uing the Insert Function (Shift + F3) for Functions I have Created? Example Function WhatFontColorIndex(rng As Range) ' Select the Cell with the FONT Color you want Translated WhatFontColorIndex = rng.Font.ColorIndex End Function How would I display...

...a 7 digit number followed by an Underscore and then the text file name. I need to zip any file in "C:\Temp Data Files\Raw Data\" with 1234567_*.txt into a zip file named 1234567.zip. The Seven Digit number changes with each Account Here is what I have have so far however it is not...

...problems). All files begin with a 7 digit number followed by an Underscore and then the text file name. I need to zip any file in C:\temp files\ with 1234567_*.txt into a zip file named 1234567.zip. If anyone has any suggestions or could point me in the right direction I would appreciate it.

Here is a Simplified Version with the same problem, proc main string DirPathID = "C:\Program Files\Symantec\Procomm Plus\*.DIR" string sDirName = "TempDir.txt" string fName = $DDIRFNAME string AcctNum = "" ; User Input Company (CMR) Number string Directory ...

I have a script I have written for accessing and running/downloading data in our switches. The porblem is I am calling it from another script and the capture function no longer seems to work. The way it is supposed to work is that the Data is written to certian file in the C:\Temp Data\Raw...

...appricate the help. #define SaveDir "C:\Program Files\Symantec\Procomm Plus\Aspect\" string DirPathID = "C:\Program Files\Symantec\Procomm Plus\*.DIR" string AcctNum = "" ; User Input Company (CMR) Number string sComma = "," string fName = $DDIRFNAME string sDirName =...

KNOB, Ok disregard my last post. Figured that part out. However,how do I get all 3 Group Names to appear in the list box? Here is my complete script to this point. I am currently working on case 103 proc main string s_line = "", s_Bucket = "", s_CbxType = "", sSmrVer = "" string...

Knob, I know I am doing something wrong here but all this seems to do is count the Entries, NOT the Groups. proc main integer NumGrps ; Used to count Number of Groups. integer NumEnt ; Used to count Number of Entries. integer Count ...

Knob, Most of my Directories have multiple Folders in them. How ould they select the Specific folder they want. Thanks

I am trying to write a script to Ask the user to: 1. Select a ProComm Directory from a Dropdown box 2. Select a Folder from within the Directory (i.e. Switches, VoiceMails). 3. Set off a subscript to dail all Entries (when connected execute the Export.wax script). Needless to say I could...

I am trying to write a script file to Select an entry from a ProCom Directory. However I need to match on the Company Name. Since this is a Multiphase script I need to keep the Company in memory (Global Variable). Once the I use DialLoad to load the directoy I cannot match on the Company, I...

Help I need a Macro that will insert a blank row in a worksheet. I receive a worksheet every week with a list of numbers between 100 and 1000 (and ohter data). I need to insert a blank row after each number in the spreadsheet (the numbers are not sequencial). thanks

Skip, Does Slecting the Cells slow the Macro down?

...As String = "0" Dim myRange As Range Dim cell As Range Dim delRange As Range Range("L10").FormulaR1C1 = "=SUM(COUNTIF(Status!C[-9],""SLMB*""),COUNTIF(Status!C[-9],""SLMD*""),COUNTIF(Status!C[-9],""SLMQ*""),COUNTIF(Status!C[-9],""WAML*""))" Range("L10").Select On Error Resume Next...

Skip, The Macro recorder only work to change the formatting on Cell L10. I need to change the Formatting on Cell L8 if Cell L10 is greater then Zero. I tried the following, however it chages the formatting no matter what value is in cell L10. Any Ideas? Sub Macro3() ' ' Macro3 Macro '...

...Greater than 0 the format Cell L8 (Red Cell, White Letters) Range("L8").Select Range("L10").FormulaR1C1 = "=SUM(COUNTIF(Status!C[-9],""SLMB*""),COUNTIF(Status!C[-9],""SLMD*""),COUNTIF(Status!C[-9],""SLMQ*""),COUNTIF(Status!C[-9],""WAML*""))" Basically if L10 is Greater than 0 the...

Skip, The problem is that I need it to list all the numbers between the "&&". EXAMPLE 1111&&1114,,,STN,N,,,,,; should provide 0 STN N 1111 STN N 1112 STN N 1113 STN N 1114 STN N 1130 TIE N the query you forwarded does...

I have a text file (Switch Dial-Plan) that prior to import looks like below: 0,,,STN,N,,,,,; 1111&&1114,,,STN,N,,,,,; 1130,,,TIE,N,,,,,; 1131,,,TIE,N,,,,,; 1132,,,STN,N,,,,,; 1135&&1186,,,STN,N,,,,,; 120000,,,STN,N,,,,,; 120055&&120056,,,STN,N,,,,,; 134501&&136998,,,STN,N...

I am trying to write a bath file for use in Windows XP. Here is what I have now: CD\ CD.. cd Temp Data Files cd Raw Data del lexall del lexall.out rename lexall.txt lexall. 9005LEX.EXE I need to change the lexall.txt file name to include a user variable: 1234567_lexall.txt The Number...