🚀 go-pugleaf

See if this helps you it is a code snipet only but it should get you started. There are many ways to get data from excel, this examples Illstrates using a pre-setup pivot table.


	REM #1 I do all of my scripting in Excel thus I'm leaving out a lot of coding to load Excel

	REM I have a worksheet named Table with a PivotTable named chart_area
	REM The pivot table has columns named Quarter, Sum of rba_ex, Under Construction, Net Absorption, Office Vacancy
	REM The pivot table has 2 rows, 1 for each of two quarters
	REM I have the current quarter value entered into the variable current_qtr
	REM I want to pull the Sum of rba_ex as my inventory and
	REM chart_area is the name of my pivot table
myinventory = Worksheets("Table").PivotTables("chart_area") _
    .GetData("'Sum of rba_ex' 'Quarter' '" & current_qtr & "'")

	REM I want to format the inventory a number with commas
myinventory = Format(myinventory, "#,##0")

	REM move the data to Illustrator
	REM I've already loaded Illustrator as appRef
Set targetDocument = appRef.ActiveDocument
	REM In my targetdocument I have a text item labeled Current Inventory
	REM So all I do is replace the contents
targetDocument.TextArtItems("Current Inventor").Contents = myinventory

Let me know if that helps,
iolaire