Results 1 to 2 of 2

workbooks.open error

Threaded View

  1. #1
    Registered User
    Join Date
    04-26-2012
    Location
    atlanta, georgia
    MS-Off Ver
    Excel 2003
    Posts
    1

    workbooks.open error

    Hi I am trying to do something simple but I am getting an error:

    "Invalid Outside Procedure"

    It highlights the path of my file:

    Dim excelApp As Excel.Application
    Dim wr1 As Excel.Range
    Dim SigString As String
    Dim Signature As String
    Dim Sheet1 As Excel.Worksheet
    
    
        Workbooks.Open Filename:="d:\test.xls", UpdateLinks:=0 _
            , ReadOnly:=True, Notify:=False
        
     Windows("test.xls").Activate
        Range("A1").Select
        Selection.Copy
        Windows("test.xls").Activate
        Range("C1").Select
        
    End
    
    
    Application.Quit
    Last edited by Leith Ross; 04-26-2012 at 03:14 PM. Reason: Added Code Tags

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1