Recent content by kelqc

Hi ETID Thanks for the help. I will give it a try Kelvin

Hi I use the following code to open a file with Notepad using Excel97. Shell("C:\WINNT\Notepad.exe TossLogFile.txt", 1) Is it possible to open the file in read only mode, I am trying to stop people from making any changes to it. Thanks Kelvin

Hi PHV I have actually found that : worksheetfunction.fixed(Number,Decimal places) will do the job Thanks for your reply Kelvin

Hi I want to set the decimal places for the number 123.45678 I know I can use format(123.45678,"##0.00") to get 123.46 But I want to be able to change the decimal format at run time, so can you change the "##0.00" string to a number variable eg format(123.45678, 2) to get 123.45 Thanks Kelvin

OK, Well that rules that idea out, I will see if I can work something else out then. Thanks heaps Kelvin

Hi PHV I have looked in the printcap man file on my sco system, and unfortunately it doesn't talk about the ff: option I have looked a the printcap man file on a Linux system and I believe ff: is what I need, but I am just not sure if the format of the control character I am putting in the...

Hi I am using LPRng to hand the printing on my scobox v 5.0.5 I was wondering if I put: :ff='^L': in the printcap, will this put a form feed at the end of the print job? Also, is the format correct?, do you use quotes ? Any help would be great Thanks Kelvin

Hi Tony, Thanks for the excellent explanation, it has taken me a while, but I get it. As a scientist I like to break down and understand the formulae I use. It helps me to apply them in other areas sometimes. Regards Kelvin

Hi Tony I just tried out your formulae, the one with the MAX in it has worked fine, but the one without the MAX didn't work as expected. Also, if possible, can you explain what each section of the formula does?, I am pushing my luck or what. Many thanks Kelvin

Hi Fred and Tony Thanks for all your help guys, I new it wasn't going to be easy. I will sit down tonight and try Tony's formula out. You both deserve a star. Kelvin

Hi I have some data that I neeed to apply decimal places and significant figure parameters too in Excel 97 eg 121.2365 becomes 121.2 (4 sig figures, 1 decimal place) I am sure I can do the decimal places in Excel, but I am not aware of any function to do significant figures. Does anybody...

Hi PHV Yep, you are right. I found a posting from qjd2004 sent on 03/08/04, asking the same question. The reply given by Loomah was excellent. Loomah has answered my question and more, thanks Loomah. I encourage all to take a look at this posting. Thanks Kelvin

Sorry all, I have found the answer to my question in a previous posting, thanks anyway. Kelvin

Hi I am using Excel 97, I have written code to add a tool bar and add a button, at run time, these open up just fine at startup. But I don't know how to link the button to run a "sub" function in my code at run time. I can do it manually by right clicking on the button, selecting custimise...

Hi Comtec17 Thanks for your reply, the Win98 machine doesn't have the 'hosts' file. I never even thought to create it. I asummed that Win98 looked in the hosts.sam file. And I have already got the hosts file on the Unix box set up. Thanks again Kelvin