Is your question how to read the data in excel or how to place into inDesign
How to read it. Sort of treating it as a database of some kind.
So i could have an excel file on my hard drive then fill up textframes with values from the excel file.
Pseudo code would be something like this
Read excel file
Obviously that's just imaginary syntax! But i hope it explains what i want to do.
1 person found this helpful
Trying to do this again, now in Visual Basic. This works perfectly.
Set myInDesign = CreateObject("InDesign.Application")
Set myDocument = myInDesign.ActiveDocument
Set myPages = myDocument.Pages
Set myExcel = CreateObject("Excel.Application")
Set objWorkbook = myExcel.Workbooks.Open("C:\Downloads\links.xls")
Set objSheet = myExcel.ActiveWorkbook.WorkSheets(1)
msgbox ( value_one )
Amazing stuff. What a buzz