Hi Anil,

As mentioned above, copyObjectsToExcelSheet is not a VBA function but a function created by author. Like a sub procedure, a function is used to perform an assignment. We can call them whenever and any time we want. Seems you have copied only part of the code and tried in your application. Below thread has some discussion on the same topic.

Error exporting to excel with macro.