Click here to Skip to main content
15,867,704 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hello clever people,

Completely new to VB.NET (only installed Visual Studio 2019 today).

To start all I want to do is open Excel (office 365) from a network location, lets say: -

\\file-svr01\Rozel\Design\Parts\PNG.xlsx
OR
R:\Design\Parts\PNG.xlsx

Please bear in mind I am completely new to VB.NET, so if I have to initialise anything in the code before trying to open excel, it would be good if you can put this in any possible solutions.

What I have tried:

I have tried lots of things and nothing works, but mainly because I don't really understand the syntax
Posted
Updated 14-Jan-21 7:21am
v10
Comments
Ralf Meier 14-Jan-21 9:30am    
If you really don't understand the syntax you should so what everyone has done before in the same Situation : try something, study, look with the Debugger what happens ... and perhaps ask specialized/specific questions ...
Richard Deeming 14-Jan-21 11:52am    
DO NOT edit your question to remove the details after someone has gone to the trouble of trying to help you!

I have reverted your destructive edit.
Ralf Meier 14-Jan-21 12:29pm    
Not with many success - it's gone again ...
Richard Deeming 14-Jan-21 12:30pm    
OK, this user clearly wants his account to be closed.
Ralf Meier 14-Jan-21 12:39pm    
I agree with you when I see the actual version of this question ...

When you ask this to Google you get the following :
vb.net open excel file - Google Search[^]

Here you will find severall examples. I you have a special question feel free to ask it here.
 
Share this answer
 
v2
Comments
Maciej Los 12-Jan-21 16:13pm    
5ed!
Ralf Meier 12-Jan-21 17:13pm    
Thank you, Maciej
Steve@Rozel 14-Jan-21 13:35pm    
I KNOW HOW TO USE GOOGLE, SO POSTING A LINK TO GOOGLE DIDN'T HELP
Ralf Meier 14-Jan-21 14:02pm    
I still don't understand you. This Link show you a lot of examples how to do it. Have you tried anythink ? If Yes : where do you stuck ?
And ... by the way : why do you shout ? Writing in capital letters means shouting ...
Steve@Rozel 14-Jan-21 14:10pm    
I KNOW IT IS, WHAT FUN
 
Share this answer
 
Comments
Maciej Los 13-Jan-21 14:50pm    
???
Ralf Meier 14-Jan-21 9:27am    
I don't want to be abusive - but I suppose the OP wants to have a "quick'n'dirty" code, which is easy to use ... and without doing anything by himself. Yesterday we had a Solution 3 here, where the OP wrotes something like this ... and his answer to your Solution leads diretly into this direction ...
But ... never the less : +5 from me ...
Maciej Los 14-Jan-21 11:27am    
Thank you, Ralf.

I've seen His "solution". I agree with your statement that OP wants to get ready-to-use solution.

Cheers!
Maciej

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900