Connecting To Excel Workbook With Xlsm Extension 关注

0
Avatar
Legacy Poster

Hi,
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"

Thank you

Matt S

6 评论

0
Avatar
Domingo Rodriguez
版主
评论操作 固定链接

Hello Matt,

To me, it looks like you're wanting to print your labels directly from Excel by automating BarTender in the background, more than having BarTender connect to your Excel spreadsheet.

You could automate BarTender by using Visual Basic in your Excel macro based spreadsheet. Please take a look at the below White Papers:

BarTender's ActiveX Automation Interface
http://s3.amazonaws.com/SeagullBarTender/ftp/WhitePapers/WhitePaper_BarTendersActiveXAutomationInterface.pdf

BarTender's .NET SDKs
http://s3.amazonaws.com/SeagullBarTender/ftp/WhitePapers/WhitePaper_BarTenders.NET_SDKs_English.pdf

And you can also find further help on the different ActiveX - .NET SDK methods you can use by opening BarTender, pressing the F1 key to open BarTender's Help and visiting the "Automating BarTender" topic.
0
Avatar
Legacy Poster
评论操作 固定链接

No it doesn't. It sounds like he wants to print in BarTender using data from a .xlsm file.

If that doesn't work directly, Matt, I would just File > Save As from your .xlsm file (After you've used the macro to create the data), and then save a copy of all the data to a .xls file and link that one.
0
Avatar
Shotaro Ito
版主
评论操作 固定链接

One more - to work with Office 2007 / 2010 files(xlsx, xlsm, accdb), you need to install MS Office 2007 / 2010 on the PC you running BarTender.
(For .xls / mdb, you don't need MS office in your PC - Windows MDAC take that. actually I recommend this.)

If you don't have MS office 2007 / 2010 in your PC you can download database engine.
[url="http://www.microsoft.com/download/en/details.aspx?id=13255 "]Microsoft Access Database Engine 2010[/url]
(Install x86(32bit)driver even though you run x64 OS, since BarTender is 32bit app.)

Reboot after install and try again.
0
Avatar
Legacy Poster
评论操作 固定链接

new here. Since the bar Tender is for Label, Barcode, RFID and Card Printing., can I use it to print barcode or label in Excel 2013?

 

 

KD

0
Avatar
Fernando Ramos Miracle
版主
评论操作 固定链接

Hello Hongdida,

 

Please note that BarTender is a separate application from MS Word, if you wish to actually print from Excel using BarTender as the print engine, you'll need to automate it with a Visual Basic code (using our .NET SDKs or ActiveX).

 

Could you clarify exactly what you are trying to do?

 

Regards.

0
Avatar
Legacy Poster
评论操作 固定链接

Hello, I have the same issue connecting to an .xlsm file, but in my case I can connect to this file with now issues from one computer, but receive an error message about the incorrect format when trying to connect from another computer. Both computers have the same version and installation of the BarTender (Automation), both have Office 2013 installed... Same permissions to the file... I just don't understand why it works from one computer and not from the other. What other parameters can I check? Can it be due to certain OLE DB drivers or some Excel settings?

Thank you.

请先登录再写评论。