Re: Designating a different worksheet in Xcel depending on the current Quark document.
Re: Designating a different worksheet in Xcel depending on the current Quark document.
- Subject: Re: Designating a different worksheet in Xcel depending on the current Quark document.
- From: email@hidden
- Date: Tue, 24 Apr 2001 09:21:09 -0600
I have several sets of fact sheets that, on a quarterly basis, I go through and
update the information. With the help of some of you I was able to add to a
script that I wrote to open a whole set of fact sheets and make global changes.
I am now trying to add additional tasks to this script. I now want it to update
more information in the Quark doc from data provided in an Xcel spread sheet. I
can write a script that will work in a loop that will ask for the Quark document
and open it, then ask for the data sheet to update from then update, save, close
and then start over. I have a bigger plan. I receive the data in a single Excel
spreadsheet with the data for each fact sheet with its own named worksheet. How
do I get the script to know what worksheet to uses depending on which Quark
document is active? Is there a way to have the script get the name of the active
Quark doc and then use that to designate the correct worksheet the data needs to
be copied from?