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
 

Reply via email to