从VB6应用程序运行excel宏 [英] Running an excel macro from a VB6 application

问题描述

我已经在o365上的Excel 2013中开发了一个应用程序作为宏，其中包含一个具有相当多控件的表单，包括一个RUN命令按钮。它使用并填充了许多工作表。我有一个用VB6编写的独立（旧）工作台应用程序，我现在想要
将Excel宏的功能包含到工作台中。任何人都可以协助如何实现这一目标吗？我不是开发人员，只是编写简单的应用程序计算而不是插件。

I have developed an application in Excel 2013 on o365 as a macro with a form that has quite a few controls, including a RUN command button. It uses and populates a number of sheets. I have a separate (old) workbench application written in VB6 and I now want to include the functionality of the Excel macro into the workbench. Can anybody assist in how to achieve this? I am not a developer,  merely write simple applications computational that are not available as a plug-in.

谢谢，

Mike

推荐答案

您可以在以下论坛中获得对VB 6.0的支持。此论坛适用于Visual Basic .NET。

You can receive support for VB 6.0 in the below forums. This forum is for Visual Basic .NET.

http://vbcity.com/forums/ 26.aspx

http://www.vbforums.com/forumdisplay.php?1-Visual-Basic-6-and-Earlier

您可以为VB 6.0调整以下代码因为概念是相同的：

You can probably adapt the below code for VB 6.0 as the concept is the same:

https://support.microsoft。 com / en-us / kb / 306682 < a href ="http://vbcity.com/forums/26.aspx">

这篇关于从VB6应用程序运行excel宏的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！