Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
open and close files
Hi,
Would you please help me to code? Thanks. I have two files: A and B. I open the file A to enter new information and then close it. As soon as I close the file A, I would like the file B opens by itself. Please help Thank you! Chi |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
open and close files
Hi,
In Book A Alt+f11 to open VB editor and double click 'ThisWorkbook" Paste the code below in on the right and change the path and name to the workbook you want to open when Book A closes. Private Sub Workbook_BeforeClose(Cancel As Boolean) Workbooks.Open Filename:="C:\book1.xls" End Sub Mike "Chi" wrote: Hi, Would you please help me to code? Thanks. I have two files: A and B. I open the file A to enter new information and then close it. As soon as I close the file A, I would like the file B opens by itself. Please help Thank you! Chi |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
open and close files
Hi Mike,
I would like to say THANK YOU for your help! It is cool to see it works!! Sorry, I did not mention that the file A is a template file (xltx). Therefore, it works only once. Please help Thanks Chi "Mike H" wrote: Hi, In Book A Alt+f11 to open VB editor and double click 'ThisWorkbook" Paste the code below in on the right and change the path and name to the workbook you want to open when Book A closes. Private Sub Workbook_BeforeClose(Cancel As Boolean) Workbooks.Open Filename:="C:\book1.xls" End Sub Mike "Chi" wrote: Hi, Would you please help me to code? Thanks. I have two files: A and B. I open the file A to enter new information and then close it. As soon as I close the file A, I would like the file B opens by itself. Please help Thank you! Chi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linked PDF files open briefly and then close | Excel Discussion (Misc queries) | |||
How to open a list of excel files and get update, then close it? | Excel Discussion (Misc queries) | |||
fix for open/close files problem | Excel Discussion (Misc queries) | |||
fix for open/close files problem | New Users to Excel | |||
Hyperlinks to files open and then close instantaneously | Excel Discussion (Misc queries) |