Menu
Hi All
Im trying to run a macros in Excel that automatically prints multiple different documents.
At the moment each document is linked to the excel spreadsheet by hyperlinks.
The following visual basic code was generated by the macro:
[CODE]
Sub printoverview()
‘
‘ printoverview Macro
‘ Macro recorded 09/02/2006 by Peter
‘
‘
Range(“C6:D6”).Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
Application.WindowState = xlNormal
Range(“C7:D7”).Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
Application.WindowState = xlNormal
Range(“C8:D8”).Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
Application.WindowState = xlNormal
End Sub
At the moment all this code does is open up each document.
Does anyone know either of the following:
a) how to update this code so that it performs the function of printing each document (preferably by either not opening the word documents or by closing them once printed) by a simply click of a link?
b) a visual basic forum that would be better in assisting me with this problem?
c) how to use excels create macro to achieve the required result?
Any help is much appreciated.