+ Reply to Thread
Results 1 to 12 of 12

Run Same VBA Macro Code On Multiple Sheets of Multiple workbooks

  1. 06-28-2013, 08:53 AM #1
    AnnaDana
    AnnaDana is offline
    Registered User
    Join Date
    06-11-2013
    Location
    Tampa
    MS-Off Ver
    Excel 2010
    Posts
    19

    Run Same VBA Macro Code On Multiple Sheets of Multiple workbooks

    Hi,
    I have multiple excel files, each of them has multiple worksheets. I want to write a code that goes through all the worksheets of all the files, and converts numbers stored as text to numbers.
    Here is what I've coded, but it gives me an error: "run time error 438-- object doesnt support this property or method"

    Please Login or Register  to view this content.
    Any suggestion is appreciated.
    Attached Files Attached Files
    Last edited by AnnaDana; 06-28-2013 at 09:22 AM.
    Reply With QuoteRegister To Reply
  2. 06-28-2013, 09:05 AM #2
    JapanDave
    JapanDave is offline
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Run Same VBA Macro Code On Multiple Sheets of Multiple workbooks

    Untested,

    Please Login or Register  to view this content.
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files
    Reply With QuoteRegister To Reply
  3. 06-28-2013, 09:12 AM #3
    AnnaDana
    AnnaDana is offline
    Registered User
    Join Date
    06-11-2013
    Location
    Tampa
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Run Same VBA Macro Code On Multiple Sheets of Multiple workbooks

    Thanks JapanDave, but it gives compiling error on the Do statement and highlights .sheet.
    Reply With QuoteRegister To Reply
  4. 06-28-2013, 09:14 AM #4
    JapanDave
    JapanDave is offline
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Run Same VBA Macro Code On Multiple Sheets of Multiple workbooks

    Can you post a sample wrkbook?
    Reply With QuoteRegister To Reply
  5. 06-28-2013, 09:19 AM #5
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Run Same VBA Macro Code On Multiple Sheets of Multiple workbooks

    May be

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 06-28-2013, 09:28 AM #6
    AnnaDana
    AnnaDana is offline
    Registered User
    Join Date
    06-11-2013
    Location
    Tampa
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Run Same VBA Macro Code On Multiple Sheets of Multiple workbooks

    Thanks AB33. It works perfectly. It's just that I prefer it ask for the file location. Could you please let me know how I can modify it?
    Reply With QuoteRegister To Reply
  7. 06-28-2013, 09:32 AM #7
    JapanDave
    JapanDave is offline
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Run Same VBA Macro Code On Multiple Sheets of Multiple workbooks

    Then use this,

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 06-28-2013, 10:06 AM #8
    AnnaDana
    AnnaDana is offline
    Registered User
    Join Date
    06-11-2013
    Location
    Tampa
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Run Same VBA Macro Code On Multiple Sheets of Multiple workbooks

    Could you please post the complete code? I got type mismatch error when I modify it as:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  9. 06-28-2013, 10:13 AM #9
    JapanDave
    JapanDave is offline
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Run Same VBA Macro Code On Multiple Sheets of Multiple workbooks

    Untested,

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  10. 06-28-2013, 10:21 AM #10
    AnnaDana
    AnnaDana is offline
    Registered User
    Join Date
    06-11-2013
    Location
    Tampa
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Run Same VBA Macro Code On Multiple Sheets of Multiple workbooks

    No JapanDave, it gives "object required" error and it's because of with v statement.
    Reply With QuoteRegister To Reply
  11. 06-28-2013, 10:23 AM #11
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Run Same VBA Macro Code On Multiple Sheets of Multiple workbooks 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  12. 06-28-2013, 10:28 AM #12
    AnnaDana
    AnnaDana is offline
    Registered User
    Join Date
    06-11-2013
    Location
    Tampa
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Run Same VBA Macro Code On Multiple Sheets of Multiple workbooks

    Thank you AB33! It works
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1