Home > Common Problem > How to open excel file with vba

How to open excel file with vba

藏色散人
Release: 2020-04-27 16:29:32
Original
13055 people have browsed it

How to open excel file with vba

vba怎么打开excel文件?

在工作表中,点击菜单栏【开发工具】,在其工具栏内,点击【visual basic】!

推荐:《Excel教程

How to open excel file with vba

会进入VBA编辑界面!点击工具栏内【插入用户窗体】按钮,在其下拉菜单中,选择【模块】!

How to open excel file with vba

会弹出模块编辑窗口!

How to open excel file with vba

在模块编辑窗口中输入如下代码:

Sub 打开文件()

Dim wkb As Workbook
Set wkb = Workbooks.Open("e:\258.xls")
Workbooks.Open ("e:\963.xls")
End Sub
Copy after login

How to open excel file with vba

点击VBA窗口的运行按钮!

How to open excel file with vba

会打开258.xls 和963.XLS两个工作簿!

How to open excel file with vba

The above is the detailed content of How to open excel file with vba. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template