Problem with excel object after upgrade to 2007
We have a simple UI used for creating reports by technicians. After upgrading to 2007 office the macros in the excel sheet aren't executing correctly. Is there a setting to the excel object that can disable macro security?
<font class="small">Code:</font><hr /><pre>Set xlObj = CreateObject("Excel.application")
xlObj.Visible = True
Re: Problem with excel object after upgrade to 2007
If you havent used 2007 prior to this. The file extensions for Excel 2007 are different.
.xls(2003)<-> .xlsx (2007)
Though as MS supports backwards compatibility, thie should work.
You will need to enable macros. Open the file and make sure that the macros are run as expected. I remember enabling it explicitly. Been a while though.
They actually have a separate extentsion for macros..xlsm???? Though I continued working with .xls extensions.