I've been tasked to translate a C# program to VB. (Dot Net 2.0.)
I'm starting from scratch with no documentation and I'm trying to understand
what the original programmer did. (The 'original programmer' is conveniently
off on vacation so I can't ask him.) The program deals in some way with Excel
spreadsheets. There is a line of code in the program:
CurSheet =
(Microsoft.Office.Interop.Excel.Worksheet)WB.Works heets.get_Item(driverName);
where CurSheet is 'Microsoft.Office.Interop.Excel.Worksheet '.
What I don't understand is that get_Item call. It leads to something
labeled (in the VS tab) as 'Sheets [from metadata]' which in turn is
apparently a file within directory 'c:\temp\5232$Excel.dll$v1.1.4322. The
file name itself is Microsoft.Office.Interop.Excel.Sheets.cs.
I have no idea how or why this file was generated. Has anyone else out
there ever seen anything like this? What techniques are being used here?