C#.NET 3.5 VS 2008 Excel 2007 Ribbon hide/show

[Wheels012]

Good morning. I have created an Excel add-in to display a Import tab with several buttons designed to run VBA macros. I only want this tab to display on the one workbook and not every instance of Excel. I am trying to test for the specific spreadsheet name, but the If statement keeps defaulting to the else condition. I have the following:

public RibbonCustom()
{
InitializeComponent();
this.tabImport.Visible = true;
//MessageBox.Show(Globals.ThisAddIn.Application.ThisWorkbook.FullName.ToString());
if (Globals.ThisAddIn.Application.ThisWorkbook.FullName.ToString() == "ImportFile.xlsm") { this.tabImport.Visible = true; }
else { this.tabImport.Visible = false; }
}

The MessageBox.Show doesn't work. Any suggestions? WHEELS

[Lost User]

string theName = Globals.ThisAddIn.Application.ThisWorkbook.FullName.ToString();
if (theName == "ImportFile.xlsm")
{
this.tabImport.Visible = true;
}
else
{
this.tabImport.Visible = false;
}

Put a breakpoint on the declaration of theName, and run the code. Somehow, those two strings aren't the same.

I are Troll :suss:

[Wheels012]

Hi Eddy. I found one issue. I was using >FullName instead of .Name, but unfortunately it didn't fix the issue. Trying to figure out a way that I can see the contents of the code (variable).

[Lost User]

Wheels012 wrote:

Trying to figure out a way that I can see the contents of the code (variable).

That would be debugging[^]? :)

I are Troll :suss:

[Wheels012]

Won't debug unfortunately.

[Lost User]

Wheels012 wrote:

Won't debug unfortunately.

Tried to attach the debugger to Excel? If you can't debug, then you'd be limited to something like logging to a textfile.

I are Troll :suss: