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

    Macro line calling a VBA Script in Excel does not work


    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:


    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:


    Can anyone point where this is falling down?

    Many tahnks.


  2. #2
    Join Date
    Apr 2007
    Sterling Heights, Michigan
    What is the error?

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

    Macro error at cell

    Halt Step Continue

    Cell Salemac!A289 has


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, 07:14 PM
  5. Sample Sites.
    By Murray Foxcroft in forum Web
    Replies: 5
    Last Post: 11-02-2000, 03: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
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

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