LF causes only the first found line to be written to excel. All subsequent lines are omitted somehow. I also tried CRLF and CR when DDEPoke>Excel. None allow me to simulate an ALT-ENTER press within Excel. //subStoreStatus------------------------------------subStoreStatus SRT>subStoreStatus ReadFile...

I have a M Scheduler script that reads a text file and combines specific lines into one variable. When the script has gathered all of the lines it needs, it writes it to excel. My text file looks like this: #0004: Job description 01/19/08 Step 1: do this 01/22/08 Step 2: do this after 01/24/08 Step ...

[quote="Me_again"]There's no magic bullet/simple algorithm [...]very easy to integrate into a macro.[/quote]

The whole office will be using this so I, for the time being, will just manually convert the pdf to text.

1. You can loop through the text file, writing the "keeper" lines to a new file, and skipping by the "throw away" lines. Thanks Bob, that sounds effective enough. I'll give that a try and see what it comes up with. EDIT: Ok, I looped it but i cant seem to omit the blank line nor the odd character. ...

I have a large text document from which I am importing particular lines of text into excel; however, I need to delete or completely remove any and all lines that begin with one of the following: [code] Page Task Name Start Finish "blank line with no text written to it. like a CRLF" [/code] After the...

I have a couple more questions if you don't mind answering them. After all of the lines have been combined into a single line of text, such as the above code does, is it possible to enter soft returns that will simulate the ALT-ENTER that is in excel. I would like to have a crlf in between each line...

I have a text file that contains data I need to insert into an Excel file. I have found a way to search for the specific starting line of my data; however, I need to find a way to detect the final line of data. This is what a few lines of my data would look like: #0001: Job description 01/19/08 Step...

I love the new waitcursorchanged> timeout! Great addition. However, waitcursorchanged is telling me when the cursor changes, and I use this feature quite often, but Is there a way to identify the current cursor or even Declare/define the current cursor so that next time the "cursor changes" I can sa...

Is there a function that can detect the current line of code so that I can output it into an error log? For example [code] Let>k=%k%+1 ScreenCapture>X,Y,x,y,C:\whatever\%k%.bmp WriteLn>Error found in Line %detectCurrentLineNumber% refer to %k%.bmp [/code] I have been manually inserting the correspon...

Found it. What a pain. I had called a variable named HC31 however, in my declarations above, This variable did not exist. I had named it HC21 instead of 31. All is well now. It would be great to have a feature that told you when your error is variable related instead of saying "( is expected" or "% ...

When I place the brackets {...} around the expression, I get a syntax error for that line.
It tells me ( is expected.

The following snippet checks 768 different pixels to see if the color at each spot matches one of 78 colors stored in 78 variables. The variables are declared at the beginning of the script. The scrip is writing the exact number of entries to the textfile every time.HC1-HC78 represent the colors. I ...