Hi Rob,
I think I got it at solved at the end with your tremendous help. The problem
is/was that, I assigned the execution of the macro to a command button in my
file. When I run the macro via VBE it worked all right. But when I try to
use the button instead to call the macro, the error occured.
The only trouble lies ahead is the "slow opening" of the *.htm files
created. Maybe it is because of the large area beeing used (65*** lines x
256 columns) to copy into an html file. Any comments on that will be
wellcomed.
Thanks a million Rob
Martyn



"Rob Bovey" wrote in message
...
Hi Martyn,

Let's start with the simplest possible case. I've attached a one-sheet
workbook that has one procedure that exports the single sheet to an html
file in C:\. I've tested it here under Excel 2000/Windows XP and it seems
to
work. Give it a try on your end and see what happens.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Martyn" wrote in message
...
Hi Rob,
Yes, I did change the path to the most acceptable "C:\"
No...same result. The compiler says:

Method 'Publish' of object 'Publish Object' failed

highlighted text is the

wkbBook.PublishObjects.Add(xlSourceSheet, _
szFileName, wksSheet.Name, "", _
xlHtmlStatic, wksSheet.Name, "").Publish True

part. Somehow XL is not happy about it.
p.s.: (-the above statement is written as a single complete line too-)

Hope we/someone can work it out...:)
Sincerely
Martyn