Search results for query: *

Hello all, I have a report I'm generating using "PROC REPORT". I would like to insert an image (logo) into the first title line on the report. I want the image to be positioned at the very left side of the report, and I'd like to add text to the first title line of the report. So, I'd like the...

Hello all, Another issue - I have an Excel 2003 macro that displays a form. If the form fields are entered incorrectly, a message box pops up with a message. The user clicks the "OK" button, but the message box does not go away. The main user form display and the message box can be seen behind...

Hello all, I have an excel macro that runs fine on my machine, but when the macro is used on a user's machine she gets the following error: VBAProject - 5: Invalid procedure call or argument We are both running Excel 2003. I think I know where it is failing but I'm not sure why. Here...

Hello all, I have some code that uses the DIR function to loop through excel workbooks in a directory. This code works in VBA 2007, but in VBA 2003 it is not picking up the excel filenames in the directory. Here is a sample of the code: lCount = 0 sFil = Dir("*.xls") Do While sFil <> ""...

Hello all, I am attempting to use VBA code to read certain cells on a worksheet. I'm having trouble getting the decimal values of in cells with amounts. For example, a cell has the value 1,000.53. When I use the following code to retrieve the cell value: ' *----------------------------------*...

Hello all, Does anyone know where I can find a sample Excel 2003 VBA macro that will read one or more excel files from a specific folder location, retrieve data from certain cells of each excel file, and write the data one row at a time to a new excel file? Many thanks MM

Does anyone know where I can find a sample Excel VBA macro that will read one or more excel files from a specific folder location, retrieve data from certain cells of each excel file, and write the data one row at a time to a new excel file? Many thanks MM

Hello all, Does anyone know how to use the "PROC PWENCODE" procedure to create an encoded password and pass the value to a macro variable? Here is the code I tried: proc pwencode in='&usrPWD' out='&e_PWD'; run...

Hello, I would like to pass multiple parameters to another form using the "cflocation" tag. For example: <cflocation url="CIOM2.cfm?ClientID=#GetCIOMID.ClientID#"> I would like to pass more than just the ClientID. Can someone post sample code on how to do this? Thanks :)

Hello I have a form with 35 questions on it. All of the questions are optional, but if the user skipped some questions I'd like to be able to display a message (possibly on a pop-up screen or message box) that lets the user know which questions were skipped and to confirm that the skipped...

Hello, We have a form which the user can respond to 35 questions using radio buttons. These questions are optional, so when the user submits the form he/she may not have responded to some of the questions. I would like to be able to have a form "pop-up" asking the users if they meant to skip...

Hello all, I am working on BO XI R2. I imported a universe to my local workstation and made several changes. When I attempted to export the universe I received an error stating something like "unable to convert unv to unw", and the export failed. I closed and restarted BO Designer, then...

Hello all, I would like to dynamically build a set statement with multiple files. The catch is that the every month a new file is created, and the last part of these files contain the date in "YYMM" format. Here is an example of the data step and the "set" statement: data all_prft...

Hello all, I have a file that was created from a SAS data step that I need to check the file size on. Is there anyway I can do this in SAS? Thanks, Mark :)

Hello all, Does anyone know how to check for an abort or abend from a prior data or proc step? I need to check for a particular return code or abend at the end of a sas program. Depending on the results from the find, send an email message to various users. Many thanks, Mark

Hello all, Does anyone know how I can check for an error that originates in an SQL Procedure? I'd like to check for a bad return or error code. Here is a sample of the query: create table myown_data as select * from connection to db2 ( select distinct...

Hello all, Does anyone know the correct format for using SYSPARM on a Unix platform? I'm executing a SAS program from a Korn shell script. I want to pass a run indicator ("TEST" or "PROD"), and a process date. Below is an example of what I think is the correct use of sysparm: #...

Hello, I am trying to return from a query, a list of employees that entered more than one timecard within the same reporting period. Here is the query I'm trying to develop: --------------------------------------------- SELECT a.LastName AS LastName, a.FirstName AS FirstName...

Hello, I am trying to run an application on a Windows 2000 client machine. The application was written in VB6. When I try to run the app I get the following error: Run-time error '429' ActiveX component can't create object The application then closes. This only occurs on Windows 2000...

Hello, I am trying to run an application on a Windows 2000 client machine. The application was written in VB6. When I try to run the app I get the following error: Run-time error '429' ActiveX component can't create object The application then closes. This only occurs on Windows 2000...