I want to create Excel object on another machine which is in network i written

I want to create Excel object on another machine which is
in network i written the code "Set se=createobject
("Excel.Application","\\ankur")"here \\ankur is the name of
that machine but i m getting the error of permission denied
create object can anybody help me

Question Posted / ankur_jain

2 Answers
4520 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I want to create Excel object on another machine which is in network i written the code "Set ..

Answer / jagadish

I do not have exact syntax for that but, I'm 100% sure that
you have to provide IP address of the remote system also you
need permission of that remote system to perform operation
on that

Is This Answer Correct ?

0 Yes

0 No

I want to create Excel object on another machine which is in network i written the code "Set ..

Answer / kazi

Hi Ankur,
if showing error like that need to be admin right just
inform to your admin deppt.he can give admin right.

Is This Answer Correct ?

0 Yes

2 No

Post New Answer

More QTP Interview Questions

What is difference between shared and local object repository?

0 Answers

In a web site, Protocal has been changed http: to https: what is your approach?

2 Answers

how are environment variables used in real time projects (testing)?what answer should be given about this in interview.need real time explanation breifly?thnx in advance.

2 Answers

How do you export an output to a excel sheet? Ex: I get my answer by using Msgbox"..." &R. How do I displayed the result of the Msgbox (such as R) to an excel sheet? Please let me know.Thanks

2 Answers ADC,

tell me exact differenceb bw qtp and selenium?(could not tell open soure and licennce? difference in usage and technical difference?

0 Answers

I have a tool for automation testing (eg:qtp).I have two functionality(A & B) to test.A is tested once in a year. B is tested everyday. At present i have the money and resource availability to automate only one functionality.Which one will u suggest and why?

3 Answers Wipro,

What is keyword view in qtp?

0 Answers

How to build scripts that access data from external sources?

0 Answers

What are SetToProperty, SetRoProperty, GetToProperty scripting?

2 Answers

I am verifying the actual vs the input value to make sure that they been entered correctly. In the Global Sheet I have a column called Customer with the multiple names in each row and now I am trying to capture the value during runtime under the column name Customer_in_Apps. Somewhat it works but during runtime the values are being stored in each column vs each row i.e., Customer_in_Apps, Customer_in_Apps1. Automatically it add columns instead of rows. row=datatable.getsheet("Global").GetRowCount for x=1 to row datatable.getsheet("Global").SetCurrentRow(x) Window("Customer Desktop").Window("Customer Tracking (Privacy").WinObject("TreeView20WndClass").Click 92,244 runtimevalue = .VbTreeView("vbname:=AppServerTree").GetROProperty("Selectio n") Val1=Datatable.Value("Customer",dtGlobalSheet) Val2 = Datatable.GlobalSheet.AddParameter("Customer_in _Apps",runtimevalue) If (trim(Val2)=trim(Val1)) Then Reporter.ReportEvent micPass, "Customer validation successful", "Actual Value: " &Val1&vbcrlf& "Customer Value: " &_Val2 else Reporter.ReportEvent micFail, "Customer validation unsuccessful", "Actual Value: " &Val1&vbcrlf& "Customer Value: " &Val2 End If Next

3 Answers

diff between winrunner and qtp

1 Answers Wipro,

I am using environment variable xml to give credenatials for login into unix. Is there any way we cam mask the password in the xml?

1 Answers

For more QTP Interview Questions Click Here