Question Determine which cells are currency in Excel

[bendy_leather]

Hello all, I am very new to vb.net and am looking at writing some code that will seek out all currency cells in an excel workbook and replace the number formatting with a new currency symbol.

In VBA i use VARTYPE(cell address) and it would return a 6 if it is a currency cell. When i try doing the same in vb.net i get 'object' returned every time (as my xlRng variable is set as an Excel.Range). I understand why it's doing this but i cant work out how to determine whether the excel range is currency or not.

Is this even possible? Any advice would be sincerely appreciated. I apologise if this is a stupid question!

Many thanks.

 

[jmcilhinney]

Are you looking to do this via Office Interop, i.e. effectively remote controlling an instance of Excel, or simply by working with the data directly?

 

[JohnH]

Check cell.Style.Name