open and printing workbook with vba

  • Thread starter Thread starter psych142
  • Start date Start date
P

psych142

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MACRO TO COUNT ALL OPEN WORKBOOKS and print 1
Excel VBA - Problem with Closing Print Preview 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Print entire workbook with each sheet starting at page 1 8
Open a word mail-merge document from Excel VBA 1
Pulling data from one workbook to another one using VBA 0
Macro to print specified range of several work sheets 2
Dynanic Print Range 2

Back
Top