Creating multiple documents from Excel to Quark 4
Creating multiple documents from Excel to Quark 4
- Subject: Creating multiple documents from Excel to Quark 4
- From: bhudgens <email@hidden>
- Date: Sun, 23 Nov 2003 13:49:34 -0600
In an effort to increase my applescript skills I'm building a script
to create 40-65 small quark documents weekly with
similar/identical layout but different information in each ad. The
text styles are different within each text box in the quark doc.
Each ad also has a different picture. Then save the file with the
text from one of the quark text boxes as the file name.
Excel is somewhat recordedable but of quark course isn't . I'm
leaning towards just automatically copying each field and
pasting from excel to quark as opposed to importing via the get
text otption in quark. that seems like a linking nightmare with
each xl cell has varying lenghts in characters.
but importing does seems like it would be quicker (a faster
script?, that is)
this seem like it might help: ClipboardToXPressTags 0.3 from
Sal's page
The xl file is comprised of about 30 to 50 rows of the columns:
description, location, zip code and color for zip code " color
code", client name. I would also like to eventuallly incorporate the
photograph to each row
Would it be best to to create a new document for each ad or just
open a template with all the styles already set for each text box.
Of course there'll be some human editing afterward but that' s
more productive than doing all the repetitive stuff by hand.
Apologies for the length. Any advice would be greatly
appreciated. If anything, at least show some code on how to
open a template in quark w/ AS.
BTW: using OS 9.2 w/ Quark 4.1?
also, the xl file is created on Windows 2000 but I use MS Office
mac 2000 usually just loosing a few fractions in the conversion.
FYI
thanks
Blhudge
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.