• activate macro on opening project file (Project 98)

    Home » Forums » AskWoody support » Productivity software by function » Other MS apps » activate macro on opening project file (Project 98)

    Author
    Topic
    WSroberta
    AskWoody Lounger
    November 10, 2001 at 12:12 pm #362676

    I have a shared project file where users keep modifying the tables. I have written a macro which open a second file which has copies of out standard entry, tracking and cost tables and then copies them via the organiser to our main project, finally closing the “template2 project down.

    Two things –

    one can I stop getting the messages “do I want to copy the table” in other words the tables are just copied ; and

    two can I make all this happen when I open my project file rather than having to run the macro?

    Sorry my vb knowledge is pretty basic – I can follow instructions but cannot do anything from scratch!

    Thanks

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSroberta
      AskWoody Lounger
      November 10, 2001 at 4:57 pm #551346

      Since posting this I have had a bit of a play (please bear in mind I am not very VB so I hope what I have managed to achieve does not go against the laws of nature!!)

      I created several macros to achieve what I wanted to do (because I kept thinking of bits to improve things!) I copied and pasted all these bits together into one.

      On another forum I found a bit about using

      DisplayAlerts = False

      (this needed to go before the start of the instructions for copying things in the organizer in this case!!.

      Then when examining the project explorer in the VB Editor I found a reference to the project I had open (all the macros had gone into modules). When I selected this low and behold the screen suddenly gave me a Private Sub bit which included the magic word “open”. I cut and pasted everything into this and when I open the file if I select disable macros the tables remain as they were when I last closed the file and when I select enable macros the table are all updated to those in my “template” project.

      can anyone please answer two final questions

      – how to stop the screen showing me everything that is happening when the macro is running?
      – how can I delete the modules I don’t want in the project explorer (when I select any one the edit menu is empty?)

      Reply | Quote
      • WSWebGenii
        AskWoody Lounger
        November 12, 2001 at 1:23 am #551449

        how to stop the screen showing me everything that is happening when the macro is running?
        ————-
        In Excel the syntax would be:

        Application.ScreenUpdating =False

        You could try that here.

        – how can I delete the modules I don’t want in the project explorer (when I select any one the edit menu is empty?)

        try Right-Clicking on the Module and choosing Remove ModuleName.

        Cheers

        Reply | Quote
    Viewing 0 reply threads
    Reply To: activate macro on opening project file (Project 98)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    April 2025
    S M T W T F S
     12345
    6789101112
    13141516171819
    20212223242526
    27282930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.