Unable to access shared drive in VB.NET

Question

0.00/5 (No votes)

See more:

I am using "OpenFileDialog" to open an excel file from shared drive in vb.net.

Now this code is working perfectly on my computer.
but when i am creating setup of this project and installing on client machine,
i am unable to access shared drive

Clients pc is showing shared drive in "my computer" but it is not showing shared drive
in installed setup.

Client has windows 10. I have also try regedit tips shown on some website but it is not working.

What I have tried:

VB

Dim OpenExcel As New OpenFileDialog
OpenExcel.Multiselect = False
OpenExcel.Title = "File Search"
OpenExcel.Filter = "Excel Files|*.xls;*.xlsx;*.xlsm"


OpenExcel.InitialDirectory = Path  
'Here path is a folder path of the shared drive

Dim Result As DialogResult
Result = OpenExcel.ShowDialog()

If Result = Windows.Forms.DialogResult.OK Then
			
	'task to perform
			
End If

Posted 12-Aug-21 0:05am

Devendra Sarang

Updated 12-Aug-21 0:16am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2021-08-12T00:16:00

We can't help you - it needs access to your code running on your client's system, and we have access to neither.

So start by logging: add lines to print to a log file what if going on:

VB

' LOG HERE to show it's in the method
Dim OpenExcel As New OpenFileDialog
OpenExcel.Multiselect = False
OpenExcel.Title = "File Search"
OpenExcel.Filter = "Excel Files|*.xls;*.xlsx;*.xlsm"


OpenExcel.InitialDirectory = Path  
' LOG HERE to show Path
'Here path is a folder path of the shared drive

Dim Result As DialogResult
Result = OpenExcel.ShowDialog()
' LOG HERE to show result

If Result = Windows.Forms.DialogResult.OK Then
    ' LOG HERE to show full path to file.
			
	'task to perform
			
End If

Then when the problem has occured you get the client to send the file you you along with screenshots of the Open Dialog so you can look at them and maybe see what is happening.

But at the moment, you are just whistling in the dark - you need information to fix this!