Call another Workbook and make it work!?

HunterN · Mar 20th, 2002, 01:34 PM

I have a workbook that has a control button
that opens another workbook. This other
workbook has forms and macro code behind it
that works when I open the workbook by itself.

This is my problem: I want the second workbook only opened when the command button is selected from the first workbook. The command button does open the second workbook but, it does not allow me to select (or move) within this workbook. It sits at the current activecell and makes all changes to that one cell. I though maybe it was the Protection issue, but I've tried that and it doesn't fix anything. Any suggestions????

Al Chara · Mar 20th, 2002, 04:26 PM

The following code will open a workbook:

Workbooks.Open "NameofYourWorkbook.XLS"

kenstr · Mar 21st, 2002, 10:33 AM

Check out the last few replies to the topic "Macro works in native excel but not via automation"

Should work for you also.

Mar 20th, 2002, 04:26 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	The following code will open a workbook: Workbooks.Open "NameofYourWorkbook.XLS" __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 01:34 PM	#1
HunterN Board Regular Join Date: Mar 2002 Location: Maryland Posts: 424	I have a workbook that has a control button that opens another workbook. This other workbook has forms and macro code behind it that works when I open the workbook by itself. This is my problem: I want the second workbook only opened when the command button is selected from the first workbook. The command button does open the second workbook but, it does not allow me to select (or move) within this workbook. It sits at the current activecell and makes all changes to that one cell. I though maybe it was the Protection issue, but I've tried that and it doesn't fix anything. Any suggestions????

Mar 21st, 2002, 10:33 AM	#3
kenstr New Member Join Date: Mar 2002 Location: Raleigh, NC USA Posts: 11	Check out the last few replies to the topic "Macro works in native excel but not via automation" Should work for you also.