ANmarS - Search results

Excel/VBA expert since Sep 1997 (20 years 9 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

1 Q & A posts tagged with Binder

Thu
Jan 15
2009

Why won't Excel open when opening a Word merge document?

I have Microsoft Word file linked with Microsoft Excel to merge. Used to be prior versions would automatically open up both files in it's respective windows (Word & Excel), but using Microsoft 2003, it just opens the Word document and when I try to manually open the Excel file (double click the icon) it says I'm already in it. Is there a way to automatically open both files by opening the Word file?


Answer

Excel have the feature of opening more than one workbook by double click on one Icon (It is called Workspace)
Not long ago, Office used to have Microsoft Binder, that enables you to put bunch of Office files (like Excel, Access, PowerPoint, etc) in one file called Binder.
But not anymore

The way you are trying to do, I don't think they care much about it now

I would suggest that you do one of the solutions below:
1- Create a hyperlink in one doc to open another (like hyperlink in Word to open Excel file)
2- Or, Do bunch of shortcuts in one folder to open all you files, select them all, and press enter, to open all those files
3- Or, may do some old fashion bat file.

I can not see any other way

VBAXLMan

Thursday 1/15/2009 2:02:12 PM

Tags

History