[AccessD] EXCEL OT

[Darryl Collins]

Hi Martin,

You could also ask this on the Excel-L

--------------------------------------------------------------------------
The EXCEL-L list is hosted on L-Soft international's LISTSERV(R) software running on Microsoft Windows Server 2008 R2. For subscription/signoff info and archives, see http://peach.ease.lsoft.com/archives/excel-l.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=EXCEL-L

Cheers
Darryl.





-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid
Sent: Monday, 21 March 2016 8:08 PM
To: 'Access Developers discussion and problem solving (accessd at databaseadvisors.com)' <accessd at databaseadvisors.com>
Subject: [AccessD] EXCEL OT

Morning All

Would anyone have an example of PowerShell opening an Excel workbook and then resaving it with the same name? We need to be 100% sure 2 workbooks we get are Excel 97-2003 format before we run some import code on them.

There would be no user intervention as the script would run automatically. The code will error if they are in the incorrect formation and we want to avoid this happening and also avoid having to manually resave them. We have no control over the source who continually insist they are the correct type.

Best Wishes
Martin



Martin W Reid
Business Services Team Leader
Queen's University Belfast
Information Services
50 Elmwood Avenue
Belfast BT9 6AZ

Tel: +44(0)28 9097 6174
Email: mwp.reid at qub.ac.uk

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