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 found the issue. The folder path locations were too long. Once we shortened the paths the macro worked. Thanks!

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

Hi Fumei, Many thanks for your explanation and added input. I knew that 2007 was interpreting the function differently than 2003, I just didn't know exactly why. Your explanation adds clarity. I must remember to be explicit. Thanks again!

Okay, I was able to resolve this issue. I just changed the following code: sFil = Dir("*.xls") to: sFil = Dir(InputDIR & "\" & "*.xls") This solved my problem and I was able to run the code in both Excel 2003 and 2007. Thanks!

Hello all, Here is a better example of the code I'm using: lCount = 0 sFil = Dir("*.xls") Do While sFil <> "" lCount = lCount + 1 Set inputWB = Workbooks.Open(InputDIR & "\" & sFil) inputWB = ActiveWorkbook '...

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

Many thanks to all for your suggestions. I defined the amount variables as "Double", also now just using the following: ' *----------------------------------* ' * Deduct Amount. * ' *----------------------------------* ' * Deduct_AMT = Range("E20").Value Thanks again!!

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: ' *----------------------------------*...

Thanks for the reply Skip, No, I haven't started coding yet, I just know what I'd like to do. I've done something very similar in the past, where I've read data from a SQL server table and wrote the data out into individual sheets in a workbook, then saved the workbook to a designated folder...

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

Thanks Chris, I've seen this example before, I was just hoping there was a way to do this without having to write the encoded password out to a file. After some research it appears that this is the only option for now. Thanks again, M :)

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

Hi Lyndon, Thaks again for your help. I was able to use your example and pass variables between forms. Thanks again! M :)

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 :)

Many thanks for the tip Lyndon!! Does it matter where the JS function is coded, or can I code it anywhere in the .cfm file?? Thanks again for your help, it is very much appreciated!! M :)

Thanks Lyndon, I'm new to Coldfusion and Javascriopt,so I'm not sure how to find my answer -- All I would like to do is; if the user has skiiped some questions, after the "submit" button is hit, I'd like to dislay a pop-up window or message box that lets the user know that some questions were...

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