Re: Application.ontime from shared drive

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Once your workbook is opened in excel, it doesn't matter where it came from.

But depending on what your macro does, maybe that won't work on a shared drive
(but I'm not sure what a shared drive really is).

You may want to post some more details -- and explain what a shared drive is.

jlclyde wrote:

Can Application.ontiem work from a shared drive? I want a file to do
a task every 10 minutes or so and I am not sure if this will work if
the file is saved on a shared drive.

Thanks,
Jay

--

Dave Peterson
.

Relevant Pages

  • RE: copying rows to all possible records during a macro
    ... "akphidelt" wrote: ... So it would matter if you had 5 or 50000. ... I have created a macro that, among other things, copies a formula from the ... data that I exported to Excel from an accounting application. ...
    (microsoft.public.excel.programming)
  • Re: Pi
    ... decimal places, is it possible to, with formula or macro, calculate pi in ... Excel to a significant number of places? ... Well, of course it's *possible*, depending on your definition of ... Shikata ga nai... ...
    (microsoft.public.excel.misc)
  • RE: copying rows to all possible records during a macro
    ... So it would matter if you had 5 or 50000. ... I have created a macro that, among other things, copies a formula from the ... data that I exported to Excel from an accounting application. ... is there a way (perhaps in VBA Editor) that I can tell the macro to ...
    (microsoft.public.excel.programming)
  • cells() and counting number or rows on spreadsheet
    ... I was just curious I have done this in excel with a macro I created and it ... assuming that with the VB editor it shouldn't matter what application you are ...
    (microsoft.public.excel.worksheet.functions)
  • Re: how not print cell in printout?
    ... can get without using a macro when printing. ... David McRitchie, Microsoft MVP - Excel ... all that shows up is a zero or one depending on the condition, ...
    (microsoft.public.excel)