Results 1 to 11 of 11

Error using Workbooks.open

Threaded View

Yona Error using Workbooks.open 02-24-2012, 11:18 AM
StephenR Re: Error using Workbooks.open 02-24-2012, 11:36 AM
royUK Re: Error using Workbooks.open 02-24-2012, 11:40 AM
Yona Re: Error using Workbooks.open 02-24-2012, 11:42 AM
royUK Re: Error using Workbooks.open 02-24-2012, 11:54 AM
Yona Re: Error using Workbooks.open 02-24-2012, 12:14 PM
StephenR Re: Error using Workbooks.open 02-24-2012, 12:24 PM
Yona Re: Error using Workbooks.open 02-24-2012, 12:35 PM
royUK Re: Error using Workbooks.open 02-24-2012, 12:38 PM
StephenR Re: Error using Workbooks.open 02-24-2012, 12:38 PM
Yona Re: Error using Workbooks.open 02-24-2012, 01:03 PM
  1. #1
    Registered User
    Join Date
    02-24-2012
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    9

    Unhappy Error using Workbooks.open

    Hello,

    Hope you guys can help me with this easy question...just driving me nuts over here!

    If I do:
    workbooks.open Filename
    , excel will open the file. However the following doesn't work:

        Dim oWBS As Workbooks
        oWBS.Open Filename
    What I am trying to achieve is open a new excel file from the current one (to read/write some data) so ideally I would like:

    1) to identify my current excel
    2) open a new one and give it a new identifier
    3) be able to go from one to another

    I am just struggling with opening the file while I assign it to a specific object.

    Thanks for your help,

    Yona
    Last edited by Yona; 02-24-2012 at 12:14 PM. Reason: adding question

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1