| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
| how do i open a data workbook when i open a timesheet workbook | Excel Discussion (Misc queries) | |||
| Open a specific workbook...find value from other open workbook and then insert cells values in cell next to it. | Excel Programming | |||
| excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
| How do you program so that Workbook B cannot be open unless Workbook A is open? Plus I need to validation | Excel Programming | |||
Linear Mode
