Re: Check if a linked table in the database has been updated/changed

On Dec 12, 4:51 pm, "GeoffG" <geof...@xxxxxxxxxxxx> wrote:
Cliff:

Ifyou want to seeif"Ledger.txt"hasbeenmodified since the last time you
ran your macro, then there is a way using VBA (i.e. code in a module).

Do you want a VBA solution?

Geoff

"CliffKing" <Clif...@xxxxxxxxx> wrote in message

news:550c1031-0c9d-4f41-82ce-6737d2569af0@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Is there a way in VBA tocheckifalinkedtablein thedatabasehas
beenupdated?
Example:
I have atable"LedgerTemp" which is a direct link to a text file on
the LAN "Ledger.txt"
This text file is periodically updated (overwritten) through out the
day and night by some mainframe jobs.
Right now I just manually run a macro that just basically appends data
from thelinked"LedgerTemp"tableto a localtable"Ledger"

Is there a way I cancheckto seeifmylinkedtablehaschanged and
ifso trigger my macro that appends the new data?

Thanks

Cliff

Yes Please
.

Relevant Pages

  • Re: PC Word Macro Not Working in Mac Word
    ... The Mac VBA Editor is a savagely-castrated shadow of the one in Word ... let the Macro Recorder write the bulk of the code for you. ... The "execute" seems to be ... Since, in VBA, we are running within the context of a single application, we ...
    (microsoft.public.mac.office.word)
  • Re: PC Word Macro Not Working in Mac Word
    ... I did a test macro with basically just the code you ... The Mac VBA Editor is a savagely-castrated shadow of the one in Word ... The "execute" seems to be ... Since, in VBA, we are running within the context of a single application, we ...
    (microsoft.public.mac.office.word)
  • Cant get this to work
    ... This looks to be exactly what I am trying to do but I'm a complete novice with VBA. ... When I run this macro I get the error "Error: file not found" so i put in a MsgBox here ... Need help with FTP upload script (beginner) ... from a button, you need to assign the button to run the subroutine, ...
    (microsoft.public.word.vba.beginners)
  • Re: Exporting from Project 2007 to Word 2003 or Excel 2003
    ... macro and export an Excel worksheet with no blank rows - exactly ... Resource Names into the worksheet created using the macro. ... VBA, I am almost inclined to teach myself a little bit of VBA so I ... Dim xlCol As Excel.Range ...
    (microsoft.public.project)
  • RE: Repeating Headers Footers and tables across multiple documents
    ... I enjoy learning more about the ways macros and VBA can help ... I really appreciate your response. ... > (For this first macro, ... >> project specific .dot file that is then opened and used to create the ...
    (microsoft.public.word.pagelayout)
Loading