> Dim strSep As String

Just take that out it shouldn't be in there. This has to do with systems
that have a
different path separator, like /. As you only will be running it on Windows
you don't
have to worry about it.

RBS


"Alf" <Alf.2999lb_1150059002.645@excelforum-nospam.com> wrote in message
news:Alf.2999lb_1150059002.645@excelforum-nospam.com...
>
> Thanks again RS fore the help you have given me.
>
> I'm still struggeling with your code trying to understand it all but it
> will take some time before I do. So I'm pleased that SQL and ADO metode
> are slower since I have much less chance of understanding that. But it
> was very kind of you to spend time and effort on my behalf.
>
> I had a look at link you gave me and realised that this is way above my
> present VB knowledge.
>
> In your code you declaired a variabel:
>
> Dim strSep As String
>
> I can't see any reson fore it and the macro runs fine without it. I
> guess you used this macro before and modified it to suit my needs. So
> strSep is a variabel not needed im my case or??
>
>
> --
> Alf
> ------------------------------------------------------------------------
> Alf's Profile:
> http://www.excelforum.com/member.php...fo&userid=7112
> View this thread: http://www.excelforum.com/showthread...hreadid=550766
>