By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,616 Members | 2,426 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,616 IT Pros & Developers. It's quick & easy.

VB Excel Help

samycbe
P: 83
Hi Friends,

I want to open the excel and show the print dialouge box in excel when a command button click on vb. Please help me


samy
Apr 3 '07 #1
Share this Question
Share on Google+
6 Replies


Dököll
Expert 100+
P: 2,364
Hello Samy!

I am not to savvy in VB/Excel Interaction. Are you getting errors? Where are you stuck? If you could not find anything here. I would type up a text in Google and fetch for answers. You'd be surprised the info that can be gathered that way.

Also, Microsoft usually has posts on their Knowledge Base page concerning their products, I'd give them a try as well if Google pulls up nothing concrete.

Have fun with this project!

Dököll
Apr 3 '07 #2

samycbe
P: 83
Hi,

Actually i designed the output in excel with font and borders and everything is over. And i am showing the excel screen to the user. But the user want the print dialouge box in excel shown on click in the output command button. What is the code for that?
samy
Apr 3 '07 #3

Dököll
Expert 100+
P: 2,364
Hi,

Actually i designed the output in excel with font and borders and everything is over. And i am showing the excel screen to the user. But the user want the print dialouge box in excel shown on click in the output command button. What is the code for that?
samy
I am sorry I do not follow, do you mean to say the user wants a command button right on the sheet...
Apr 3 '07 #4

samycbe
P: 83
no ya

when user click the command button on vbscreen the values are passed to the excel sheet and showing the excel. on that time in excel the print window should be poped.

is it clear now? Please advise.........


samy
Apr 3 '07 #5

Dököll
Expert 100+
P: 2,364
no ya

when user click the command button on vbscreen the values are passed to the excel sheet and showing the excel. on that time in excel the print window should be poped.

is it clear now? Please advise.........


samy
You sound frustrated:-)

Are you up against a wall with this one? Assuming you've searched a little deeper here, I found this in Google:

http://groups.google.com/group/comp....61cda7fd154862

In a bit, Samy!

Dököll
Apr 3 '07 #6

Expert 5K+
P: 8,434
I think you probably just need to invoke the Printout (or PrintPreview) method of your Excel.Worksheet object.
Apr 4 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.