+ Reply to Thread
Results 1 to 1 of 1

Error while running a macro

Hybrid View

vijay2482 Error while running a macro 11-02-2009, 06:34 AM
  1. 11-02-2009, 06:34 AM #1
    vijay2482 is offline
    Forum Contributor vijay2482's Avatar
    Join Date
    03-03-2009
    Location
    Paris,France
    MS-Off Ver
    Excel 2003
    Posts
    263

    Error while running a macro

    Hi all,

    I have a workbook that is on the server.
    I have a vb.net application that creates a copy of this workbook along with the macros and a macro named Color is run(executed) from vb.net application.

    I get the following error message:
    ActiveX component can not create object
    The error is produced in the line:
     Set wbTo = ThisWorkbook
    Have attached the entire macro code.

    Any help on this will be helpful.
    Thanks for all the previous help that I got from this forum.
    Last edited by vijay2482; 11-02-2009 at 09:52 AM. Reason: Resolved the error.
    VIjay

    If you find any of the post useful to your question, please add to the contributor's reputation by clicking the blue scales icon in the blue bar of the post.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1