VB Excel Help

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • samycbe
    New Member
    • Feb 2007
    • 83
    #1

    VB Excel Help

    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
    Tags: None
    • Dököll
      Recognized Expert Top Contributor
      • Nov 2006
      • 2379
      #2
      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

        Comment

        • samycbe
          New Member
          • Feb 2007
          • 83
          #3
          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

            Comment

            • Dököll
              Recognized Expert Top Contributor
              • Nov 2006
              • 2379
              #4
              Originally posted by samycbe
              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...

                Comment

                • samycbe
                  New Member
                  • Feb 2007
                  • 83
                  #5
                  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

                    Comment

                    • Dököll
                      Recognized Expert Top Contributor
                      • Nov 2006
                      • 2379
                      #6
                      Originally posted by samycbe
                      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.lang.basic.visual/browse_thread/thread/cab2420b1b9a8d03/c461cda7fd154862?lnk=st&q=Print+Excel+data+Through+VB+6.0&rnum=1&hl=en#c461cda7fd154862


                      In a bit, Samy!

                      Dököll

                        Comment

                        • Killer42
                          Recognized Expert Expert
                          • Oct 2006
                          • 8429
                          #7
                          I think you probably just need to invoke the Printout (or PrintPreview) method of your Excel.Worksheet object.

                            Comment

                            Previous template Next
                            Working...