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...
...behind it. Is there a way to ensure that the message box cannot be seen or does not display? Here is my code:
Private Sub cmdAccept_Click()
' *--------------------------------------------*
' * Verify the user specificed Folder path *
' * locations exist. *
'...
...both running Excel 2003.
I think I know where it is failing but I'm not sure why. Here is the code that does a call to the failing procedure:
' *----------------------------------------*
' * STEP05: Copy the Template Supplemental *
' * form to a Supplemental Data *
' *...
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
'...
...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 <> ""
lCount = lCount + 1
Set inputWB = Workbooks.Open(InputDIR _
& "\" _...
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!!
...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:
' *----------------------------------*
' * Retrieve deductible amount. *
' *----------------------------------*
' *
Deduct_AMT =...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.