+ Reply to Thread
Results 1 to 4 of 4

Delete first line in closed 'Workbook_Open' from another workbook

  1. 03-12-2011, 02:46 PM #1
    Mayweed is offline
    Forum Contributor
    Join Date
    08-19-2010
    Location
    UK.
    MS-Off Ver
    Excel 2007
    Posts
    142

    Delete first line in closed 'Workbook_Open' from another workbook

    Does anyone know how to delete the first line of the following code from a closed workbook using VBA in a seperate open workbook?
    Please Login or Register  to view this content.
    Last edited by Mayweed; 03-12-2011 at 04:05 PM.
    Reply With QuoteRegister To Reply
  2. 03-12-2011, 03:16 PM #2
    nimrod is offline
    Valued Forum Contributor
    Join Date
    09-21-2003
    Location
    British Columbia , Canada
    MS-Off Ver
    03,07,10,13
    Posts
    727

    Re: Delete first line in closed 'Workbook_Open' from another workbook

    Pearson explains/dicussess the topic here http://www.cpearson.com/excel/vbe.aspx
    Reply With QuoteRegister To Reply
  3. 03-12-2011, 03:25 PM #3
    Mayweed is offline
    Forum Contributor
    Join Date
    08-19-2010
    Location
    UK.
    MS-Off Ver
    Excel 2007
    Posts
    142

    Re: Delete first line in closed 'Workbook_Open' from another workbook

    Thanks for the reply, I looked at that last night but can't see anything covering my question, he explains how to create a 'Workbook_Open' event procedure, but not how to delete a single line in it from a seperate workbook.
    Reply With QuoteRegister To Reply
  4. 03-12-2011, 04:03 PM #4
    Mayweed is offline
    Forum Contributor
    Join Date
    08-19-2010
    Location
    UK.
    MS-Off Ver
    Excel 2007
    Posts
    142

    Re: Delete first line in closed 'Workbook_Open' from another workbook

    After looking again I think I can figure something out from Pearson's site, thanks again.
    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