Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lastupdated property

Status
Not open for further replies.
SJT75

SJT75

MIS
Oct 1, 2002
1
GB
I have 20 spreadsheets that update nightly from an automated procedure.
Not all update every night though it depends on the events of the day.
Is there a way of only appending the spreadsheets that have been updated, into an access table?
 
Sort by date Sort by votes
Using VB just about anything is possible.

Here are some things you can check out.

the 'dir' function to search a directory

the 'FileDateTime' to get a time stamp

the 'now' function to find out what time it is now

the docmd function
e.g. docmd.transferspreadsheet
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Aximboy
  • Locked
  • Question
Change SQL property of saved query 2
Replies
5
Views
117
kjv1611
kjv1611
patriciaxxx
  • Locked
  • Question
Compile error Invalid use of property and Runtime Error 13 Type Mismatch
Replies
4
Views
226
strongm
strongm
JulianAustin
  • Locked
  • Question
Compile Error Expecting Sub, Function or Property
Replies
8
Views
199
JulianAustin
JulianAustin
2009luca
  • Locked
  • Question
COPY TABLE1 TO TABLE2 with index, property, ecc... 1
Replies
2
Views
87
2009luca
2009luca
vba317
  • Locked
  • Question
RunTime error 1004 Unable to get PivotFields property of the pivot table class 2
Replies
7
Views
159
vba317
vba317

Part and Inventory Search

Sponsor

Back
Top