Excel - Get current active sheet name

Help Studio
1

Hi all,

I need to get the current active sheet name when opening an excel file. This sheet name could be different for each workbook that is opened.

I tried using the excel application scope, assigning the output workbook… then assigning a str → wb.CurrentWorksheet.Name

however I am receiving the error: Assign: Object reference not set to an instance of an object.

I see a lot of questions on this, but no solution yet.

2

Hi,

The following might help you.

Regards,

3

Thank you, works a charm!