+ Reply to Thread
Results 1 to 2 of 2

Updating a local Excel file through the internet

  1. #1
    Registered User
    Join Date
    02-16-2005
    Location
    Dubai, UAE
    MS-Off Ver
    365
    Posts
    40

    Exclamation Updating a local Excel file through the internet

    Hi there,

    I have the following situation:

    30 people in different countries use a sophisticated VBA Excel file on their local PCs, let's call it myexcelfile.xls. This file contains no custom data, as all data is stored in myexcelfile_backup.xls.

    The biggest challenge with this set up is that whenever there is a newer release or bugfix of myexcelfile.xls, I need to send it out per email to 30 people and hope they replace it with my updated version.

    Note that newer versions can replace older versions without any data loss, as all data is stored in the backup file.

    Idea: with tools like WGET or BITSADMIN, I was thinking of creating a batch file, that would simply download the latest version from a FTP server, and replace the older version with the newly downloaded one.

    Constraints:
    • I shouldn't be using any software that is not native to Windows 7
    • the files can sit in different folders on these 30 computers, therefore the update mechanism would have to identify the path they are in.
    • the update mechanism would have to close the file first before running the update.

    Question: What is the best way to go about this? A DOS Batch file? Or another excel file that is just the "updater", meaning, it's only purpose is to download the new file from the web and overwrite the old file?

    Thanks for your thoughts and ideas, I am a little stuck with this..

    Titus

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Updating a local Excel file through the internet

    One of the best ways I've seen of doing this is on Bruce McPhearson's site here http://www.mcpher.com/Home/excelquirks/gitthat. He's using github which is quite nice, but I don't see a reason that you couldn't use any other method

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 07-12-2013, 11:36 AM
  2. Excel file not updating in Internet Explorer
    By mkvassh in forum Excel General
    Replies: 5
    Last Post: 08-13-2012, 08:54 AM
  3. Internet Explorer opens a local copy
    By Chris in forum Excel General
    Replies: 0
    Last Post: 06-17-2006, 12:50 PM
  4. [SOLVED] Local excel file to update website
    By Anonymous Chief in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-16-2005, 10:05 PM
  5. Updating Excel spreadsheets over the Internet?
    By Dan Merkel in forum Excel General
    Replies: 1
    Last Post: 05-20-2005, 12:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1