V
Vegard H
Hi,
I need to print Excel workbooks from an access vba application, and
usually this works without any troubles. In some cases though, when
running
oExcel.Application.ActiveWorkbook.WorkSheets(arr).PrintOut
where the array contains the names of all visible sheets in the
workbook, some of the sheets don't print. I've checked that the names
are correct in the array. I've also tried different functions like
ActiveWorkbook.Printout, ActiveWindow.SelectedSheets.Printout (when I
know that all the sheets are selected) etc
For some reason they don't want to print. If I open the excel doc
manually and prints the workbook then every visible sheet is printed.
Does anyone have any idea what can be done to avoid this, or is it
something done in the creation of the Excel docs perhaps? (Can't really
do much about that. We have around 60 people all over Europe creating
these documents)
Using Access 2000 and Excel 2003 btw.
I need to print Excel workbooks from an access vba application, and
usually this works without any troubles. In some cases though, when
running
oExcel.Application.ActiveWorkbook.WorkSheets(arr).PrintOut
where the array contains the names of all visible sheets in the
workbook, some of the sheets don't print. I've checked that the names
are correct in the array. I've also tried different functions like
ActiveWorkbook.Printout, ActiveWindow.SelectedSheets.Printout (when I
know that all the sheets are selected) etc
For some reason they don't want to print. If I open the excel doc
manually and prints the workbook then every visible sheet is printed.
Does anyone have any idea what can be done to avoid this, or is it
something done in the creation of the Excel docs perhaps? (Can't really
do much about that. We have around 60 people all over Europe creating
these documents)
Using Access 2000 and Excel 2003 btw.