+ Reply to Thread
Results 1 to 4 of 4

Open Multiple Excel files in Excel2013

  1. #1
    Registered User
    Join Date
    06-11-2014
    Posts
    2

    Open Multiple Excel files in Excel2013

    This Sub works fine in Excel2003. (It is a Sub of file Tables2013.xlsm)

    In Excel2013, it hangs after opening the Pivots.xlsm file. Control does not return to the Sub.

    What do I need to do to make it happen in Excel2013 VBA?

    Thanks for looking at this for me.

    Gary


    -----------------------------------------------------------------------------------------
    Sub OpenFiles()
    ' This Procedure opens the two required Excel intermediate files
    '
    On Error Resume Next

    ChDir "P:\Firehouse Software\PERFORM"
    Workbooks.Open ("P:\Firehouse Software\PERFORM\Pivots.xlsm")
    Workbooks.Open ("P:\Firehouse Software\PERFORM\Reports.xlsm")

    End Sub
    ------------------------------------------------------------------------------------------

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Open Multiple Excel files in Excel2013

    Whats happening on opening of pivots, has it a macro, refresh on opening for the pivot?

    I'd investigate there first.
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Registered User
    Join Date
    06-11-2014
    Posts
    2

    Re: Open Multiple Excel files in Excel2013

    You are right on here. There was an errant auto_open sub left over from Excel2003 days causing the problem. Deleted it and sub works now.

    Many thanks!!

  4. #4
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Open Multiple Excel files in Excel2013

    No probs, add some reputation :o)

+ 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. Macro to open multiple files, remove header and save multiple files in a new format
    By twocircles in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2014, 05:24 PM
  2. Replies: 0
    Last Post: 06-04-2013, 05:14 PM
  3. Can't seem to have multiple Excel files open.
    By jonsidneyb in forum Excel General
    Replies: 1
    Last Post: 02-15-2011, 12:58 PM
  4. VBA to Open Multiple Excel Files
    By nrxanders in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-06-2010, 04:37 PM
  5. Replies: 0
    Last Post: 07-11-2006, 01:55 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