Is there a way to pull Text from an Excel File via a Script? - Not a Variable Data Process
Currently, I have to copy data from an online PDF into an XSLM Exel file.
Then using a Macro I am able to pull and organize the needed data into a column L15:L32
Last, back in my Illustrator file I have Tethered Text Boxes, the 1st one contains the text "xxxx", I select that and "CTRL+V" to paste in the needed data.
Is it possible for a Script to grab the data from the active tab in Excel and do a Find and Replace if that script knows the name and location of the Excel file?
C:\Users\Public\Spec Work.xlsm
Any and all feedback welcome on this 🙂
