James E. Lang wrote:
Not for the faint of heart!
I have seen no related discussions and this could very well be off
topic for this list so feel free to direct me to a more appropriate
list where I will gladly post the remainder of this message.
I have a five sheet spreadsheet. The contents of the first (1st) and
second (2nd) of the sheets are neither used nor changed in any manner
in this task.
I receive a text file as an attachment to an e-mail at least once a
week. The text file contains updated integer and date information for
the third (3rd) and fifth (5th) sheets. I can rather easily fully
automate everything that does not directly involve the spreadsheet. My
problem is how to get calc to automatically accept input data, perform
the spreadsheet update, print the defined print ranges in the third
(3rd) and fourth (4th) sheets, and save the updated spreadsheet. There
is data to be printed from both the 3rd and 4th sheets that is
calculated using the updated information.
When this was posted a few days ago, I assumed that either (1) someone
else would give you a usable response or (2) it involved things way
beyond my areas of competence. Since so far there haven't been many
takers, let me at least say a something and ask a few questions.
I routinely update certain spreadsheets using new data from the web. My
questions are:
1. Does "updating" mean replacing the data in sheets 3 and 5, or adding
data to sheets 3 and 5?
2. Do the print ranges need to be redefined each time, or do they
remain predefined?
3. After you've responded to these questions, if it looks to me like I
might have something to offer, would you be able to provide a copy of
the spreadsheet file and an email sample ('sanitized' if anything
confidential or proprietary is involved)?
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
