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

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

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

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

Hi Mirabelle,

What's wrong with...
wb.SaveCopyAs "\\Public Folders\All Public Folders\PurchasingFolder\filename.xls"

You do need to add a filename.

I've never seen "posting" to anything but a webserver.

John

"mirabelle" wrote in message ...
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