Hi,

I have 2 problems I am working on:

1. I am trying to get a specific date from a cell in another closed
file and when I do:

='\\path_to_dir\[filename.xls]sheetname'!cell

somehow it gives me the wrong date (instead of 9/21/08 - 9/22/12)!!!

Is it better to do it through VBA macro?


2. I am trying as I open a workbook to populate a new row, below
existing ones. In this row, the first cell of column A will contain
that specific date range.

Please help! and Thank You graciously in advance