Hi All,

Do anyone have a solution/script for Uploading the Excel file in Local drive to QC Resources folder..??

TIA
Dwaraka.



Hi All, Do anyone have a solution/script for Uploading the Excel file in Local drive to QC Resour..

Answer / Saty Prakash Gond

Here's an example of a VBScript code that uploads an Excel file from the local drive to a specified QC Resources folder:nnDim objFSO, objFile, destFoldernSet objFSO = CreateObject("Scripting.FileSystemObject")nSet objFile = objFSO.CreateTextFile("C:path oyourfile.xls", 2)ndestFolder = "QC Resources"nSet objFolder = objFSO.GetFolder("servershare" & destFolder)nSet collFiles = objFolder.FilesnFor Each file In collFilesnIf LCase(Right(file.Name, 4)) = "xlsx" ThennobjFile.WriteLine file.Move destFolder & "" & file.NamenEnd IfnNextnobjFile.Close

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More VB Script Code Interview Questions

how to use the GetTickCount() properly and what is that procedure for?

1 Answers  


what is the full form of dim?

5 Answers  


how to write a program to accept names and marks of 10 students from the user and display the names and markes of only the passed students. Marks greater than or equal to 35 is considered as pass.

4 Answers  


Keep all the contract numbers in a array and make a loop . Example:12134,5678,91011,1214125 are contract numbers.

1 Answers  


how to use textfile for taking value for parametrization instead of datatable or global sheet

3 Answers  


How to Check if a string is alphanumeric or not using VB Script

1 Answers  


Hi All, Do anyone have a solution/script for Uploading the Excel file in Local drive to QC Resources folder..?? TIA Dwaraka.

1 Answers   NHS,


How to write QTP script to exit from loop? suppose I am using parametize functionality and in data table there is 3 password corresponding 3 username and second pasword is wrong. Now I want to exit after completion of second iteration and continue with third iteration.

2 Answers  


How to change winform look?

1 Answers  


what does mbln in mblnrects mean? my boolean?

1 Answers  


In QTP one function can return more than one value?

3 Answers   Mind Tree,


Hi, My name is satish kumar dega I am learing QTP I have one doubt. I need to count the radio buttons in a particular page. In QTP how to write descriptive progming and how I will get all the radiobuttons count.In a paricular page having two WebRadioGroups under each group having 3 radiobuttons.I need to count all the radio buttons could you plz help me regarding this one

1 Answers  


Categories
  • PHP Code Interview Questions PHP Code (33)
  • JSP Code Interview Questions JSP Code (6)
  • ASP Code Interview Questions ASP Code (5)
  • CGI Perl Code Interview Questions CGI Perl Code (3)
  • JavaScript Code Interview Questions JavaScript Code (63)
  • VB Script Code Interview Questions VB Script Code (20)
  • Shell Script Code Interview Questions Shell Script Code (31)
  • Python Code Interview Questions Python Code (34)
  • WinRunner Code Interview Questions WinRunner Code (1)
  • HTML DHTML XHTML Code Interview Questions HTML DHTML XHTML Code (13)
  • XML Interview Questions XML (43)
  • Scripts_Markup Code AllOther Interview Questions Scripts_Markup Code AllOther (5)