Click here to Skip to main content
15,071,928 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 ...
Steve@Rozel 14-Jan-21 12:39pm
   
CLOSE IT
Ralf Meier 14-Jan-21 12:41pm
   
I'm very interested to know your Problem ...
If you generally act like this you will never get a Solution to anything ...
Maciej Los 14-Jan-21 13:03pm
   
Never change the content of the question, if there's - at least - one answer.
Replacing original content with dummy-text is rude.

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.
   
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
Ralf Meier 14-Jan-21 14:36pm
   
Would you be so kind and explain me what the matter is with you ...?
   
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