Hi all,
I've an excel-macro (in a Excel-file, say "A") which create a new excel-file
(say "B"); at end of macro (in file A) I open new file (B) created with:
shell(path_xls & " " & new_xlsfile)

where new_xlsfile contains path and name of my new xls file, and path_xls is
like:
C:\Programmi\MicrosoftOffice2003\Office11\excel.ex e

All works fine, but new file is open in a "new excel session", so isn't
possible use function like "copy or move worksheet" from new file (B) to
other opened files (for ex, to A).

My question: there is a way to open my new file (B) in same "excel-session"
of caller-file (B)?
Thanks in advance
JFM

solved with:
workbooks.open(new_xlsfile)



"Andrea" ha scritto nel messaggio
.. .
Hi all,
I've an excel-macro (in a Excel-file, say "A") which create a new
excel-file
(say "B"); at end of macro (in file A) I open new file (B) created with:
shell(path_xls & " " & new_xlsfile)

where new_xlsfile contains path and name of my new xls file, and path_xls
is
like:
C:\Programmi\MicrosoftOffice2003\Office11\excel.ex e

All works fine, but new file is open in a "new excel session", so isn't
possible use function like "copy or move worksheet" from new file (B) to
other opened files (for ex, to A).

My question: there is a way to open my new file (B) in same
"excel-session"
of caller-file (B)?
Thanks in advance
JFM