How do i keep two separate excel workbooks updated?

Question

1.00/5 (1 vote)

See more:

I am reading from an excel file to display information in a gridview. Unfortunately, this file has to remain closed in order for me to read it. And even more unfortunately, it is a file that is constantly being opened to be updated. Any advice will be welcomed.

Thanks

What I have tried:

I looked into creating a macro but I was unable to get that to work. And Im pretty sure the people who will have to update this file will not be familiar with macros.

Posted 10-Feb-16 11:02am

Member 10736689

Updated 10-Feb-16 11:22am

v2

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)

Dave Kreskowiak · Answer 1 · 2016-02-10T12:29:00

Solution 1

You have no choice but to open it, or make a copy of it and open the copy. In either case, the file will be unavailable for update during the read by your code or during the copy operation.

The real solution is to NOT use an Excel sheet as a database. Use a real database engine and if you need to manipulate the data in Excel, load it from the database using Excel's data functionality, which can import from an SQL database.

Posted 10-Feb-16 12:29pm

Dave Kreskowiak

Comments

Member 10736689 29-Feb-16 9:18am

I managed to get it working using a macro. The purpose of the web application was to just read data from an excel file. Manipulation of the data by the stakefolders remained within an excel file.