View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Programing Help Needed

Sounds like you are saying you want to save the original document, but you
want it have a different name and be saved to a different location.
unfortunately, that is not possible without doing a SaveAs. It sounds like
your solution would have to reside with your interface to the sharepoint
server. Possibly you can define this document as a template and gather data
on workbooks created from that template. I can't say, but it would make
sense that it would support such a construct.

--
Regards,
Tom Ogilvy


"smonczka" wrote in message
oups.com...
The problem with using SaveAs is that I'm pulling the form from a WSS
document library, it's a quote form.

The user opens up a custom contact database application, locates the
clients name and then selects a "make quote" button from within the
application. Once they do this .net calls the excel form from the WSS
directory and populates it with the contact information.

Problem is when the form is saved by the user the default directory is
\document library\forms, cause that where the form was pulled from.
Meaning the user has to manual change the directory to \document
library. LOL Like that is going to happen.

If i use a SaveAs statement in an OnOpen macro the document will be
saved in the proper directory but it bypasses Sharepoints MetaData
which is colected by the document libary from the user when the
document is saved. Any type of SaveAs will automaticly bypass this
request to input the MetaData.

Sorry about being long winded, but I hope that makes it clearer.

Thanks
Steve