I wonder if this would be OK for me too?

I have a spreadsheet with a couple of command buttons, neither of which I
want to run automatically. BUT I DO want, at a scheduled time, to open Excel
and run one of the buttons (at different times and under different
circumstances.)
- One button is a raw data import from six other spreadsheet, which I want
to run early in the morning so the sheet is ready when people get to work.
The other is an export, which I want to run when everybody has finished for
the day . I tried doing all the work in Access, but the machine runs out of
resources because it has to keep Access AND Excel open.


It looks as though the code sent by papou should do the job, just by putting
in the right vba sub name.

Is there an editor like vba that will give me autocorrection/debug
capability, or am I limited to something like notepad, and running the whole
thing and hoping?
The actual code takes about 30 minutes to run.

It does seem odd that Microsoft has given us command line switches in the
other Office Applications, but not Excel, where it would be more useful than
it is in Word. Judgiing by various threads I've just read, there is a big
demand for this functionality. Probably more than there is for hidden flying
games.




"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" a écrit dans le message de
news: ...
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