closing dummy file

[ricowyder]

Dear group,

A former discussion about how to delete the message on opening the file
(links to other worksheets) was great for my problem. Tom suggested to
create a dummy file, which opens the other file and which suppresses
the message. Here's the link:

dummy file: A
other file (with message to be suppressed): B

http://groups.google.com/group/micr...+links+other+workbook&rnum=1#99bc4642b707c7d7

Now, as I know my users, they will complain that there is another file
opened. How can I close that one again? It appears that in B Autpen
does not work anymore... so I had to include those lines also in A's
Autpen.

At which point shall I close A? After opening B (disabled Autpen in
B --> how can it be done automatically then?)? Or do you know a way to
close A when user closes B (automatically closing A).

Thanks for your help.

Best regards,

Rico

 

[Jim Rech]

Doesn't something like this work?:

Sub auto_open()
Workbooks.Open "BookWithLinkFormula.xls", False
ThisWorkbook.Close False
End Sub


--
Jim
| Dear group,
|
| A former discussion about how to delete the message on opening the file
| (links to other worksheets) was great for my problem. Tom suggested to
| create a dummy file, which opens the other file and which suppresses
| the message. Here's the link:
|
| dummy file: A
| other file (with message to be suppressed): B
|
|
http://groups.google.com/group/micr...+links+other+workbook&rnum=1#99bc4642b707c7d7
|
| Now, as I know my users, they will complain that there is another file
| opened. How can I close that one again? It appears that in B Autpen
| does not work anymore... so I had to include those lines also in A's
| Autpen.
|
| At which point shall I close A? After opening B (disabled Autpen in
| B --> how can it be done automatically then?)? Or do you know a way to
| close A when user closes B (automatically closing A).
|
| Thanks for your help.
|
| Best regards,
|
| Rico
|

 

[Jim Rech]

Btw, if you and your users have Excel 2002 or later you do not need to use a
dummy file. With file B open use Edit, Links, Startup Prompt to control the
message. This setting will not be observed or preserved in earlier Excel
versions however.

--
Jim
| Dear group,
|
| A former discussion about how to delete the message on opening the file
| (links to other worksheets) was great for my problem. Tom suggested to
| create a dummy file, which opens the other file and which suppresses
| the message. Here's the link:
|
| dummy file: A
| other file (with message to be suppressed): B
|
|
http://groups.google.com/group/micr...+links+other+workbook&rnum=1#99bc4642b707c7d7
|
| Now, as I know my users, they will complain that there is another file
| opened. How can I close that one again? It appears that in B Autpen
| does not work anymore... so I had to include those lines also in A's
| Autpen.
|
| At which point shall I close A? After opening B (disabled Autpen in
| B --> how can it be done automatically then?)? Or do you know a way to
| close A when user closes B (automatically closing A).
|
| Thanks for your help.
|
| Best regards,
|
| Rico
|