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!

  • Congratulations gkittelson 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. Twosips

    Syntax for emailing a single sheet.

    Can someone tell me the syntax in a Powerplay macro for emailing a single sheet of an excel file? My code is below. Dim objOutlook As Object Dim objOutlookEmail As Object Dim objOutlookAttachments As Object Set objOutlook = CreateObject("Outlook.Application") Set...
  2. Twosips

    Opening Powerplay reports using Access

    OK. I got this to halfway load the report. Using the command button syntax: stAppName = "C:\Program Files\Cognos\Cer1\bin\pwrplay.exe C:\Documents and Settings\username\Desktop\Test.ppr" It now starts the app and opens a locate file browse menu and stops. The file name is right there in the...
  3. Twosips

    Opening Powerplay reports using Access

    This is hopefully an easy one for someone out there. I am trying to start an application (Cognos Powerplay) using MS Acess 97 and run a saved Powerplay report. I can use the Runapp command to start the application but cant run the report. Any help? I have also tried using command buttons in a...

Part and Inventory Search

Back
Top