Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-09-2018, 12:00 AM
Zhibek Zhibek is offline save document in shairpoint by one command button click using the vba Windows 10 save document in shairpoint by one command button click using the vba Office 2013
Advanced Beginner
save document in shairpoint by one command button click using the vba
 
Join Date: Aug 2018
Location: Almaty, Kazakhstan
Posts: 30
Zhibek is on a distinguished road
Default save document in shairpoint by one command button click using the vba

How to save document in shairpoint by one command button click? using the vba
Reply With Quote
  #2  
Old 08-10-2018, 12:31 AM
Zhibek Zhibek is offline save document in shairpoint by one command button click using the vba Windows 10 save document in shairpoint by one command button click using the vba Office 2013
Advanced Beginner
save document in shairpoint by one command button click using the vba
 
Join Date: Aug 2018
Location: Almaty, Kazakhstan
Posts: 30
Zhibek is on a distinguished road
Default Save as Document.docx in ShairPoint by using the command button

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
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
save document in shairpoint by one command button click using the vba Command button - save in temp folder and send email with attachment 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:01 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft