Macro line calling a VBA Script in Excel does not work


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Macro line calling a VBA Script in Excel does not work

  1. #1
    Join Date
    Aug 2009
    Posts
    37

    Macro line calling a VBA Script in Excel does not work

    Hi,

    I have a macro file in the old format (pre2003) that does a lot of complicated automated things. Since then (with help) I have developed some VBA scripts to enhance it.

    Recently a need arised to make a call from the MACRO file to run a VBA script, and the system is complaining. The VBA script is fine. If you run it as a stand alone works perfectly.

    Here is the MACRO line calling it:

    =RUN('G:\PUBS\PP-MS\INVOICES\INVSALE.XLS'!Module1.InvoiceToBatch)

    Macro file is in a separate file, opened and hidden : It is linked to the INVSALE.XLS sheet and the VBA script is in Module 1 in the INVSALE.XLS.

    Basically, the process stops with an error on Macro line XX which has the following code:

    =RUN('G:\PUBS\PP-MS\INVOICES\INVSALE.XLS'!Module1.InvoiceToBatch)

    Can anyone point where this is falling down?

    Many tahnks.

    Talāt

  2. #2
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    What is the error?
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

  3. #3
    Join Date
    Aug 2009
    Posts
    37
    Quote Originally Posted by Hack View Post
    What is the error?

    Macro error at cell
    [Salemac.xlm]salemac!A289

    Halt Step Continue


    Cell Salemac!A289 has

    =RUN('G:\PUBS\PP-MS\INVOICES\INVSALE.XLS'!Module1.InvoiceToBatch)

Similar Threads

  1. Excel VBA - Reshow A UserForm
    By Hack in forum VB Classic
    Replies: 1
    Last Post: 09-10-2008, 02:40 PM
  2. Excel VBA - VBA Equivalent of hWnd property
    By Hack in forum VB Classic
    Replies: 4
    Last Post: 08-06-2008, 07:19 AM
  3. Replies: 0
    Last Post: 05-15-2008, 04:24 PM
  4. Workbook not Closing Properly by Excel VBA
    By blayne in forum VB Classic
    Replies: 1
    Last Post: 11-17-2005, 06:14 PM
  5. Sample Sites.
    By Murray Foxcroft in forum Web
    Replies: 5
    Last Post: 11-02-2000, 02:42 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center