Connecting To Excel Workbook With Xlsm Extension 关注
I am new to Bartender, and databases.
I am building an excel workbook. This workbook with have data entered into it, and then the data will be used to print the labels. To process the data that is entered in to the workbook, I have to use macros and Visual Basic.
I have connected to Excel documents before, but in those times the excel docs had an extension of xls.
Is it possible to connect to an excel doc with an extension of xlsm?
If possible, what do i need to do to make it work?
I have tried to connect to the excel doc using the Add Database Connection Wizard. Once i have selected the file name and then tested the connection.
I get Error Message # 6670, the error message reads a follows:
"Failed to connect to database:
Unknown error 0x800A0BB9"
Fernando Ramos Miracle版主