Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
reading folder
#3
Solved: 12 Years, 10 Months, 3 Weeks ago
As there will only ever be one file in the folder this is what i did, guess i could drop the for loop from this example.
Code:
Dim oFolder, sOut, oFSO, callnr
Set oFSO = CreateObject("Scripting.FileSystemObject")
Set oFolder = oFSO.GetFolder("C:\calls")
Set oFilesCol = oFolder.Files
For Each oFile in oFilesCol
'MsgBox oFile.Name, oFile.Size
callnr = oFile.Name
msgbox callnr
Next

thanks!
Reply


Messages In This Thread
reading folder - by jove1776 - 08-25-2010, 07:14 PM
RE: reading folder - by supputuri - 08-25-2010, 07:45 PM
RE: reading folder - by iamsekhar - 08-30-2010, 02:33 PM
RE: reading folder - by jove1776 - 08-25-2010, 08:18 PM
RE: reading folder - by supputuri - 08-25-2010, 09:34 PM
RE: reading folder - by jove1776 - 08-26-2010, 01:36 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Reading Global Sheet's DataTable Value Bhuvana 0 2,016 01-05-2020, 10:03 PM
Last Post: Bhuvana
  Executing via create "RES"xx folder? nishitd 0 1,644 03-07-2018, 01:09 AM
Last Post: nishitd
  Reading Value from Java Table arjun.singh 8 25,624 10-11-2017, 02:51 PM
Last Post: sivaji
  Reading data from excel sheet serenediva 1 10,409 03-03-2017, 10:07 AM
Last Post: vinod123
  code for validation to create a sub folder smiley 0 1,833 10-19-2016, 10:08 PM
Last Post: smiley

Forum Jump:


Users browsing this thread: 1 Guest(s)