Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: MyFlight
  • Content: Threads
  • Order by date
  1. MyFlight

    DIsplaying Help with Functions

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

    Running WZZIP from ProComm

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

    Runing a WZZIP.exe from Excel VBA?

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

    Capture Files not Writing

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

    Selecting ProComm Directories from a Dropdown box

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

    Finding Entry In Directory with Script File

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

    Insert Blank Row

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

    Excel Macro Cell Formatting question

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

    Seperating Data and inserting cells

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

    Batch files in XP

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

    Avaya Scripts For Changing Stations

    Does anyone have any sample scripts for changing Stations in an Avaya? I have written a script change/add Coverage Remote Entries. (Thanks to knob & comtechau) However I still need to changes the Coverage Path and change the Station. Here is the Script I wrote to add coverage paths 1 to 1000...
  12. MyFlight

    StrTok Value is not being Transmed

    Help I wrote this script to update about 900 Coverage Remote Numbers in an AVAYA. The numbers are not being sent. proc main integer iVar, iLen ; Number of entries in dialing class string sLine, sTok1, sTok2, sTok3, sTok4,sRemote string sAvayaFile = "Avaya...
  13. MyFlight

    Macro does Not Delete Rows???

    My Macro does not DELETE the ROWS from the specified Worksheet whene SAVESTR is NOT Found. If SAVESTR is found it deletes the other ROWS. However I need to be left with a blank sheet if SAVESTR is not found in the specifed column. Sub DupDigitalSheets() ' ' DupDigitalSheets Macro ' Macro...
  14. MyFlight

    Avaya Scripts

    Does anyone have any Acpect scripts for changing Coverage Paths, Coverage Path Reports and Stations. I have been researching and writing my own scripts. However I am having trouble with error checking. Since I Dial-into these ssystems there is the chance of garbage on the line, hence the need...
  15. MyFlight

    Repeating Code for Multiple worksheet

    Is there a simple way to run code on Multiple worksheets? I have a workbook with 12 worksheets in it. One worksheet named Sheet1, the rest are Named: "Hardware", "Hardware (2)", "Hardware (3)", etc.. I need to run the following on each of the HARDWARE tabs: Range("N1").FormulaR1C1 =...
  16. MyFlight

    Changing Const Variables

    I am using this attached Macro to delete unwanted rwos from my worksheet leaving me with jst the iformation pertaing to what is in the SAVESTR. I run this Macro on multiple Worksheets and the SAVESTR neeeds to change for each one. I need to be able to change SAVESTR depending on the value in...
  17. MyFlight

    Deleting blank (Cells/Rows) in Excel-VBA

    Help I have a macro that runs multiple formulas. However, when the formulas are finished I am left with about 64000 blank lines. I am unable to insert a row on the worksheets as I get a Run-Time Error 1004 (Try to locate the last Nonblank Cell using CTRL-END). Here is a same of some of...
  18. MyFlight

    MS-WORD VBA Question

    Does anyone know of a Simple way to run a FIND-REPLACE under an IF-THEN statement? Example: Selection.Find.ClearFormatting With Selection.Find .Text = _ "UNIT 1A IS NOT SET UP" .Replacement.Text = "" .Forward = True .Wrap = wdFindContinue...
  19. MyFlight

    MS-Word Passing Variables in VBA

    I am trying to pass a Variable between Macros (Main and Analog) in MS-Word. The user enters a Number (Cmr) in the message box. This is used to open multiple Files that start with this number. The Complete filename are: 123456_Analog65.txt and 123456_Digtial65.txt etc... This is only a...
  20. MyFlight

    Auto-Changing file name in Script file on Run

    Hello I have a script fiel that runs and collects data from a switch. the data is parsed into various Text files. My questions is how can I cange the name of the file every time I run the script. Example: string SwitchID = "Site Id.txt" string ListATC = "ATC.txt" string ListATC_G =...

Part and Inventory Search

Back
Top