Can you pull data from a closed Excel file?

How do I dynamically link an Excel workbook?

My team recently had a requirement to move excel workbooks from their source network to one that could be accessed over an intranet.

We needed to have a common way of opening the workbook by using an excel macro, but I want to ensure there is no risk of opening up the user's network, as we're aware that there are other security risks that can arise from opening files on the users own computer and it's not something we're taking lightly.

I know normally when programming in VBA you can declare some variables as string, number etc so then within Excel you can use those types." When I've opened an older version of the workbook (2013) it works fine, but when we tried opening newer workbooks it gives us an error of 1004. This article has given me some ideas about how to handle it: But my knowledge of c# is pretty limited so I'm still trying to work out what this means. Excel.Application app = new Excel.Application();
Excel.Workbook wb = app.Workbooks.Open("Filename",
Type.Missing, Type.Missing);
So what am I missing here? I haven't found any way to convert this code into LINQ to VB. Thanks. If using .net 4 you should be able to do this Dim app As Microsoft.Office.Interop.Application = New Microsoft.

How to make a dynamic reference in Excel?

Can someone please tell me how I can refer to values in the formula as dynamic i.

E they can refer different column every time? =A2&E2&F2&H2 etc. Can I do a reference like following: =A1 & E1 & F1 & H1 &I1? Can we directly get the value of dynamic column name by referencing the static? Ex:- Let's say if there is column named "Date" at column D, column F, column H and column I then how to create one formula and refer the date column as follows?