Search results for query: *

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

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

Oh thank you, yes it did! ~~CW~~

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

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

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

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

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

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~~

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

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~~

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

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

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

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~~

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~~

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

Very interesting! Thanks a bunch folks! ~~CW~~

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

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