Controling macros in other workbooks

[Carlsbergen]

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.

[TheNewGuy]

I believe That

Please Login or Register  to view this content.

Should do it.

[broro183]

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