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

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

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

Does anyone know if there is an easy way in Excel to write a Macro to do the following. I have 2 Formulas in Cells L10 and M10. If the value is over Zero I wnat to change the Cell Color and formatting of another Cell and then delete the Formulas. Basically if L10 is Greater than 0 the format...

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