
I think i found the answer i just hope that this code works..... if you have any more suggestions feel free to reply thanks.
i've used this code below:
Function ChooseFile()
Dim Result
Dim IE : Set IE = CreateObject("InternetExplorer.Application")
With IE
.Visible = False
.Navigate("about:blank")
Do Until .ReadyState = 4 : Loop
With .Document
.Write "<html><body><input id='f' type='file'></body></html>"
With .All.f
.Focus
.Click
Result = .Value
End With
End With
.Quit
End With
Set IE = Nothing
ChooseFile = Result
End Function
MsgBox ChooseFile()
just...