> 1. Rt-click the sheet tab - view code to take you into the sheet module
>
[quoted text clipped - 32 lines]
>
> Regards,
"salonowiec" <boguslaw.knapik@gmail.com> wrote in message
<snip>
> In 2 - after
> If Not vFile = False Then
> I'm getting error Type mismatch
change
> > vFile = Application.GetOpenFilename(sFileFilter, sTitle)
to
vFile = Application.GetOpenFilename(sFileFilter, , sTitle)
'' or with named arguments
' vFile = Application.GetOpenFilename( _
FileFilter:=sFileFilter, _
Title:=sTitle)
FWIW, originally my code had the named arguments which I striped out so the
code could fit in one line in the post, oh well....
Regards,
Peter T
salonowiec - 14 Mar 2008 13:19 GMT
> "salonowiec" <boguslaw.kna...@gmail.com> wrote in message
>
[quoted text clipped - 22 lines]
> Regards,
> Peter T
It's O.K. now, thank you very much...