|
-
Jan 7th, 2006, 05:20 AM
#1
Thread Starter
Addicted Member
Print an invisible excel form
hi there, i will need so help please. Here is my problem.
i have an excel form with specific named cells A1 (name), B1 (description), A2(deparment ID ) and B2 (purpose). I have to pass some a set of values via the vb code to the specific name cells in the excel form. Each set of values need to be in a different page so for example you have 3 pages for 3 sets of values. When i click on the Print Button on a different vb form, it should open excel, pass the values, print the form and close excel, everything in the background. This means i will not see any excel activities on my screen and it should go to the default printer. Thank you.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|