Excel编程VBA [英] Excel Programming VBA

问题描述

我打开了一个Excel文件，我使用宏调用了一个可执行文件，该可执行文件可以写入/读取已经打开的Excel文件.

问题:在上述情况下，我无法打开其他Excel文件.请帮助解决此问题.

I have one Excel file open, I use macros to call an executable, this executable can write/ read the already open excel file.

Problem: I am unable to open other excel files under above mentioned scenario. Please help to resolve this issue.

Thanking you guys in advance!

推荐答案

您怎么称呼此可执行文件?
您是否使用过Shell()命令?

How you call this executable?
Do you used Shell() command?

Application.Workbooks.Open("/filepath/filename.xls")

通常可以解决问题.

如果没有，请显示代码，我应该可以为您排序.
(自称Excel VBA Guru！)

Application.Workbooks.Open ("/filepath/filename.xls")

Usually does the trick.

If not, please show the code and I should be able to sort it for you.
(Self proclaimed Excel VBA Guru!)

这篇关于Excel编程VBA的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！