One of my lines on the Master Schedule contains a quotation mark. So when my program sets this line to a variable and then tries to send it to excel, it causes my script to freeze. for example: Let>Line1=This is a test message. It will display in the cell. Let>Line2=This is a test message that is ap...

EDIT: gotit

I was not putting the equal sign into the ddepoke

THANK YOU MUCH!

Alright Marcus, I have re-written the entire portion of the script that writes to excel using your suggestion: [code] DDEPoke>Excel,Book1,R1C1,="Line1" & Char(10) & "Line2" [/code] You use the words Line1 and Line2 in your suggestion. Are these variables? If not, is it possible to use variables in y...

Using this same principle, how would this work: [code] ReadFile>d:\jobs.txt,inFile Separate>inFile,CRLF,lines // Let>j=0 Let>k=0 Let>combined= Repeat>k Let>j=j+1 Let>k=k+1 Let>this_line=lines_%k% //this position code starts on the second line after my job number is found. Position>#,this_line,1,p //...

I don't know if you read my code above, but you recommended I use the POSITION function to gather my lines from text. Your suggested writing to EXcel method does not work with your suggested POSITION function for acquiring the text lines. DDEPoke>Excel,Book1,R1C1,="Line1" & Char(10) & "Line2" The ab...

Why do the excel cells not expand when data is inserted into them? I have text wrap on for each cell. I am wondering if you resolved this issue. Do you mean to say that the data is getting truncated or is it simply a display issue that you are writing about? This was an issue within excel. It was i...

Just a quick thought without analyzing the DDEPoke stuff ....(The If>combined line looks a bit confusing to me right now) ..... Can you ad a string of 20 spaces vs. the %LF%, and format the cell RxC2 to do word wrapping? --------------------------- It looks like you sending each line to Excel as it...

I have tried your suggestion a few times. I have placed the quotation marks in different areas, I can't get it to post to Excel correctly. The code below works great;however, it posts to my excel cell as one long sentence. I have two END>subStoreStatus because after the job number data has been post...

Bob, I'm using adobe standard 6.0 but have access to the new one if -->absolutely<-- necessary. I would like it work within the confines of 6.0 if possible. We only have 5 licenses left on the new adobe.

Once you have the line in a variable use length> to get the length (number of characters in the line). subtract 7 from the length. then use the result in a MidStr> ///(assuming the line is in variable "line") Length>line,len Sub>len,7 Midstr>line,%len%,8,LastEight MDL>LastEight Thats great. Works l...

When I attempt to paste long sentences into excel cells, I know of know current way to enter a soft return within the cell itself. Adding a CR, LF, or CRLF does not allow me to simulate ALT-ENTER soft return as it does within Excel.

Is it possible to grab the last 8 characters of text from a predetermined line? to be more specific, for example: #0001: Job description 9/19/07 10/29/08 Step 1: do this 9/19/07 Step 2: do this after 10/24/08 Step 3: do this after after 10/29/08 Once I know what line #0001 exists on, is there a way ...

I use the full adobe version. I open the pdf and then click file/save as text. I was hoping to avoid this step without the user having to open the pdf file; however, I'm reluctant to use any free software on the office computers. I will take some more time tonight to give these pdf-text commandline ...

What is the reason why a screenshot does not capture a cursor?

If we could possibly capture a screenshot of just the cursor, the screenshot of the cursor could be used to assign each cursortype to a variable. Then using imagerecognition we could compare

Thank you, much. That worked out just fine.