Replies

Hi Jeff,
It works!
I only had to change: Do While LCase$(rng.tagName) “td”
into Do While LCase$(rng.tagName) &lt> “td” for 2000 to work.
Great and many thanx.
I would never have been able to write this.
I couldn’t believe there was not a direct way to change this.
I’ve done my part in “macro-ing” in Word and Excel, so I thought I do a quicky in FP too.
Didn’t reckon with Bill B. though 🙁
thnx again, George

Hi Jeff,
It works!
I only had to change: Do While LCase$(rng.tagName) “td”
into Do While LCase$(rng.tagName) &lt> “td” for 2000 to work.
Great and many thanx.
I would never have been able to write this.
I couldn’t believe there was not a direct way to change this.
I’ve done my part in “macro-ing” in Word and Excel, so I thought I do a quicky in FP too.
Didn’t reckon with Bill B. though 🙁
thnx again, George

Hi jscher2000,
sorry, but of course it’s html-table but it looks like an excel-table.
It’s a vacancy/no vacancy table of which we have to change the color of the cells regularly.
It’s too much of a hassle to do that by hand.
That’s why I want to create several simple macro’s to change to red, orange or green and v.v.
Any ideas?
TIA
George

Hi jscher2000,
sorry, but of course it’s html-table but it looks like an excel-table.
It’s a vacancy/no vacancy table of which we have to change the color of the cells regularly.
It’s too much of a hassle to do that by hand.
That’s why I want to create several simple macro’s to change to red, orange or green and v.v.
Any ideas?
TIA
George

Thanx Leif,
Seen that but that doesn’t help.
I’m looking for specific commands to alter the color of the cell by macro.
CU, george

Thanx Leif,
Seen that but that doesn’t help.
I’m looking for specific commands to alter the color of the cell by macro.
CU, george

Hey Rory the Pelvis ,
That’s it!!!
Simple but effictive, thanx.
Any idea how it was checked, because I can hardly imagine it is checked by default.
And this user is one that wouldn’t dare clicking on anything beyond input in cells.
Nevertheless: Fixed Decimals have left the building.

Hey Rory the Pelvis ,
That’s it!!!
Simple but effictive, thanx.
Any idea how it was checked, because I can hardly imagine it is checked by default.
And this user is one that wouldn’t dare clicking on anything beyond input in cells.
Nevertheless: Fixed Decimals have left the building.

Hi Phil,
Thanx for thinking with me. I has to do with the proofing tools.
I guess it’s because I had to leave Outlook 98 on that machine it’s shared files stayed there too. Outlook 98 was an upgrade from 97 whick was installed with Office 97. I found normal.dot in the old dir of 97. For compatibility (syncing with a psion) they need outlook 98. They settled for turning of spellcheck. They can live with it.
So, for now this thread can be closed. Thnx again. George

Hi Phil,
Thanx for thinking with me. I has to do with the proofing tools.
I guess it’s because I had to leave Outlook 98 on that machine it’s shared files stayed there too. Outlook 98 was an upgrade from 97 whick was installed with Office 97. I found normal.dot in the old dir of 97. For compatibility (syncing with a psion) they need outlook 98. They settled for turning of spellcheck. They can live with it.
So, for now this thread can be closed. Thnx again. George

Phil, thanx.
Glad this is a new machine, it took me about 15 minutes to complete these tasks.
BUT: didn’t help I’m afraid.
Anything else?
George

Phil, thanx.
Glad this is a new machine, it took me about 15 minutes to complete these tasks.
BUT: didn’t help I’m afraid.
Anything else?
George

Thanx, I’ll think it over

Did I say kb?
That should be just B.
612 bytes. As you can imagine hardly anything was saved!
Any idea?

Hans, thanx for your concern (bedankt).
I’ve tried to Save As Html, but there only remains 612 KB 🙁
I’m convinced there’s something wrong in the programming of the sheet.
But it takes too much time and money to solve it. As a work-around we’re gonna split the larger files.
I’s about numbers of employees. About 500 of them would make a file of 50 Mb.
Split this in 250-250 and there remain two files of about 30 Mb. That’s acceptable.
Thanks