[mso] THis works : Pasting data into excel
- From: Jacques De Schryver <jds@xxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Sat, 18 Jan 2003 00:43:46 +0100
Hello,
Through IE6 and this code in VBA, testing for example in cell B10 :
... deconcatenation work then
hab = " 1/5"
range("b10") = hab
range("b10").formulalocal = "=" & range("b10")
You get back a number, accepted in fraction format. And the formula bar
writes = 0.2
So now it is just a matter of time.
Jacques
--
Jacques De Schryver
http://jdsetls.virtualave.net/
Last photo : http://shuttercity.com/ShowPhoto.cfm?PhotoID=51638
http://membres.lycos.fr/lsteven/
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
- » [mso] THis works : Pasting data into excel
