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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by riskassure

  1. riskassure

    how to improve performance

    Hello, I developed a report using Report Studio in Cognos 8.4. Basically, I have one massive master query that generates all the data I need for the report. There are about 30 or so pages, and each page contains about one or two tables or charts based on this master query (enclosed is a...
  2. riskassure

    Send Lotus Notes Email using VBA with HTML body

    Sure. The trick is to first read the HTML script as text. Here are the subroutines that work (in the example below, I do not have CC, BCC, and attachments, but they are easy to supply): Sub EmailDocHTML() Dim TheSubject As String, ToAddress As String, MyFile as String, EmailBody as String...
  3. riskassure

    Send Lotus Notes Email using VBA with HTML body

    Oh thank you, yes it did! ~~CW~~
  4. riskassure

    Send Lotus Notes Email using VBA with HTML body

    Hello, I have been using VBA to send Lotus Notes email for a while. The general code is the following: Public Sub SendNotesMail(Subject As String, ByVal Recipient As String, BodyText As String, SaveIt As Boolean) 'Set up the objects required for Automation into lotus notes Dim...
  5. riskassure

    Excel or Web Browser

    Hi, Is there a VBA code that can tell whether I am opening my Excel spreadsheet in Excel, or in a Web Browser, like IE? I tried Applicaton.name but it always gives me Microsoft Excel as the answer, whether the spreadsheet is opened in Excel or in a web browser. Any help will be...
  6. riskassure

    Active Control Name

    Application.Caller works perfectly!! Thank you Combo! ~~CW~~
  7. riskassure

    Active Control Name

    Hi, Does anyone know the VBA code for the following question: I have four buttons A, B, C, and D on an Excel spreadsheet. Each button is associated with a macro. But instead of four individual macros, I want to associate them with the same macro. When the button is clicked, the macro will...
  8. riskassure

    What does ++ mean?

    I came across a program at work that I could not decipher. I googled around and could not find any answers. Can anyone interpret the following code for me (code modified for presentation purposes): data abc; _n_ ++_n_ < n; set xyz point=_n_ ; workstn2 = workstn; set...
  9. riskassure

    How do I declare an array variable in Public

    I see... my code was attached to a form, so it wouldn't work. I have figured out a way around it now. Thanks! ~~CW~~
  10. riskassure

    How do I declare an array variable in Public

    Yes I declared at the very top, outside of any subs and functions, right below the Option Compare Database statement. The error message says: Compile error: Constants, fixed-length strings, arrays, user-defined types and Declare statements not allowed as Public members of object modules...
  11. riskassure

    How do I declare an array variable in Public

    Hello, I tried using the following code: Public X(1 to 50) as string But when I compiled it, I got an error message. How can I fix this? Or is it even possible to create an array variable in public? Thanks in advance ~~CW~~
  12. riskassure

    resolving a macro variable to another macro variable

    Thanks.. that did it!!! ~~CW~~
  13. riskassure

    resolving a macro variable to another macro variable

    Hi, I have the following question: I have a bunch macro variables defined in a program: %let ADX = 2 %let BDX = 21 %let CDX = 13 %let DDX = 5 %let EDX = 10 later in the program, I have the following macro defined: %macro test(z); data newdates&z; set olddates; if ref in (&&z.dx) and...
  14. riskassure

    creating an array

    I have a large table containing hundreds of data fields. There are two sets of fields I'd like to use in particular: Code1 through Code20, as well as Code1Dt through Code20Dt So in my data step, I have the following: array Code{*} Code1-Code20 which works fine. However, when it comes to...
  15. riskassure

    How to run a SAS program using VBA?

    Hi, I am trying to write a program using VBA in Excel to run a SAS program (a .sas file). Does anyone know how this can be accomplished? Thanks in advance! ~~CW~~
See more

Part and Inventory Search

Back
Top