Hi all,
could some one help me with this project....I have a command button which I want when being clicked to open a folder situating on this path: \\Server\Chef\Fakturi\Donau\2006
For this part i tired the following code, but it gives me an error:
saying that variable not defined, and when I use it on other pc in works...Where could be the problem?
And second question....when i make this command button works how to tell it, when opens the folder to filter only those files which are equal to the value of cell B3...
Is this possible by the way?
Thanks you,
Iva
could some one help me with this project....I have a command button which I want when being clicked to open a folder situating on this path: \\Server\Chef\Fakturi\Donau\2006
For this part i tired the following code, but it gives me an error:
Code:
Private Sub CommandButton1_Click()
Status = Shell("Explorer.exe /n, /n, " & "\\Server\Chef\Fakturi\Donau\2006 ", vbMaximizedFocus)
End Sub
saying that variable not defined, and when I use it on other pc in works...Where could be the problem?
And second question....when i make this command button works how to tell it, when opens the folder to filter only those files which are equal to the value of cell B3...
Is this possible by the way?
Thanks you,
Iva