1.

Solve : launching new excel?

Answer»

hi guys, sorry if i make something wrong. this is my first time here.

I created a batch FILE which copys a file from one location to another and then launch ms-excel.
it does work, but not properly. The problem is that when excel is launched , INSTEAD of opening a NEW blank workbook with 3 blank SHEETS (as std) , it opens a new workbook, with one sheet called as the batch file and shows the content of the batch file.

Code: [Select]echo off copy *.xls d:\ start "c:\....\excel.exe"
could you hlp me , pls?

by the way, the OS is Win 2000, and excell 2003.

thx, max.Quote

hi guys, sorry if i make something wrong. this is my first time here.

I created a batch file which copys a file from one location to another and then launch ms-excel.
it does work, but not properly. The problem is that when excel is launched , instead of opening a new blank workbook with 3 blank sheets (as std) , it opens a new workbook, with one sheet called as the batch file and shows the content of the batch file.

Code: [Select]echo off copy *.xls d:\ start "c:\....\excel.exe"
could you hlp me , pls?

by the way, the OS is Win 2000, and excell 2003.

thx, max.


this is the way i solved the problem.
as i read in the xls help. excel opens a new blank workbook from c:\PROGRAM fils\microsoft\....\xlstart directory.
my batch file was in the same directory. So, i put the batch file in the previous directory (excel).
and MAGIC.......
thx, to all of u . max.


Discussion

No Comment Found