+ Reply to Thread
Results 1 to 5 of 5

Open Files

  1. 11-25-2007, 04:02 PM #1
    walid66
    walid66 is offline
    Forum Contributor
    Join Date
    12-09-2006
    Posts
    229

    Open Files

    I have this macro that supposed to select two excel files and open them. when I click process it should open both excel files but only one file opens. is there a way to get the macro to open both? see attach zip file.

    Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-25-2007, 04:42 PM #2
    mudraker
    mudraker is offline
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    Your 2nd workbook open command is inside the If command dealing with a blank textbox2

    You also only need to test the value of PreviousFile & NewFile once


    Replace your CmdProcess_Click with this version

    Please Login or Register  to view this content.
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.
    Reply With QuoteRegister To Reply
  3. 11-25-2007, 04:45 PM #3
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    What happens when you step through the macro?
    Reply With QuoteRegister To Reply
  4. 11-25-2007, 04:49 PM #4
    walid66
    walid66 is offline
    Forum Contributor
    Join Date
    12-09-2006
    Posts
    229
    Thanks it worked perfectly.
    Reply With QuoteRegister To Reply
  5. 11-26-2007, 03:01 AM #5
    mudraker
    mudraker is offline
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    Glad to hear it resolved your problem
    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)

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