Home | Blog | Software | Reviews and Features | Forum | Help | Donate | About us
topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • December 11, 2016, 02:00:09 AM
  • Proudly celebrating 10 years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: IDEA: Backup and open file  (Read 2294 times)

wetsmellydog

  • Participant
  • Joined in 2007
  • *
  • default avatar
  • Posts: 104
    • View Profile
    • Donate to Member
IDEA: Backup and open file
« on: November 11, 2010, 11:58:22 AM »
An issue at work with an excel spreadsheet that way too many people have access to made me think of this.

Right click a file and be able to copy the file with a time and date stamp to a sub-directory and then open the file.

I believe this would be easier done than to have to put in a macro in the spreadsheet and it could work on all files.

I am sure an AHK script would work but......everyone who accesses this file would have to run AHK which now as I think of it, creates another issue on how to make it work across a network.

Sorry about the monkey wrench at the end  :-\

Thanks,
Larry

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 4,669
    • View Profile
    • Donate to Member
Re: IDEA: Backup and open file
« Reply #1 on: November 11, 2010, 12:02:02 PM »
I can make a right-click shell extension to do this.  All your users would have to install it, of course.  Acceptable?

wetsmellydog

  • Participant
  • Joined in 2007
  • *
  • default avatar
  • Posts: 104
    • View Profile
    • Donate to Member
Re: IDEA: Backup and open file
« Reply #2 on: November 20, 2010, 06:26:10 PM »
I can make a right-click shell extension to do this.  All your users would have to install it, of course.  Acceptable?

Hi skwire. I apologize for not getting back to you sooner. I had finals (which I passed!) and now doing a preceptorship (nursing) which is 12 hours a day.

I actually figured out how to do it simply but should have thought of it sooner. I wrote a batch file which makes a copy and then opens the file. I compiled it into an executable and named it the same as the file as not to confuse the users. The actual file is in another directory so no one can confuse the two.

Thanks for the quick reply as always and again I apologize for not getting back to you sooner.

Larry

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 4,669
    • View Profile
    • Donate to Member
Re: IDEA: Backup and open file
« Reply #3 on: November 20, 2010, 08:14:55 PM »
Cool, thanks for the update.  Congrats on passing your finals, too.   :D

Renegade

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 13,220
  • Tell me something you don't know...
    • View Profile
    • Renegade Minds
    • Donate to Member
Re: IDEA: Backup and open file
« Reply #4 on: November 20, 2010, 10:56:46 PM »
Just peeking in here...

Not sure if this is the kind of thing you'd need but here goes...

A program that takes the Excel file association, backs up the file when passed to it, then passes the original Excel file on to Excel. Basically, just intercepting the file.
Slow Down Music - Where I commit thought crimes...

Freedom is the right to be wrong, not the right to do wrong. - John Diefenbaker

wetsmellydog

  • Participant
  • Joined in 2007
  • *
  • default avatar
  • Posts: 104
    • View Profile
    • Donate to Member
Re: IDEA: Backup and open file
« Reply #5 on: November 25, 2010, 11:52:47 PM »
A program that takes the Excel file association, backs up the file when passed to it, then passes the original Excel file on to Excel. Basically, just intercepting the file.

Close.

The Excel file is on a server. So whatever is done, has to be done on the file on the server and not on the users side. That is why I went the batch file route.
I would have to have all users who access the file have a program local on their computer. Some tele commute at times so it would get messy making sure
everyone had a user side program.