Lets say your timestamp looks like this:

d1 -16:08 03-11-2006

d2 -12:00 06-11-2006
Its a pain to figure out what the studio spits out as errors, so here is long story short, the code of it!

SessionStart = DateTime.ParseExact(d1, “HH:mm dd-MM-yyyy “, Nothing)

SessionEnd = DateTime.ParseExact(d2, “HH:mm dd-MM-yyyy “, Nothing)
TotalSession = DateDiff(DateInterval.Minute, SessionStart, SessionEnd)

Now, wasnt that simple??

Yeah , worth couple of hours of a headahce!

Share on Facebook

You Gotta Be Kiddin ME!!!!

After 3 hours of Visual Studio 2005 installation, then VSTO installation, and now this!!!!!

The error is:

“Programmatic access to the Microsoft Office Visual Basic for Applications project system could not be enabled. If Microsoft Office Excel is running,k it can prevent programmatic access from being enabled. Exit Word or Excel before opening or creating a project”

Anyways, here is the way to get this freaking error off the face of the monitor!!

• Open Word/Excel (2003) :Tools>
  Macro>
  Security >
  Trusted Publishers >
  Check against Trust access to Visual Basic Project
• Open Word (2007):Click on Top-most button for Office>
  WORD OPTIONS >
  Trust Center>
  Trust Center Settings>
  Check against Trust access to the VBA project object model>
  OK>
• Open Word/Excel (2007):Click on Top-most button for Office>
  Excel Options >
  Trust Center>
  Trust Center Settings>
  Macros Settings
  Check against Trust access to the VBA project object model>
  OK>
  OK
• Obvious enough exit Word & Excel & try

Share on Facebook