Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > microsoft.public.excel.programming > #109059

Re: Programing to save who and when someone update the file

Path csiph.com!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From GS <gs@v.invalid>
Newsgroups microsoft.public.excel.programming
Subject Re: Programing to save who and when someone update the file
Date Fri, 08 Jul 2016 09:49:45 -0400
Organization A noiseless patient Spider
Lines 30
Message-ID <nlob1r$k3t$1@dont-email.me> (permalink)
References <Sbugomes.11c4d828@excelbanter.com> <XnsA63EEE64785DBauricauricauricauric@213.239.209.88>
Mime-Version 1.0
Content-Type text/plain; charset="iso-8859-15"; format=flowed
Content-Transfer-Encoding 8bit
Injection-Date Fri, 8 Jul 2016 13:49:47 -0000 (UTC)
Injection-Info mx02.eternal-september.org; posting-host="385a93d8bbdd6c7b95ff6e6963d18654"; logging-data="20605"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19fhHCgRtxii9oehHk5SU2b"
X-Antivirus-Status Clean
X-Newsreader MesNews/1.08.06.00-gb
X-Antivirus avast! (VPS 160630-0, 30/06/2016), Outbound message
X-Face G"ln~:.wBqHZznO'(lJjjprxGYAjIF7#^u)lx,@"H'F#uXm%j`T6kxat5rq092aW;K*#<!y <6K)wt3HjA)V"XV`W3}Qts*D['Jm:qqpgttEl^wk@9{HJglN-Q'.91Af~ySM>m4jZ(2aW$34N&B&E@ j~tjGV-aC18j1y>zi.\[ZGXsd
Cancel-Lock sha1:k/RGmzXGfAvqle2OdLnIccCYAo0=
X-ICQ 543516788
Xref csiph.com microsoft.public.excel.programming:109059

Show key headers only | View raw


> S@bugomes wrote:
>
>> I'm trying to programing the file to save in the column "R" and "S" 
>> the timing and user who updated the file, but this only works for 
>> updating in the first column...how can I do to works in all colums 
>> (from A to Q)?
>
> Here's some code I wrote a few years back that tracks changes. It's 
> not  exactly what you want, but you should be able to modify it to 
> suit your  needs. Usage instructions are included at the start of the 
> file.
>
>   http://auric.altervista.org/excel/track_changes.bas

Nice!!

Have you seen J-Walk's code to 'Undo' VBA changes?

-- 
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
  comp.lang.basic.visual.misc
  microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

Back to microsoft.public.excel.programming | Previous | NextPrevious in thread | Next in thread | Find similar | Unroll thread


Thread

Programing to save who and when someone update the file S@bugomes <Sbugomes.11c4d828@excelbanter.com> - 2016-07-08 03:51 +0100
  Re: Programing to save who and when someone update the file "Auric__" <not.my.real@email.address> - 2016-07-08 06:26 +0000
    Re: Programing to save who and when someone update the file GS <gs@v.invalid> - 2016-07-08 09:49 -0400
      Re: Programing to save who and when someone update the file "Auric__" <not.my.real@email.address> - 2016-07-08 17:28 +0000
        Re: Programing to save who and when someone update the file GS <gs@v.invalid> - 2016-07-08 13:49 -0400

csiph-web