Thanks for your answers guys.

Papou, your example allow me to run the macro that is "auto-run" in the
sample1.xls file, does'nt it ?

Actually, I have written a macro in a .xla file, it contains a function that
open a file with the "Open and repair" option when it is called. I have put
this macro in the XLStart folder so that it is loaded each time Excel is
opened. In some specific context, I would like to call my function, so not
systematically. As I said in my first post, this is very easy with Word, but
I still did not found the way to do it with Excel.

Sorry if was not clear with py first post, I hope it is better now.


"papou" wrote:

> Hello Drinkmilk
> This is possible using a script.
> Paste this into a new text file and amend accordingly.
> Save with .VBS suffix and double-click to run.
>
> Dim objxl, xlwbk
> Set objxl = CreateObject("Excel.Application")
> objxl.Visible = True
> Set xlwbk = objxl.Workbooks.Open("C:\Documents and Settings\papou\My
> documents\Sample1.xls")
> objxl.Run ("Go")
>
> HTH
> Cordially
> Pascal
>
>
> "Drinkmilk" <[email protected]> a écrit dans le message de
> news: [email protected]...
> > Hello,
> >
> > I would like to know wether it is possible to run a macro in command line
> > mode for Excel. After having searched in the Web and on this forum, I have
> > seen several comments saying that it is impossible. I am very surprised
> > because this is possible with Word, using for example:
> > "C:\Program Files\Microsoft Office\OFFICE11\WinWord.exe" "c:\MyDoc.doc"
> > /mFileOpenAndRepair
> >
> > Can you confirm if really this is not possible with Excel ?
> >
> > Many thanks
> >
> >
>
>
>