Recent content by MyFlight

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

I am trying to figure out how to run WZZIP.exe (the command line interface for WinZip. I have an Aspect Script that downloads Many files and need to zip them together. . 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...

I am trying to figure out how to run WZZIP.exe (the command line interface for WinZip from VBA. I have multiple VBA Modules and macros that run and I need to zip all of the files prior to running these macros (in case of problems). All files begin with a 7 digit number followed by an...

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

KNOB, Got it to work. Here is the script I have to open a Directory and display all the folders. Thought it may be helpful for someone else. I really appricate the help. #define SaveDir "C:\Program Files\Symantec\Procomm Plus\Aspect\" string DirPathID = "C:\Program...

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?

Skip, here is what I came up with. Does this look right to you? Sub MainHubDigitalFormat() ' ' MainHubDigitalFormat Macro ' Macro Created On 6/12/2008 by Ralph M. Hill ' ' Const SAVESTR As String = "0" Dim myRange As Range Dim cell As Range Dim delRange As Range...