QTP not recognising macro

[krr]

Mayuri and Rita,

Instead of recording if you want to Run a macro you need to work with Excel Object. For Example it goes like this:

Code:

set ex=CreateObject("Excel.Application")
set wb=ex.Workbooks.add
set ws=wb.Sheets("Sheet1")
wb.RunAutoMacro ''''what ever the macro you want to Run which is inbuilt.

Also there are other methods to work with like:
UpdateLinks
Openlinks
Setlinksondata
so on and so far


Try this and let me know if it works.