Auto updating Excel file without opening source file

[mnas81]

Hi,
I've been stuck in automatic updates of data in excel.
It will of great help if someone helps me.
My Excel file reads the data from some other file. what i need is to automatic updates of the data at the specific time(say midnight), without asking for updates.
looking forward to hear from all you experts.

appreciate timely response in this regard.

 

[jim may]

=Vlookup() will return a value from a Closed Workbook

for example..

=VLOOKUP(C21,'C:\Users\James\Documents\ExcelChest\[test.xls]Sheet1'!A1:A5,1)

 

[mnas81]

Hi Jim,
Many thanks for the reply.
I tried that function but still it was not updating.

My Query is like this.I have two files.File A and File B. The cells in File B is reading the data from the cells in File A.I'm auto saving file B at the specific time at say 6 AM, through Macro and the VB script for Auto saving is

Sub timer()
Application.OnTime TimeValue("6:00:21"), "save"
End Sub
Sub save()
ActiveWorkbook.SaveAs Filename:="C:\Reports\Daily Reports\CloseLoop\" + Format(Date, "dd-mm-yyyy _") + Format(Time, "hh-mm")
End Sub

I kept open File B and it is saving successfully, but the data is not updating,unless i opened the source file(File A). I want the data to be auto update(without opening source file).

Again thanks for your support

 

[mnas81]

Hello to all,
Please can anyone advice me about my query as explained above...

Looking forward for your suggesstions.

Thanks u again!

 

[xenou]

I kept open File B and it is saving successfully, but the data is not updating,unless i opened the source file(File A). I want the data to be auto update(without opening source file).

Why not open the source file, save, and close the source file? That seems like it would be a simple addition to your code.

 

[bumbumsusu]

I am also facing the same trouble. As my understand, every time you receive a new file from your email, you save it in your folder and replace the previous one. It means that a new file is created and Excel cannot find out source data from old one.