adspace


  1. Categories >> Code Snippets >> Scripts_Markup Code >> VB Script Code
  2. Suggest New Category

Hi All,

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

TIA
Dwaraka.

Question Posted / Saty Prakash Gond

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

No New Questions to Answer in this Category !!    You can

Post New Questions

Answer Questions in Different Category