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

    How To Insert An Image Using Proc Report

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

    Message Box Stil Display After Clicking OK Button

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

    Invalid Procedure Call or Argument Error

    Hello all, I found the issue. The folder path locations were too long. Once we shortened the paths the macro worked. Thanks!
  4. mmignot

    Invalid Procedure Call or Argument Error

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

    DIR Function Work in VBA 2007 But Not in 2003

    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!
  6. mmignot

    DIR Function Work in VBA 2007 But Not in 2003

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

    DIR Function Work in VBA 2007 But Not in 2003

    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 '...
  8. mmignot

    DIR Function Work in VBA 2007 But Not in 2003

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

    EXCEL: Decimal values in Cell Not Being Picked Up

    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!!
  10. mmignot

    EXCEL: Decimal values in Cell Not Being Picked Up

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

    Sample Excel 2003 VBA Program

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

    Sample Excel 2003 VBA Program

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

    Sample Excel VBA Program

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

    Assign Encoded Password To Macro Variable

    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 :)
  15. mmignot

    Assign Encoded Password To Macro Variable

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

    Pass Multiple Parameters Using CFLOCATION

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

    Pass Multiple Parameters Using CFLOCATION

    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 :)
  18. mmignot

    Create A Pop-up Form to Confirm Input from User

    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 :)
  19. mmignot

    Create A Pop-up Form to Confirm Input from User

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

    How Ask Uer for Confimraiton of Responses On Data Entry Form

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

Part and Inventory Search

Back
Top