Prev: code problem not working HELP
Next: Copy Data from Sheet 1 to Empty Cell in Sheet 2
From: Heera Chavan on 3 Nov 2009 01:41
Hi,

I want a VBA code which can upload a excel workbook on share point.


Please help


Regards
Heera Chavan


From: Tim Williams on 3 Nov 2009 01:47
Have you tried something like:

ActiveWorkbook.SaveAs "\\yourspserver\somefolder\filename.xls" '?

Typically you can use this type of address with SharePoint, provided you
have the required access privs.

Tim

"Heera Chavan" <HeeraChavan(a)discussions.microsoft.com> wrote in message
news:C5D8CD43-8997-4121-BC3F-9A87F9E808A0(a)microsoft.com...
> Hi,
>
> I want a VBA code which can upload a excel workbook on share point.
>
>
> Please help
>
>
> Regards
> Heera Chavan
>
>


From: Heera on 3 Nov 2009 01:58
thank you Tim it was really helpful
From: Barb Reinhardt on 3 Nov 2009 05:06
This can be done, but it can be a challenge if the document library is set up
to require check out. The first thing you need to do is map that drive.
Once you map it, you can save to it like you would any other mapped drive.

HTH,
Barb Reinhardt

"Heera" wrote:

> Hi,
>
> I want a VBA code which can upload a excel workbook on share point.
>
> Please help
>
> Regards
> Heera Chavan
> .
>
 | 
Pages: 1
Prev: code problem not working HELP
Next: Copy Data from Sheet 1 to Empty Cell in Sheet 2