Results 1 to 9 of 9

how to get a macro to work with any work book name

Threaded View

  1. #1
    Registered User
    Join Date
    08-23-2008
    Location
    Maputo
    Posts
    38

    how to get a macro to work with any work book name

    i have a made a macro that copies info to a new sheet now that is working great but if i change the name of the work book it wont work any more so i need the macro to work with what ever name i give the workbook

    the current name is
    AVERAGE PRICE (update 2009) Mimmos Armico 170809.xls

    i have attached the code in note pad

    thank you
    wade
    Attached Files Attached Files
    Last edited by Wade LEES; 08-24-2009 at 06:16 AM.
    WADE

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1