Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

LinkBack Thread Tools Display Modes
Old 03-28-2019, 09:52 AM
Charlie_ Charlie_ is offline Windows 7 64bit Office 2016
Join Date: Mar 2019
Posts: 1
Charlie_ is on a distinguished road
Post Excel 2016 cannot open my xls file

I'm currently using a VBA to extract data from MS Project into excel, using ".xls" extension. I've also, tried using ".xlsx" extensions but for some reason, MS office 2016 will not open the extracted data. I keep getting notice that the file has been corrupted. I've tried to open and repair but no luck. anyone knows of any work around?


Last edited by Charlie_; 03-28-2019 at 09:53 AM. Reason: spelling error
Reply With Quote
Old 04-08-2019, 03:28 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
Join Date: Oct 2015
Posts: 165
Debaser is on a distinguished road

What's the VBA you are using for the extract?
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to open text (or csv) file from Excel VBA without Excel messing up with dates ArviLaanemets Excel Programming 1 06-13-2017 11:31 PM
open csv files with Excel 2016 albyefield Excel 0 05-10-2017 06:18 AM
When i open excel one always the same excel file open(empty XLstart folder) marcin4991 Excel 2 08-29-2016 02:36 AM
Office 2016 - open Excel file in compatibility mode for Office 2013 or earlier wpryan Excel 0 02-21-2016 12:50 AM
excel cannot open the file .xlsx because the file format or file extension is not val teddysika Excel 1 11-22-2012 06:06 AM

All times are GMT -7. The time now is 10:43 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft