WHY this allert on Set OBJXL = CreateObject("Excel.Application")

User avatar
sal21
PlatinumLounger
Posts: 4519
Joined: 26 Apr 2010, 17:36

WHY this allert on Set OBJXL = CreateObject("Excel.Application")

Post by sal21 »

part of code:

...

Code: Select all


 Set OBJXL = CreateObject("Excel.Application")'<<<< here
        
        Set WBXL = OBJXL.Workbooks.Open(STRPATHXLS)
        OBJXL.Visible = True

        Set WSXL = WBXL.Sheets("REPORT")
        ...
if i click on retry the window hide.....
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 79561
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: WHY this allert on Set OBJXL = CreateObject("Excel.Application")

Post by HansV »

Perhaps Excel is already running? You can check by starting Task Manager and looking for EXCEL.EXE in the Details tab.
Best wishes,
Hans

snb
5StarLounger
Posts: 617
Joined: 14 Nov 2012, 16:06

Re: WHY this allert on Set OBJXL = CreateObject("Excel.Application")

Post by snb »

BTW. GetObject(fullpath) suffices.

User avatar
sal21
PlatinumLounger
Posts: 4519
Joined: 26 Apr 2010, 17:36

Re: WHY this allert on Set OBJXL = CreateObject("Excel.Application")

Post by sal21 »

snb wrote:
29 Aug 2024, 15:28
BTW. GetObject(fullpath) suffices.
???