Relative Content

Tag Archive for excelvbadictionaryworksheet

Save a Worksheet as an Object Attribute

I have an Employee class with properties Name and Worksheet for the purpose of compiling Employees Overtime sheets. The following code iterates through a folder, creates an Employee and adds it to a Dictionary. My problem is that once we’re out of the Loop, the Worksheet becomes a generic Object, so I can’t do any operation on it!