|
> 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 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.