Page 1 of 1

Database Excel file with macro

Posted: Tue Aug 21, 2018 12:14 pm
by zbina
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.

Re: Database Excel file with macro

Posted: Tue Aug 21, 2018 1:15 pm
by Saso
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!

Re: Database Excel file with macro

Posted: Wed Aug 22, 2018 10:21 am
by zbina
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