CODEWITHSUNDEEP
excelexcel-addinsvba
Andreas
Andreas

Reputation: 23958

Excel add-in - get workbook name of "thisworkbook"

I can't get the name of the workbook when I use a add-in.

I'm trying to develop a add-in that runs each time you open Excel and reads the filename of the open file.

If the file name is XCFIL.SKV then do something...

This code should do it, but it doesn't. What am I missing?
The code stops and if I debug and press F8 it works fine, but it won't run on it's own.

Private Sub Workbook_Open()
    If ThisWorkbook.Name = "XCFIL.SKV" Then
        MsgBox "y"
    End If

End Sub

Upvotes: 1

Views: 1244

Answers (1)

Sgdva
Sgdva

Reputation: 2800

Background:
Based in this statement The code stops and if I debug and press F8 it works fine, but it won't run on it's own. I assume the problem relies on the speed of the processor that is not sync with the code (own experience).
Solution:
Since it is Excel and the problem seems to rely only in the opening of the instance itself, you may use Application wait or any of the other functions for this matter.
Further thoughts:
Life cycle comes to my mind in these kind of scenarios. This web page has a neat Lifecycle diagram of excel instance (attached since I will try to explain the scenario)

enter image description here

As you may see "Application" is the first cycle of the Excel application, followed by "Open" and after that "Workbook" object, it may happen that in this life cycle "worbook" has not been created when "Open" comes to play,hence, you need to wait until excel solves this.

Upvotes: 2

Related Questions