Scribus Forums

Scribus => General Discussion => Topic started by: chichirodriguez on December 20, 2019, 04:07:05 pm

Title: Is it possible to export from Excel to Scribus with VBA?
Post by: chichirodriguez on December 20, 2019, 04:07:05 pm
I use spreadsheets to hold information that I later use VBA to export to Word for the purposes of publication with this line:

Code: [Select]
wordApp.Selection.TypeText MY_STRING
There's way more to it than this, but this is the heart of it.

Is it possible to use VBA to send to Scribus?
Title: Re: Is it possible to export from Excel to Scribus with VBA?
Post by: dragonfly on December 20, 2019, 04:19:27 pm
I have not visited this forum for many moons. I am upgrading my Ubuntu OS. So it is by chance that I can reply.

If you have external variables to inject into Scribus sla format then I do recommend that you explore ScribusGenerator
 https://github.com/berteh/ScribusGenerator (https://github.com/berteh/ScribusGenerator).

And in general explore the Scripter (python) functions in Scribus top tool bar.
Title: Re: Is it possible to export from Excel to Scribus with VBA?
Post by: dragonfly on December 21, 2019, 11:43:59 am
Later thoughts ..

If you have extensive works written in VBA then perhaps pyxll might bridge between VBA and Scribus/Python scripting. Caveat: I do not use VBA.  Google Sheets, for example. has a Python API.

https://www.pyxll.com/docs/userguide/vba.html