![]() |
#1
|
|||
|
|||
![]()
How to save document in shairpoint by one command button click? using the vba
|
#2
|
|||
|
|||
![]()
gmayor, Hello!
there is a macro which must save document in Shairpoint, but it doesn't work. It works if I make SaveAs in computer location, but when I am using Shairpoint location it doesn't work, Where is the mistake? Private Sub CommandButton1_Click() Dim OL As Object Dim Doc As Document Application.ScreenUpdating = False Set Doc = ActiveDocument Doc.SaveAs2 FileName:=("http://shairpoint/location/DMS_new") & "\" & Environ("username"), Fileformat:=wdFormatDocument, AddToRecentFiles:=True Application.ScreenUpdating = True Set Doc = Nothing Set OL = Nothing End Sub |
![]() |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
macro command button, save and print and clear | fatboy1973 | Word VBA | 4 | 07-06-2017 08:23 AM |
Using a Command Button to "Click" Hyperlink in Email | bigbudgie | Word | 2 | 08-07-2016 02:31 AM |
ActiveX Command Button disappears after click | Bengt | Word VBA | 1 | 09-18-2013 12:42 PM |
![]() |
bigbird69 | Word VBA | 13 | 11-18-2012 10:06 PM |
Word doc bug when closing from userform command button click macro | Joe Patrick | Word | 1 | 07-05-2011 08:53 PM |