+ Reply to Thread
Results 1 to 2 of 2

Updating add-in sheet on startup (workbook_open)

  1. 07-08-2013, 06:17 AM #1
    Bishonen
    Bishonen is offline
    Valued Forum Contributor
    Join Date
    03-17-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    2007/2010
    Posts
    555

    Updating add-in sheet on startup (workbook_open)

    Hi all,

    I'm trying to do something very easy: add the current date in an addin worksheet when excel opens.

    Please Login or Register  to view this content.
    This results in a Run-time error '1004':
    Method 'Rows' of object '_Global' failed
    I guess thats due to the sheet not being open at that time?

    Thanks for any help!
    If you think that my answer was helpful, please click on the "Add to this user's Reputation" button.
    Reply With QuoteRegister To Reply
  2. 07-08-2013, 06:29 AM #2
    satputenandkumar0
    satputenandkumar0 is offline
    Forum Contributor satputenandkumar0's Avatar
    Join Date
    11-08-2012
    Location
    Pune, India
    MS-Off Ver
    Office xp & Office 2007
    Posts
    398

    Re: Updating add-in sheet on startup (workbook_open)

    Dear Bishonen ,

    try the below code.

    Please Login or Register  to view this content.
    Last edited by satputenandkumar0; 07-08-2013 at 06:32 AM.
    Regards,
    Nandkumar S.
    ---------------------------------------------------------------
    Don't forget to Click on * if you like my solution.
    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