Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. HandleUK

    How do I Create and modify Notes E-mail using VBA in Excel

    Thanks for this Geoff, I'll give it a go. I'm guessing the attachment is added as a path? PS liked the quote!
  2. HandleUK

    How do I Create and modify Notes E-mail using VBA in Excel

    I have a spreadsheet which uses VBA to generate an e-mail within the users Lotus Notes account. This is all done via the back door using the code below: HOWEVER, what I'd like to do is paste data directly into the body of the newly created document. I suspect this may be achievable if I use the...
  3. HandleUK

    Configure Printer Settings using VBA Excel?

    I have a userform to which I have added a print button (uses the .PrintForm Command). However I need to make sure the printer is set to Landscape prior to printing. Does anyone out there know how to do this? Its simple enough with activesheets etc. but userforms...
  4. HandleUK

    cells won't multiply in Excel

    It may be this simple but without more information I can't be sure. Go to the Tools menu and select OPTIONS. Click on the calculations tab. There is a section on calculation which can be either automatic, automatic except tables and manual. I'd make sure automatic is selected. If this is so...
  5. HandleUK

    Want to change theToolbar on a Userform Spreadsheet

    I have created a VBA userform within Excel which has a spreadsheet control (9.0) inserted onto it. How can I modify the toolbar associated with this web component? Other than hide it or restrict the avaialble controls there seems no way of adding say a print button! I know how to create and...

Part and Inventory Search

Back
Top