This often has to do with write/modify permissions in the target directory -
is the target on a shared drive on a network?

--
Regards,
Tom Ogilvy


Joe C wrote in message
...
We have a VBA macro that reads-in HTML tables and puts
them on a tab in an Excel workbook. At the end, we do a
Save As and it generates a Microsoft Excel numberic file
and then quits. It does not take our name?

Works fine in Excel 2000
Does not work in Excel 97

We tried the service packs for Office / Excel 97 and that
did not help at all.

Anybody have any clues on this?

Thanks.