Scribus Forums

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

Title: Is it possible to export from Excel to Scribus with VBA?
Post by: chichirodriguez on December 20, 2019, 03: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:

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, 03: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, 10: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