How do I display data refresh date and time

  • Thread starter Thread starter Shree
  • Start date Start date
S

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
 
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
 
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
 
Back
Top