Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I use scopefolders in excel macro in windows xp
I have been trying to get directory and file information with an excel macro
using filesearch, the searchscope and search folders but access seems to be restricted in windows xp. Any ideas? I need the macro to search a folder and sub folders and return the path and file names. But I am having problems with even running the examples in Help. thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I use scopefolders in excel macro in windows xp
to the best of my knowledge, it is not restricted in Windows XP. The
examples run for me. an alternative is to use Dir with recursive calls. -- Regards, Tom Ogilvy "mike_cutting-edge" wrote in message ... I have been trying to get directory and file information with an excel macro using filesearch, the searchscope and search folders but access seems to be restricted in windows xp. Any ideas? I need the macro to search a folder and sub folders and return the path and file names. But I am having problems with even running the examples in Help. thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I use scopefolders in excel macro in windows xp
here are some other references:
These are polished and should be easy to understand. http://support.microsoft.com/default...b;en-us;185476 How To Search Directories to Find or List Files this is a link to that article for the third method http://support.microsoft.com/kb/185601/EN-US/ HOW TO: Recursively Search Directories by Using FileSystemObject Some other DIR command approaches: Recursive Code written by me - I was searching a directory structure for workbooks with links and listing this structure on a worksheet - it creates and indented list on a worksheet, so the structure is somewhat maintained. It is pretty rough as there are a lot of debugging statements mostly commented out. It uses a recursive approach to walk the directory structure http://groups.google.co.uk/groups?se...&output=gplain (Obviously a first draft -- never polished.) Bill Manville also wrote one and this has been posted by others many times: http://groups.google.co.uk/groups?se...utput= gplain ---------- Here is some nice code from Randy Birch to do a recursive filesearch with the Windows API: http://vbnet.mvps.org/index.html?cod...es_minimal.htm -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... to the best of my knowledge, it is not restricted in Windows XP. The examples run for me. an alternative is to use Dir with recursive calls. -- Regards, Tom Ogilvy "mike_cutting-edge" wrote in message ... I have been trying to get directory and file information with an excel macro using filesearch, the searchscope and search folders but access seems to be restricted in windows xp. Any ideas? I need the macro to search a folder and sub folders and return the path and file names. But I am having problems with even running the examples in Help. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Macro use in Windows 7 Home | Excel Discussion (Misc queries) | |||
can i record a macro from excel to invvoke another windows application | Excel Discussion (Misc queries) | |||
How do I set up a macro to turn on Windows in Taskbar in Excel 200 | Excel Discussion (Misc queries) | |||
Running a Excel Macro from Windows Scheduler | Excel Programming | |||
Can an Excel macro be converted into a VBdotnet Windows application? | Excel Programming |