Welcome Guest
Log In | Register )
You last visited December 8, 2016, 2:47 am
All times shown are
Eastern Time (GMT-5:00)

Macros in excel

Topic closed. 62 replies. Last post 11 years ago by time*treat.

Page 5 of 5
PrintE-mailLink
time*treat's avatar - radar

United States
Member #13130
March 30, 2005
2171 Posts
Offline
Posted: January 31, 2006, 12:30 am - IP Logged

Some of you have figured out by now that with minor changes, a macro used in one place can be useful in another. So that you don't have to open every workbook you've ever worked on to find "that one" that did "that thing", use the "export" feature to create a *.bas file (a copy of just the code). You can then "import" it into your new workbook (again, just a copy). Give it a descriptive name. Add comments to the top of the code. Spare yourself some grief.

In neo-conned Amerika, bank robs you.
Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.

    lottaloot's avatar - AvatarZ56
    Redford/MI
    United States
    Member #3396
    January 18, 2004
    4867 Posts
    Offline
    Posted: January 31, 2006, 10:49 am - IP Logged

    Thanks Time*treat

    Where is "export " located in excel?

     

    L ttaL   T

      time*treat's avatar - radar

      United States
      Member #13130
      March 30, 2005
      2171 Posts
      Offline
      Posted: January 31, 2006, 7:56 pm - IP Logged


      in the visual basic editor, under the file menu

      In neo-conned Amerika, bank robs you.
      Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.