open and printing workbook with vba
 

sorry for probably a mundane question but i am only just starting to get my
head around vba in excel.
Is there a way for me to click on a cell which will open print and close a
seperate workbook. The workbook i would need to print is only 1 page so i
wouoldn't need to worry about defining the print area.

Thank you in anticipation
Psych142

open and printing workbook with vba
 

to get started, try turning on the macro recorder & doing what you
want to do, then turn off the macro recorder & look @ the code. it
will record the path of the workbook you are opening. you can just
use that & assign it to a button.
hth
susan



On Dec 24, 1:58*pm, psych142
wrote:
sorry for probably a mundane question but i am only just starting to get my
head around vba in excel.
Is there a way for me to click on a cell which will open print and close a
seperate workbook. The workbook i would need to print is only 1 page so i
wouoldn't need to worry about defining the print area.

Thank you in anticipation
Psych142