the post method to the workbook does not work properly
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
|