[AccessD] Access Application Obtaining Data fromExcel-Another User Has Excel File Opened

Mark,

Good point.  I had not thought of this.

Thanks for the help/advice

Brad 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com on behalf of Mark Simms
Sent: Mon 2/11/2013 6:26 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access Application Obtaining Data fromExcel-Another User Has Excel File Opened
 
Brad - the only downside to the super simple file copy approach:
It may not have been recently "saved". You would be getting the copy of the
workbook the user opened early that day.

However, even with automation, to get the most recent data, you would need
the workbook to be established as "shared" so that you can then do the
"Save" for them and then making a "Save As" under a different name.



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.