VB脚本以编辑模式打开Sharepoint文件 [英] VB script to open Sharepoint file in edit mode

问题描述

在尝试将图表添加到Sharepoint页面几周后(没有成功)，我走了使用Web访问excel Web部件的路径.

After weeks of trying to add charts to a Sharepoint page (with no success) I have gone down the path of using the web access excel web part.

这会将信息从Sharepoint中提取出来并制作图表，然后将其发布回Sharepoint页面.

This pulls info out of Sharepoint and makes charts, and then publishes back to the Sharepoint page.

问题在于这一切都需要手动刷新.

The issue is this all requires manual refresh.

通过点击此链接 https://www.youtube.com/watch，我在任务计划程序中添加了刷新功能? v = HyM9hzajoRg

但是，我需要刷新的excel文件始终以只读模式打开，这意味着刷新后该文件无法保存.

However the excel file I need to refresh always opens in read only mode, which means the file cannot save after refresh.

是否可以在编辑模式下从Sharepoint打开文件?我尝试了很多选项，但找不到答案！

Is there a way to open files from Sharepoint in edit mode? I have tried loads of options but cannot find the answer!

这是上述youtube视频中的VB脚本

This is the VB script from the above youtube video

Set xl = CreateObject("Excel.Application")
set wb = xl.WorkBooks.open("https://blah blah blah/sharepoint.xlsx")
xl.Visible=True
xl.DisplayAlerts = False
WScript.Sleep 1000
wb.RefreshAll
xl.ActiveWorkbook.RefreshAll
WScript.Sleep 60000
wb.Save
wb.Close
xl.Quit

谢谢

推荐答案

Grubpot(喜欢这个用户名！)-有很多方法可以做到，但是当您遇到问题时，使用Excel查看器.

Hi Grubpot (love that username!)- there are ways to do that, but you're going to run into issues while using the Excel viewer.

这篇关于VB脚本以编辑模式打开Sharepoint文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！