How do I display data refresh date and time

[Shree]

I have an excel file that gets data from an access database. I would like to
know how to display the latest refresh date and time on the excell file

 

[FSt1]

hi
how are you getting the data from access??
assuming you are using code, just add this line at the end

Range("E1").Value = Now

change the range to one outside the data table.

Regards
FSt1

 

[Srivathsava Madhugiri]

The excel workbook connects to an access database and runs a select query to extract the data.

the data is displayed on the excel sheet as a table and from the table I create a pivot table.

I have now changed the properties so that each time the excel file opens the data is refreshed.

I will include you suggestion, however there is a odbconnection.refresh date function. have come across this or used this?



FSt1 wrote:

hihow are you getting the data from access??
26-Oct-09

h
how are you getting the data from access?
assuming you are using code, just add this line at the en

Range("E1").Value = No

change the range to one outside the data table

Regard
FSt

:

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
A Good Solution for "Magic String" Data
http://www.eggheadcafe.com/tutorial...f3-aa98ed6669c3/a-good-solution-for-magi.aspx