team,
Is someone familar with Excel(5) macros? here is my
problem.
I use some Excel macros to print
automatically production reports on a pc. The printing macros are
launched (activated) by a small package named Scheduler in the defined
times.
suddenly, the package could not launch the
macros, displaying a warning: invalid
file specified.
I spent lot of time without fixing this
problem.
have so experienced this! please
advive
How do you print automatically your
reports
Could you send macros example?
below is an example of a macro included in
workbook1.xls
Sub Auto_Open()
Windows("file1.XLS").Activate ActiveWindow.WindowState = xlNormal Sheets("sheet1").Select Range("A70:P143").Select Application.ActivePrinter = "..........." Selection.PrintOut Copies:=1 Windows("workbook1.xls").Close End Sub Regards
Hafedh ghodhbani
control and instr engineer
british gas international
hannibal gas plant Tunisia
ph 00 216 4 259 250
fx 00 216 4 259 449
|
- Re: Excel macros hafedh ghodhbani
- Re: Excel macros Fahad Q8