Problem with opening excel file

Question

0.00/5 (No votes)

See more:

Excel-2016

When im trying to open an existing excel file i keep getting this message, and it is not just for this file, any file that i create. I placed the values in the same folder with application.exe, as well as tried in different folders. Has anyone had similar problem? When i create a txt.file in that same folder it opens easily so it must be something with excel that im missing.
System.Runtime.InteropServices.COMException: 'Sorry, we couldn't find Values.xlsx. Is it possible it was moved, renamed or deleted?'

What I have tried:

Imports Microsoft.Office.Interop
   Imports Microsoft.Office.Interop.Excel
   Imports System.IO

xlApp = New Excel.Application
xlWorkbook = xlApp.Workbooks.Open("Values.xlsx")  
xlsheet = CType(xlWorkbook.Sheets(razinaString), Excel.Worksheet)
xlApp.Visible = True

Posted 28-Mar-20 11:49am

Marc Kane

Updated 28-Mar-20 23:08pm

Add a Solution

Comments

phil.o 28-Mar-20 21:08pm

Have you tried an absolute path to the file instead of a relative one?
Have you tried placing the file in the "ProgramData" folder?

Marc Kane 29-Mar-20 7:01am

For some reason it works with an absolute path, but i need it to work with this relative one, cant figure out why it wont open
Edit:
I used this lines to open the file, now it opens
Dim Path As String = "Values.xlsx"
Path = System.IO.Path.GetFullPath(Path)
xlWorkbook = xlApp.Workbooks.Open(Path)

2 solutions

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)

Richard MacCutchan · Answer 1 · 2020-03-28T23:09:00

You need to place the file in the same directory as the program. However, that is only a temporary (quick and dirty) fix.

What you should really do to make it work properly is to stop using harcoded names in your source code. Use an OpenFileDialog Class (System.Windows.Forms) | Microsoft Docs[^] so you can always locate the file yourself.

Patrice T · Answer 2 · 2020-03-28T16:24:00

Solution 1

Quote:
System.Runtime.InteropServices.COMException: 'Sorry, we couldn't find Values.xlsx. Is it possible it was moved, renamed or deleted?'

Make sure the directory, in which you try to open the file, is the one you expect. or tell the directory where the file is.

Posted 28-Mar-20 16:24pm

Patrice T

Updated 28-Mar-20 16:25pm

v2