+ Reply to Thread
Results 1 to 3 of 3

Switching Between Workbooks

  1. #1
    Registered User
    Join Date
    01-17-2013
    Location
    Austin, TX
    MS-Off Ver
    Excel 2007
    Posts
    84

    Switching Between Workbooks

    I'm trying to write a program that will switch between workbooks. However, the current code gives me a type mismatch. I tried Variant and Object for my variables but those don't work.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Switching Between Workbooks

    This is a string, it's not a workbook or a reference to a workbook.
    Please Login or Register  to view this content.
    If you want to set wk to refer to workbook you could try this.
    Please Login or Register  to view this content.
    Mind you the workbook Book1.xlsm would need to be open for that to work.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    01-17-2013
    Location
    Austin, TX
    MS-Off Ver
    Excel 2007
    Posts
    84

    Re: Switching Between Workbooks

    Great thanks. For future viewers check out this.

    Please Login or Register  to view this content.

+ 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. Switching between workbooks,
    By Katharine Evans in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-26-2014, 07:45 AM
  2. Switching between workbooks
    By trillium in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-09-2010, 09:07 AM
  3. Switching between workbooks
    By Apel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-27-2009, 12:43 AM
  4. Switching between workbooks
    By toocold in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-24-2007, 08:22 AM
  5. switching between workbooks
    By dabith in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-08-2006, 07:45 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