Results 1 to 5 of 5

Open a form using a vb script

Threaded View

  1. #1
    Registered User
    Join Date
    07-31-2015
    Location
    Chile
    MS-Off Ver
    2010
    Posts
    3

    Open a form using a vb script

    Hello, Im am tryinig to open a form (wich resides in an excel file) using a vb script located in the desktop, here is the code:

    Set objExcel = CreateObject("Excel.Application")
    objExcel.Visible = true
    Set objWorkbook = objExcel.Workbooks.Open("c:\path\name.xlsm") 
    
    call Workbook_Open()
    
    Public Sub Workbook_Open()
    
    
    UserForm4.show()
    
    End Sub
    It can open the file, but itīs unable to open the form, displaying a message wich says that there is a missing object call UserForm4 (UserForm4 is the name of the form in excel file), the error code is 800A01A08
    Last edited by Anitaelo88; 07-31-2015 at 10:27 PM. Reason: Wrong format

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2010 - VBA Userform - How to open a form starting at the top of the form
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-29-2015, 05:45 AM
  2. [SOLVED] Cant open a file with my script please help me out
    By elmnas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-17-2015, 06:05 AM
  3. Script to transfer from MS Word form to EXCEL
    By walshth in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-15-2014, 12:31 AM
  4. Open exported file form SAP (via .vbs script)
    By Miroslav R. in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-07-2013, 02:08 AM
  5. [SOLVED] Close open workboos with script
    By kjsconv in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-22-2013, 09:52 PM
  6. Coding script error-cmd button to open form and for to add new entry to list
    By Southfish in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-30-2012, 05:43 AM
  7. VBA + VB Script fails to open the workbook.
    By Suresh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-03-2006, 05:45 AM

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