I've developed a template for clients to load data daily from an Excel file and then process it in VBA and produce graphs with a single click. It works fine on my Windows XP system with Office 2003 when I load an xls file. But the client is runningOffice 2007 and receives the file from their Lab system in xlsx format, and the 2003 template can't open the file automatically. It will work for them if they first open the downloaded file in A2007 and save it down to.xls format, but we're trying toeliminate that step since they have to do it daily.I can think of some possible solutions:1. The obvious one: upgrade to Office 2007 myself. But I can't do that for at least a few months.2. Have the client change the download format from their lab system to Excel 2003.
How To Install Vba Application
I've asked about that but haven't gotten a reply yet.3. Have them save my template in Excel 2007.4. Have their IT dept install the compatibility pack.The code is very simple: Workbooks.Open FileName:=PathFileNot having Office 2007 I can't test any of these myself.If anyone knows how to do this, I would really appreciate their help.