+ Reply to Thread
Results 1 to 2 of 2

VBA - Loop through workbooks, edit specific sheet and cell - easy

  1. #1
    Registered User
    Join Date
    03-20-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2010
    Posts
    6

    VBA - Loop through workbooks, edit specific sheet and cell - easy

    Hi

    Im trying to do something that should be easy. Loop through all open workbooks and make one change on a specific worksheet in each workbook.
    The code below is supposed to loop through and change Cell D4 on "Sheet3" in all open workbooks...but no luck.

    Whats wrong with this code?

    Please Login or Register  to view this content.
    Last edited by Formats74; 09-07-2017 at 06:46 AM.

  2. #2
    Registered User
    Join Date
    03-20-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: VBA - Loop through workbooks, edit specific sheet and cell - easy

    Ah, nevermind..."PERSONALX.XLSB" is case sensitive...

+ 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. [SOLVED] Sum data from same cell from specific sheet from multiple workbooks
    By G.Bregvadze in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-31-2017, 08:18 AM
  2. Code to loop through workbooks in folder with specific names
    By stephme55 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-31-2016, 07:31 PM
  3. Loop through closed workbooks and post data in specific sheet
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-02-2015, 06:03 AM
  4. Loop for adding specific worksheets in specific workbooks
    By pankaj8219 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-13-2013, 10:22 AM
  5. [SOLVED] Edit code to close all workbooks except active workbook and other specific workbook
    By rocksan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-04-2012, 09:29 PM
  6. Macro to extract data from multiple workbooks, specific sheet, specific cells
    By crissandraauree in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-29-2012, 03:54 PM
  7. How easy is it to loop in VBA based on cell contents?
    By Lee Harris in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-24-2005, 09:25 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