Recent content by TC2000

How do I send "CTL-B" in expect command

I try to setup a script which will include over 10 sql command. For each sql command, it will run in the backend. e.g. nohup sqlplus uid/pid @fdfdfdfdf & I will like to echo the Process ID. Can anyone tell me how???

Dale Watson Do you have any other suggustion for converting the date without the leading BLANK Thanks Regards Tony

How do I Change DATE Column to TEXT Column? I have a date column with value "02/04/2001". Using workbooks.saveas function to save worksheet as csv, it become "2/4/2001" Best regards

Bryanbayfield, It works fine. THANKS AGAIN I just wander if it will speedup the process if I apply autofilter. Tony

Bryanbayfield, It works fine, but I have an addition request. How do I put a condition in the filling instruction ? For any column C which begin with "BUY" or "SELL", copy Column C value to Column D Thanks in advance

When I run the following instruction, I got the error "Autofilter method of Range class failed" Selection.AutoFill Destination:=Range("G10:G" & lastrowx), Type:=xlFillDefault Range("G10:G35").Select Columns("L:L").Select Selection.Delete...

What I want to do is to duplicate a column E with the same value of column D starting row 10 till the end of the sheet Best regards TC2000

How do I fill up the cell for colume E from row 10 till the end of the sheet? Range("E10").Select Selection.AutoFill Destination:=Range("E10:E100"), Type:=xlFillDefault Best regards

It works, but what is the different btw <cfoutput> and <cfloop>. Any idea why we can't use <cfoutput> inside the <cfmail> tag???? Anyway thanks....

WHAT'S WRONG WITH THE FOLLOWING SOURCE ?? <CFQUERY NAME=&quot;GetQTask&quot; DATASOURCE=&quot;eKong&quot;> Select * from QTask where wStatus ='P' </CFQUERY> <cfmail query=&quot;GetQTask&quot; FROM=&quot;tonychan@algoltec.com&quot; TO=&quot;#GetQTask.EMail#&quot...

Need help I have to create a module which allow the user to input record into the table. How do I show him the last 5 records he's recently input Thanks in advance

Need help I have to create a module which allow the user to input record into the table. How do I show him the last 5 records he's recently insert Thanks in advance

Need help I have to create a module which allow the user to input record into the table. How do I show him the last 5 records he's recently input Thanks in advance

I try to encrypte application.cfm, but it won't work. Can anyone tell me why???? Thanks