Database Excel file with macro

Software technical issues not related to any of the other categories

Moderators: Georges, milos, NiceLabel Support Team

Post Reply
zbina
Enthusiast
Posts: 19
Joined: Thu Mar 22, 2018 8:17 am

Database Excel file with macro

Post by zbina » Tue Aug 21, 2018 12:14 pm

Hello,
I didnt ask a question for a long time. You missed me? O:)
I created MS Excel file with macro (I need this, because there is large VB macro creating strings for RFID printing).
This file should be source of data for my NiceLabel template, but it is not possible to select *.xlsm file as the source of data.

I tried to write my script directly to NiceLabel, but unfortunatelly, things cannot be handled so easilly as in MS Excel. Can I somehow choose *.xlsm file as the data source?

Thank you for your reply,
Zdenek Bina.

User avatar
Saso
NiceLabel
NiceLabel
Posts: 2933
Joined: Mon Sep 04, 2006 8:09 am
Contact:

Re: Database Excel file with macro

Post by Saso » Tue Aug 21, 2018 1:15 pm

Hi Zdenek,

Yes, you were missed. I am happy to see you back. :D

NiceLabel 2017 has support for .xlsm file type. It is listed under file extensions in Open dialog box.
NiceLabel 6 does not list .xlsm as supported file type, but it will still open the spreadsheet. Give it a try!
Saso Fleiser
Senior Technical Product Specialist

zbina
Enthusiast
Posts: 19
Joined: Thu Mar 22, 2018 8:17 am

Re: Database Excel file with macro

Post by zbina » Wed Aug 22, 2018 10:21 am

Thanks for the reply,
In the end, I was able to "transcript" my macro from excel to NiceLabel, and now it is working within the the NiceLabel. I think this is the best way how to complete my task. All is done by NiceLabel again. Good lord, what would I do without NiceLabel :-({|=

See you soon, people :D

Post Reply