+ Reply to Thread
Results 1 to 3 of 3

CreateObject("Excel.Application") doesnt work in Office 365

  1. #1
    Forum Contributor
    Join Date
    01-13-2009
    Location
    Mumbai
    MS-Off Ver
    Excel 2003, 2007
    Posts
    168

    CreateObject("Excel.Application") doesnt work in Office 365

    Hi All,

    I have a VBS file through which I create an excel applciation and run a macro. This works fine on all the systems with various versions on excel, however it errors out when I run it in a system that is installed with Office 365. It fails at the CreateObject line and says "activex component can't create object excel.application"

    Is it something to do with the version of excel or is there any way around?

    Can anyone please advice?

    Thanks,
    Vaibhav

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: CreateObject("Excel.Application") doesnt work in Office 365

    Hi Vaibhav,

    There is a 365 forum, it's relatively new - you should, probably, move this thread to that forum.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    06-30-2016
    Location
    India
    MS-Off Ver
    365
    Posts
    1

    Re: CreateObject("Excel.Application") doesnt work in Office 365

    In Office 365 you need to turn on "Enable all macros" from File->Options>Trust Center. Restart Outlook post this. It should get it working.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. User Specific - CreateObject("Word.Application") Fails
    By Thanley in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-30-2013, 06:04 PM
  2. [SOLVED] Set OutApp = CreateObject("Outlook.Application") - Runtime error 429
    By Buffyslay in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-29-2012, 09:44 AM
  3. CreateObject("Excel.Application")
    By Olivia Towery in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-11-2006, 07:10 PM
  4. [SOLVED] Permission denied in CreateObject(Excel.Application")
    By Leo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-15-2005, 01:10 PM
  5. ASP: CreateObject("Excel.Application") IIS 6.0 Win2003
    By Mau in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-20-2005, 07:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1