Application.Filepath in Excel 2007

[fridaywizard]

I've recently got Excel 2007 installed at my work. I had a few macros that used application.filepath.

As this is no longer available in Excel 2007 I wanted to know if there was a work around that someone could share?

More specifically, What I want the code to do is to look in a folder (for sake of arguement "C:\") and produce a list of the filenames in Column A of my worksheet (Sheet1). Obviously without using application.filepath...

Thanks in advance!

 

[Firefly2012]

Hi

I take it you mean Application.FileSearch? There seems to be some options here:

http://www.mrexcel.com/forum/showthread.php?t=268046

 

[fridaywizard]

Oops, yes sorry I meant fileSEARCH