Hello friends,
I have a module where I am clubbing two different worksheet and saving it to one workbook. If I have Office 2007 installed it is all working fine. The issue is with office 2010. If installled and if one worksheet is from .xls file and another is .xlsx file then it is creating a problem. the file is created properly but when I try to open that file it gives me a warning message that "the file you are opening is in diff format than specified by the extension". I am not sure what the problem is. I did not want this warning. Can anybody pls help me to know what the issue is and how to resolve it.
Attached the screenshot of the error message.
Thanks & Regards,
Girish Nehte
maybe this line helps if you write it before you will open that workbook
This is only idea because I never see Excel 2010Application.DisplayAlerts = False
BR
MaczaQ
Seeing the code would be better than a picture of a warning message.
What's clubbing? Do you mean combine?
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks