+ Reply to Thread
Results 1 to 6 of 6

Is it possible, update multiple spreadsheets at one time?

  1. #1
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Is it possible, update multiple spreadsheets at one time?

    I'm a layman when it comes to macros and not sure what is and isn't possible.

    The (hypothetical) situation is I host a spreadsheet on my website. Users are able to acess this spreadsheet, put their own data into it and save it to my website. Lets say I have 100 customers and I decide to update the spreadsheet with a new feature. Is it possible to update my customer's spreadsheets all at once, or would I have to access each individual's spreadsheet to make the change?

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Is it possible, update multiple spreadsheets at one time?

    can you post the site's url? a screenshot of what is going on?

    how can you do this?
    Users are able to acess this spreadsheet, put their own data into it and save it to my website
    you said it's a hypothetical. are you not currently doing this?

  3. #3
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Re: Is it possible, update multiple spreadsheets at one time?

    Quote Originally Posted by vba_php View Post
    are you not currently doing this?
    No I am not doing this currently. I am hoping it is possible though.

  4. #4
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Is it possible, update multiple spreadsheets at one time?

    Quote Originally Posted by Butcher1 View Post
    No I am not doing this currently. I am hoping it is possible though.
    what exactly will you be doing? that is not clear at all. just saying ""keep a spreadsheet on a website"" says nothing.

    - embedded?
    - linked to something else?
    - attached as a file with an extension?

    etc, etc....

  5. #5
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Re: Is it possible, update multiple spreadsheets at one time?

    I host a spreadsheet on a website. You pay a monthly subscription fee to use it and save it as vba_php's_personal_copy (restricted to being saved only to my website cloud space). You enter your data and have a sheet that will display your data in an easy to view format. I have 100 other people who also subscribe to my spreadsheet and are putting their own data into their personal copy of the spreadsheet. Eventually I decide to update my master copy of the spreadsheet. To update every customer's spreadsheet with new formulas, would I have to access each spreadsheet individually, or could I just update the master spreadsheet and run a macro to update all customer's spreadsheets at one time?
    https://www.youtube.com/watch?v=gIIj5-267uI
    This video seems to suggest it is possible, but I don't know enough to understand enough to know if the method in the video would work in my situation.

  6. #6
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Is it possible, update multiple spreadsheets at one time?

    look at this point in the video:

    https://www.youtube.com/watch?v=gIIj5-267uI#t=203

    he's talking about looping locally. doing it in the cloud is completely different. VBA is not a cloud language. thus, I seriously doubt it would work. but I could be wrong. if you have an FTP like filezilla, you can test it on your own anyway. why not do that?

+ 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: 3
    Last Post: 11-23-2013, 03:28 AM
  2. Replies: 2
    Last Post: 08-22-2010, 02:40 AM
  3. Replies: 7
    Last Post: 09-25-2009, 10:57 AM
  4. Import Data from multiple spreadsheets into seperate spreadsheets worksheet
    By cablecrt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2008, 08:01 AM
  5. [SOLVED] Help - Auto update from multiple spreadsheets
    By plngarbage in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-12-2006, 11:55 AM
  6. [SOLVED] Help - Auto update from multiple spreadsheets
    By plngarbage in forum Excel General
    Replies: 0
    Last Post: 05-12-2006, 06:10 AM
  7. how can I update multiple worksheets at the same time
    By David2507 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2005, 03:06 AM
  8. [SOLVED] How to update multiple links in multiple spreadsheets followin mo.
    By Andy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-20-2005, 01:06 PM

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