× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



> Don't assume that these excel sheets are very transportable. I'm pretty
darn
> sure that the Excel query (it is not an AS400 query stored in excel btw,
> duh)
> is stored on the users disk and is not a part of the sheet itself, and
the
> autoupdate function uses ODBC, and a specific driver name, so that if you
> did send it to another user, they would have to have the same ODBC driver
> name in order to update the spreadsheet, and that's assuming no query.

The assumption of the original request in the thread was that the
spreadsheet would update the data AND THEN email itself.  So, since the
data has already been refreshed, an ODBC driver would not be necessary on
the receiving end - but could be created if the receiver then wanted the
ability to refresh when needed.

> Now then, if you were to update it locally (using auto-open?) and have
full
> Adobe Acrobat and were to use Adobe's "convert to PDF and email"
> function..............that might have possibilities..............

It's not really necessary.  We have a "Current Orders On Credit Hold"
spreadsheet that this code was lifted from.  In this case, the A/R manager
opens the spreadsheet, pushes a button to refresh the data, pushes another
button to email.

NOTE: not included in the original code was a note that it is written to
email another spreadsheet - NOT itself.  This logic is due to not wanting
to email the Controls sheet and include the macro logic; the originating
spreadsheet makes a copy of itself including only the data spreadsheet and
then mails THAT spreadsheet.  But it could be easily be changed to mail
itself.

Bill



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.