Hi Mirabelle,

Don't know the answer. Maybe you should put your question in a new post.

--
Regards,

OssieMac


"mirabelle" wrote:

Is there any other way to post an Excel spreadsheet to a public folder (not
as an attachment to an E-mail message) but as a document - so I can take
advantage of the documents properties displayes in a view.



"OssieMac" wrote:

Hi Mirabelle,

The following copied out of Help:-
DestName Optional Variant This argument is ignored. The Post method prompts
the user to specify the destination for the workbook.

Therefore I doubt that you can do what you want to.

--
Regards,

OssieMac


"mirabelle" wrote:

Here is the command I used

wb.Post ("\\Public Folders\All Public Folders\PurchasingFolder\")

However, a dailog box pops up with the public folders tree view

What is the syntax of the "destination" parameter, so it would post without
bringing up the dialog box.

Thanks

Dominique