Author Topic: Is it possible to export from Excel to Scribus with VBA?  (Read 745 times)

chichirodriguez

  • Newbie
  • *
  • Posts: 2
  • Karma: 0
  • Scribus User
Is it possible to export from Excel to Scribus with VBA?
« 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?

dragonfly

  • Full Member
  • ***
  • Posts: 146
  • Karma: 0
  • Scribus User
Re: Is it possible to export from Excel to Scribus with VBA?
« Reply #1 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.

And in general explore the Scripter (python) functions in Scribus top tool bar.
« Last Edit: December 20, 2019, 04:22:00 pm by dragonfly »

dragonfly

  • Full Member
  • ***
  • Posts: 146
  • Karma: 0
  • Scribus User
Re: Is it possible to export from Excel to Scribus with VBA?
« Reply #2 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