Saving Excel File to Public Folder

[Veronica Haynes]

I am splitting up an Access database into many Excel spreadsheets and need
to save them into a public folder that I have created in Outlook. I have
been successful in saving the Excel files to my hard drive, but regardless
of how I specify the path to the public folder, I cannot save there. I get
error 1004: Method 'SaveAs' of object '_Workbook' failed.

Anyone have any ideas on this one?

Thanks,

Veronica

[Milly Staples [MVP - Outlook]]

Have you tried drag and drop? Display your files from Other Shortcuts,
then drag the item from there to the public folder you have displayed in
the Outlook Bar.

--
Milly Staples [MVP - Outlook]
FAQ for Outlook 2000:
http://support.microsoft.com/support/outlook/faq/ol20/default.asp
Highlights for Outlook 2000:
http://support.microsoft.com/support/default.asp
[Post all responses ONLY to the news group, please.]

"Veronica Haynes" <veronic...@cubic.com> wrote in message
news:OX00xhSw$GA.254@cppssbbsa03...

[Veronica Haynes]

Yes, I am the owner of the Public folder. I have all rights on it.

Veronica

"Philippe Oget" <philip...@virgin.net> wrote in message
news:jGAV4.2445$1W6....@news2-win.server.ntlworld.com...
Have you Create Rights in that Public folder?

--
-----------------------------------------------------
Kind regards,

Philippe Oget
Helpdesk Analyst

philip...@proget.itgo.com/
Windows Tips, Internet Sites galore and more...
http://www.proget.itgo.com/
http://freespace.virgin.net/philippe.oget/Master/PC_Maintenance.zip