+ Reply to Thread
Results 1 to 3 of 3

Controling macros in other workbooks

  1. #1
    Registered User
    Join Date
    05-12-2009
    Location
    Udevalla, Sweden
    MS-Off Ver
    Excel 2007
    Posts
    85

    Controling macros in other workbooks

    Hi guys.

    Here is what Im trying to do:

    I have a Excel sheet and I want to copy a certain range from many other workbooks and paste it into my excel sheet.
    To get the values I want to copy I have to run a macro in each workbook.

    I have most of the code ready and it does what I want.


    But there is one problem.

    The macro I have to run in the other workbooks automatically opens a Save As box and I cant figure out a way to automatically answer "No" or disable the Save As entirely.

    My code opens the correct workbook and then I use this code to run the appropriate macro:

    Please Login or Register  to view this content.
    Is there any way to have Excel say "No" to any Save As boxes that appears when running macro 1?


    Hopefully you understand what Im talking about here.


    Any help would be greatly appreciated


    P.S: Unfortunately I cannot post any of the Excel files Im using because of the information they contain.
    Last edited by Carlsbergen; 03-08-2010 at 01:00 PM.

  2. #2
    Forum Contributor
    Join Date
    06-01-2009
    Location
    Cincinatti,Ohio
    MS-Off Ver
    Excel 2003
    Posts
    122

    Re: Controling macros in other workbooks

    I believe That
    Please Login or Register  to view this content.
    Should do it.

  3. #3
    Forum Expert
    Join Date
    01-03-2006
    Location
    Waikato, New Zealand
    MS-Off Ver
    2010 @ work & 2007 @ home
    Posts
    2,243

    Re: Controling macros in other workbooks

    hi Carlsbergen,

    Does one of your macros cause the file to be opened?
    If so, can you adapt your opening code to open it as read only (& also use TheNewGuy's suggestion* + turning the alerts back on, when closing the file)?
    Please Login or Register  to view this content.
    hth
    Rob
    Rob Brockett
    Kiwi in the UK
    Always learning & the best way to learn is to experience...

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1