Feed2Mail notification - new post on Excel IT Pro Discussions Forum
VBA: Related to Loading an .xlam file
The following code works fine for office 2007
Set objExcel = CreateObject("Excel.Application")
'This will pick the abc.xlam file irrespective of the Office as well as windows version.
objExcel.Workbooks.Open (objExcel.LibraryPath & "\abc.xlam")--After this I will load an excel file.
But when i execute the same code in office 2010, the abc.xlam file is not getting loaded.
It has some custom worksheet functions, which are not getting displayed.
Any suggestions in this regard is highly appreciated.
Thanks,
Krishna
