Consulting

Results 1 to 3 of 3

Thread: createobject("ExcelApplication") 2010/2013

  1. 03-18-2013, 12:57 PM #1
    stanl
    stanl is offline
    VBAX Master stanl's Avatar
    Joined
    Jan 2005
    Posts
    1,141
    Location

    createobject("ExcelApplication") 2010/2013

    I have googled this a lot and found a few posts about renaming file names and other stuff that really screws up the registry.... but

    assuming: you have both Office 2010 and 2013 installed. Is there a way when making an ADO call to Excel.Application to specify to load either Excel 2010 or 2013 depending upon the file to be opened?
    Reply With Quote Reply With Quote
  2. 03-19-2013, 09:55 PM #2
    macropod
    macropod is offline
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    4,435
    Location
    If you have Excel 2013 installed, why does it matter which Excel version you open the file with? Excel 2013 can work with earlier Excel versions' files.
    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]
    Reply With Quote Reply With Quote
  3. 03-20-2013, 06:00 AM #3
    Aflatoon
    Aflatoon is offline
    VBAX Master Aflatoon's Avatar
    Joined
    Sep 2009
    Location
    UK
    Posts
    1,720
    Location
    No, it's not - what does ADO have to do with CreateObject("Excel.Application")?
    Be as you wish to seem
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules