Comments:
I am using the following code to 1) open; 2) update; and 3) print a series of spreadsheets.
My spreadsheets are linked to BRIDGE. The code is rather simple, but it does not work. Althought the update command has been given, Excel prints the sheet without the updated information. However, as soon as the subroutine has completed (and the file already sent to the printer) the spreadsheet is then updated with the correct information. Does anyone know why this happens?
Sub Print_All_Models()
Workbooks.Open Filename:= "C:test.xls", UpdateLinks:=3
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End Sub
Obviously this is a simple piece of code, but the macro will eventually be wrtitten to work with 30+ spreadsheets, and will automate a burdensome process that is presently done my hand. However, it is of no use to me if I can't get the correct data into the spreadsheet before it is printed.
Thanks,
Mark
|
