02-22-2013, 09:57 AM
------------------------------------------------------------
Hi Selvam,
Thanks for the reply!
Below code isn't working still and throwing following errors-
Scenario1:
1.Access Denied: objhttp.send
2.Object required: 'mysheet'
Function file: C:\CCAMSauto\Links.qfl
Line (12): " mysheet.cells(roc+1,1)=nam".
Scenario2: When i copy the same function in script & use 'On Error resume next in the function' data is written to excel sheet.But when i dont use exception handling it throws above errors.
Scenario3: When i use exception handing in the function and have teh function in func library, script runs but data is not written to excel sheet.
Hi Selvam,
Thanks for the reply!
Below code isn't working still and throwing following errors-
Scenario1:
1.Access Denied: objhttp.send
2.Object required: 'mysheet'
Function file: C:\CCAMSauto\Links.qfl
Line (12): " mysheet.cells(roc+1,1)=nam".
Scenario2: When i copy the same function in script & use 'On Error resume next in the function' data is written to excel sheet.But when i dont use exception handling it throws above errors.
Scenario3: When i use exception handing in the function and have teh function in func library, script runs but data is not written to excel sheet.