Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open xls file from xls file in same session
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open xls file from other xls-file in same session | Excel Discussion (Misc queries) | |||
In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
Open a file do a macro ( made) and open next succesive file | Excel Programming | |||
Make it so a new session of Excel opens with each file in 2002? | Excel Discussion (Misc queries) | |||
Open an Excel file in a new Excel session | Excel Programming |