I currently have both Excel 2010 and Excel 2013 installed on my computer. I have a macro that opens four Excel workbooks. Is there any code that I can include in the macro to force the four files to be opened in Excel 2010 and not in Excel 2013? Also posted at this link: http://www.mrexcel.com/forum/excel-q...el-2010-a.html
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Set XL2010 = CreateObject("excel.application.14")
XL2010.Workbooks.Open "C:/test.xlsx"
XL2010.Visible = True
Frob first, tweak later
Much appreciated. Worked like a charm.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks