Hi, I need to use the Range method for CurrentWorkSheet object to get the NumberFormat property for a specific cell but worksheet object returns null value for some reason. Did anyone else come across this scenario?
Any help/lead is appreciated. Thanks.
PS: in the screenshot, wbJournal variable is a WorkbookApplication object obtained as output from Excel Application Scope activity.
The thing is, I suppose Excel Application Scope simply won’t have the CurrentWorksheet set due to the fact that you don’t specify any concrete sheet to be worked on when you invoke it.