<p>I have a table in Access 2007 with 11,000 rows and about 20 columns. I want to create a form button that exports the table to an Excel sheet.  The code need to be VBA.</p>

<p>Any Ideas?</p>

You're probably better off using the
System.IO.DirectoryInfo
class to interpret your relative path. You can then pick off folder or file names using its members:
```
```
DirectoryInfo di = new DirectoryInfo("images/gringo/");
Console.Out.WriteLine(di.Name);
```
```
This will be much safer than any regexps you could use.