Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 03-28-2019, 09:52 AM
Charlie_ Charlie_ is offline Windows 7 64bit Office 2016
Novice
 
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?

thanks

Last edited by Charlie_; 03-28-2019 at 09:53 AM. Reason: spelling error
Reply With Quote
  #2  
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
Default

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

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.
MSOfficeForums.com is not affiliated with Microsoft