extract file name from data import

[Raiko]

Hello MCers,

does anybody know a way to pry the filename from the data import wizzard?

Thanks in advance

Raiko

[TomGutman]

Do it the other way. Make the file name a parameter, then you will always know what it is.
__________________
� � � � Tom Gutman

[Raiko]

Hello Tom,

not exactly what I was looking for but a possibility

Thanks

Raiko

[TomGutman]

The data import wizard doesn't find a name. It uses a name that you provide, one way or another. If you want to know the name, just provide it in a way that you can remember and find. If the issue is the use of the wizard's browse facility, you can accomplish that using Xavier's file browsing scripts (based on list box selections).
__________________
� � � � Tom Gutman

[ptc-1368288]

On 6/23/2009 5:10:21 AM, raiko01 wrote:
>Hello MCers,
>
>does anybody know a way to pry
>the filename from the data
>import wizzard?
>
>Thanks in advance
>
>Raiko
_______________________________

Not clear what you want. You can have a script to scan all the file types and locate their directory. If you know the name of a work sheet lost in the hay pile, you can search if it does exist and where .

jmG