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...
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...
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
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...
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...
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...
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...
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...
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...
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 =...
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...
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...
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...
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...
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 =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.