Compile error Question

[mayoung]

Can someone please tell me how I can make this work Thank You?

 

[RoryA]

Change the name of your routine to something other than ActiveWorkbook.

 

[t0ny84]

If the macro is running in this workbook you could try:
workbook.name

Is the workbook called dataminerfile.XML or dataminerfile.XML.xyz?

 

[mayoung]

Change the name of your routine to something other than ActiveWorkbook.

I am creating my first Addin and this code is in the addin. How do I refer to the open workbook named DataminerFile.xml I want to make sure this code only runs in this workbook only?

 

[mayoung]

If the macro is running in this workbook you could try:
workbook.name

Is the workbook called dataminerfile.XML or dataminerfile.XML.xyz?

I am creating my first Addin and this code is in the addin. How do I refer to the open workbook named DataminerFile.xml I want to make sure this code only runs when this workbook is active not any other workbook that may be open if the button to run the macro is pressed?

 

[RoryA]

If it's called DataminerFile.xml, then you can use Workbooks("DataminerFile.xml"). If your code also opens the workbook, you could store an object reference to it at that point.