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 derfloh 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. 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

    ...= "C:\MyHTMLfile.html" Open MyFile For Input As #1 Do Until EOF(1) Input #1, readdata If Not Left(readdata, 1) = "*" Then EmailBody = EmailBody & " " & readdata End If Loop Close #1 Call SendNotesMailHTML(ToAddress, , ...
  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?

    ...n; set xyz point=_n_ ; workstn2 = workstn; set xyz nobs=n end=end; if workstn ¬= workstn2 and 20 <= a < 30 then a = a*0.5 ; if workstn ¬= workstn2 and 10 <= a < 20 then a = a*0.6 ; if workstn ¬= workstn2 and a < 10 then a = a*0.7 ; run; Specifically, what...
  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'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 create an array for Code1Dt through Code20Dt by array CodeDt{*} Code1Dt-Code20Dt I...
  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~~
  16. riskassure

    treating text as formula

    Thanks! In the post, it mentioned a function called Evaluate, which is not available in Excel 2003, so what I ended up doing is to create a user defined function called Eval: Function Eval(x as string) Eval = Application.Evaluate(x) End Function And this works just as well! ~~CW~~
  17. riskassure

    treating text as formula

    Hi, I have the following problem: in cell A1, I typed "B1+B2". In cell A2, I want to convert the text in A1 into a formula and then calculate that formula. So if B1 = 5 and B2 = 6, A2 should read 11, and if B1 = 3 and B2 = -1, A2 should return 2. Of course, I could have just use the formula...
  18. riskassure

    Dynamically Changing Code

    Very interesting! Thanks a bunch folks! ~~CW~~
  19. riskassure

    Dynamically Changing Code

    Here's my dilemma: the values are neither numbers nor simple strings, but texts that are really pieces of code, like "if A < B". So the drop down has several values, and all values represent very different pieces of code. However, when they are inserted properly, and somehow "interpreted" as...
  20. riskassure

    Dynamically Changing Code

    Hi, I have the following question: I have a form which contains a drop down box and a button. The values of the drop down box are texts of partial VBA code. Underneath the button is a VBA code, which looks roughly like private sub blahblahblah() blah blah blah blah blah blah...

Part and Inventory Search

Back
Top