Search results for query: *

I can't understand why this doesn't work and I was hoping someone can help me. I want to exclude certain lines from a text file based on conditions. This is giving me a result when I print out the msgbox but the file I'm writing to is coming up empty. Basically I want to keep everything where...

I was hoping someone might be able to help with a formula I'm attempting. We classify different time segments throughout the day as prime hours and I need to total those hours. The biggest problem is that the prime hours for Saturday are different than the prime hours of Monday through Friday. I...

I don't have a good understanding of file manipulation using aspect and I was hoping someone could help. I'm determining the length of each line in a text file. If the length is longer than 12 characters, I want to insert several spaces at the start of the line. I basically want to push the data...

I stoled some of this from other scripts on this site. This starts off giving me the first and last day of the month for the previous month. I was wondering if anyone knows how I loop this so it would decrement the month each time through. January -08 December - 07 November - 07 etc... proc...

I'm attempting to login to another computer remotely. Everything is working up to the Windows Login which is titled "Log On To Windows". The Windows Login Window is inside of the Remote Connection window and I can't make it the focus. #Include "VKEYS.INC" proc main string sRemote integer...

I have a process that employs rget to grab a number off the screen, place that number into an integer, and loops that many number of times. The problem I'm having is that Counter is incrementing twice for each loop as opposed to one time. I tried Counter = Counter + 1 and got the same result...

This isn't necessarily aspect specific but I was hoping someone here might know. I direct output from a terminal to a file and the header row contains a control character. I think I can strip it out if I know how to identify it. It appears as a straight line in the file but it's actually a...

I have a group of accounts with a beginning start time and a beginning end time with duplicates in the range. I need to subtract the earliest (or first) start time from the latest (or last) end time to obtain the total time. The following formula outputs the total time if there's only one...

I'm borrowing from the OMPR227 script to import columns from a text file to Excel. The problem I'm having is that some instances of my columns are null and other columns contain spaces. Is there a way to strtok on the position of the column in the file as opposed to a space? Would fseek work...

I took this script off this site. It's logic appears correct but I'm getting a "value out of range" error. I have multiple columns I need to delimit and I wonder if it's because the total exceeds 256 characters fopen 0 sTabName READ while not feof 0...

This was working earlier but now it's not allowing me to set the capture file name. ltimeints $LTIME iYear iMonth iDay iHour iMin iSec strfmt sFileName "C:\Program Files\Symantec\Procomm Plus\Capture\ACTIVITY_%d%02d%02d" iYear iMonth iDay strcat sFileName ".TXT" txflush...

I currently use the following to change the number format in Excel: oSheet.Range("H3", "H800").NumberFormat = "[BLACK]###,###;[RED](###,###)" Is there a way to change the format to a phone number format or social security number format?

I have a loop that cycles through the same command 150 times. Is there a way I can increment the number of times the <TAB> key is entered (0x09) for each pass of the loop? In other words, I'd like it to start with 1 tab, then 2 tabs, and so on... while Counter != 150 termvkey 0x09 pause 2 fetch...

I currently have an html table that displays data from an SQL table. I was wondering if it's possible to create a new table for each value in a field. For instance: Column A X X X Y Y Y Is there a way I can create a new html table for each change in Column A? One table for X and one for Y...

I currently run a DTS package where the results are pushed into Excel using an ActiveX script. The results are a summary (or count) of fields in a table. I'd like to create a hyperlink that will allow the user to click on the cell and it will forward them to a webpage with more detailed...

I currently run a DTS package where the results are pushed into Excel using an ActiveX script. The results are a summary (or count) of fields in a table. I'd like to create a hyperlink that will allow the user to click on the cell to get more detailed, drill-down information. I was wondering if...

I currently run a DTS package where the results are pushed into Excel using an ActiveX script. The results are a summary (or count) of fields in a table. I'd like to create a hyperlink that will allow the user to click on the cell to get more detailed, drill-down information. I was wondering if...

I USE A DTS PACKAGE TO IMPORT A .CSV FILE INTO A TABLE. ONE OF THE COLUMNS IS AN AMOUNT COLUMN. I WAS WONDERING HOW I CAN REMOVE THE DOLLAR SIGN ($) FROM THAT COLUMN DURING THE IMPORT.

Someone showed me this a while ago but I can't seem to find it. I'd like to have the user enter input, ask them to verify the input they entered, and give them the opportunity to correct it if they made a mistake. I know that it looped back if the user selected "no" but I'm not sure how it...

We currently use software (FastSync) to pull files from one of our clients. Is there a way ProComm can do bisync modem transfers? .CALL,1,7634409070 .MESSAGE,$$REQ ID=3xxX BID='IF' BLOCK=06 .RCVE,C:\TEST\TEST-IN .EXIT