Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi I am using the script runtime to find and load file names into a listview
control, what I would like to do is be able to use a criteria like "bmp", "gif", "jpg", "tif", "wmf" instead of the user selecting singly. Any help would be much appreicated Charels |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Charel,
I've tried this code below rather than using Scripting Runtime: sub Dirof() dim mydir, r mydir = dir("c:*.bmp") do while mydir < "" r = r+1 cells(r,1).value = mydir mydir = dir loop end Sub you can do by code above unless you want to get sometingelse that can't be performed by dir() function, like retrieving filetype maybe... Regards, Halim vqthomf menuliskan: Hi I am using the script runtime to find and load file names into a listview control, what I would like to do is be able to use a criteria like "bmp", "gif", "jpg", "tif", "wmf" instead of the user selecting singly. Any help would be much appreicated Charels |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Scripting Help | Excel Discussion (Misc queries) | |||
VBA scripting | Excel Discussion (Misc queries) | |||
Scripting | Excel Discussion (Misc queries) | |||
Is scripting the way to go here? | Excel Programming | |||
References and Microsoft Scripting Runtime library | Excel Programming |