从Excel页面打开Excel文件时出现[Excel + VBA + SharePoint]运行时错误 [英] [Excel + VBA + SharePoint] Run-Time Error when opening Excel file from SharePoint page

问题描述

您好，

我的工作簿结构如下：

  ; - sheet1：  - 包含所选产品的概述模板

                  - 分配了宏的表单按钮

                 - 宏打开窗体

                &NBSP ; - 用户表单使用SQL模块过滤组合框和列表框中的数据

                  - 验证将数据从列表框复制到sheet1的按钮

  - sheet2：包含数据和无限的列和行

问题是，每次我将此文件复制到SharePoint页面然后打开它我收到此消息：

运行时错误'-2147467259（80004005）'互联网地址无效

如何解决这个问题，知道它在本地和虚拟驱动器上工作正常吗？

解决方案

你好Admin-Dev，

感谢您在MSDN论坛上发帖。

  你能给我看一些代码片段以供进一步研究吗？

祝你有个美好的一天，

Tom

Hi there,

I have workbook structured as follow:

 - sheet1: - contain an overview template of a selected product

                 - Form button with a macro assigned

                 - the macro open a userform

                 - the userform use SQL modules to filter data in a combobox and list box

                 - validate button that copy data from list box to sheet1

 - sheet2: contain data and endless columns and rows

The problem is, each time I copy this file to a SharePoint page then open it I receive this message:

Run-Time Error '-2147467259 (80004005)' Internet Address not valid

How can I fix it, knowing it works fine on a local and virtual drive, please?

解决方案

Hi Admin-Dev,

Thanks for posting in the MSDN Forum.

Would  you please show me some code snippet for further research?

Have a good day,

Tom

这篇关于从Excel页面打开Excel文件时出现[Excel + VBA + SharePoint]运行时错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！