microsoft.public.excel.programming

Corey

12/11/2006 11:39:00 PM

Have a gander at the link here:
http://www.rondebruin.n...
or
http://www.exceltip.com/show_tip/Files,_Workbook,_and_Worksheets_in_VBA/Getting_Values_From_A_Closed_Workbook_using_VBA_in_Microsoft_Exce...
Corey....
"C_Ascheman" <CAscheman@discussions.microsoft.com> wrote in message
news:FB729793-704D-4E11-A0B7-566CD256FB97@microsoft.com...
>I have an old workbook that contains 5 sheets with data, and out dated
>code.
> Is there a way to copy everything from the old workbook to a new workbook
> with the updated code without opening the old workbook? I would like to
> have
> one of the new workbooks opened with the data contained from the old
> workbook. Any help, or ideas is greatly appreciated on this.
>
> C_Ascheman