使用ms字中的VBA宏访问sharepoint在线列表数据时拒绝访问 [英] Getting access denied when accessing sharepoint online list data using VBA macro in ms word

问题描述

我需要运行宏，它将通过从共享点在线列表中获取数据来创建特定格式的word文档。我的宏在2013年的分享点工作正常。从VBA
宏调用  / _ vti_bin / Lists.asmx？op = GetListItems时，获取  sharepoint在线列表中的错误请求400错误 但是在场地内工作正常。

I have a requirement to run the macro which will create a word document in specific format by getting data from share point online list. My macro is working fine in share point 2013 Premises. When calling /_vti_bin/Lists.asmx?op=GetListItems from VBA macro, getting  bad request 400 error in sharepoint online list  but working fine in premises.

Debalaxmi Hota

Debalaxmi Hota

推荐答案

嗨Debalaxmi， 
$


我对excel中的VBA宏不是很熟悉。



请提供详细的宏，它将通过从共享点在线列表中获取数据来创建特定格式的word文档，以尝试重现该问题。 



最诚挚的问候，&
$
Lisa Chen 

Hi Debalaxmi, 

I am not very familiar with VBA macro in excel.

Please offer the detailed macro which will create a word document in specific format by getting data from share point online list to try to reproduce the issue. 

Best Regards, 

Lisa Chen 

这篇关于使用ms字中的VBA宏访问sharepoint在线列表数据时拒绝访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！