本文介绍了我需要通过visual basic 6在Excel上播放宏的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述


我需要在Excel bay visual basic 6上播放宏

I need to play macro on Excel bay visual basic 6


并打开我的file.xlsb因为打开我的VBA App

and open my file.xlsb because open my VBA App


-此应用程序在Windows中的Excel工作簿之后打开双击点击 

-this app open after excel workbook in windows a duple click 


-my办公室是2007

-my office is 2007

推荐答案

        Dim oExcel As Object
        Dim oBook As Object
        Dim oBooks As Object

        'Start Excel and open the workbook.
        Set oExcel = CreateObject("Excel.Application")
        oExcel.Visible = True
        Set oBooks = oExcel.Workbooks
        Set oBook = oBooks.Open("C:\Users\username\Documents\WorkbookName.xlsx")

        'Run the macros.
        oExcel.Run "DoKbTest"
        oExcel.Run "DoKbTestWithParameter", "Hello from VB Client"

        'Clean-up: Close the workbook and quit Excel.
        oBook.Close SaveChanges:=False
        Set oBook = Nothing
        Set oBooks = Nothing
        oExcel.Quit
        Set oExcel = Nothing


这篇关于我需要通过visual basic 6在Excel上播放宏的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

10-28 20:00