Posts by Paulandreaoc

    Hi guys,

    I have this column of information in a worksheet called "Report" in the column "J" I would like to develop a macro to change the writing of the column content for example if is written UNI_EN_ISO_IEC_17025_2005 change it for UNI EN ISO/IEC 17025:2005 and if is written UNI_EN_ISO_IEC_17025_2018 change it for UNI EN ISO/IEC 17025:200518, but I am not able to do it.

    I am struggling because this column "J" does not have always the same leght so I don't know how to difine the range.


    Thank you in advance


    this is the column:

    UNI_EN_ISO_IEC_17025_2018
    UNI_EN_ISO_IEC_17025_2018
    UNI_EN_ISO_IEC_17025_2018
    UNI_EN_ISO_IEC_17025_2018
    UNI_EN_ISO_IEC_17025_2018
    UNI_EN_ISO_IEC_17025_2018
    IO_09_DT
    UNI_EN_ISO_IEC_17025_2018
    UNI_EN_ISO_IEC_17025_2018
    UNI_EN_ISO_IEC_17025_2018
    UNI_EN_ISO_IEC_17025_2018
    UNI_EN_ISO_IEC_17025_2005
    UNI_EN_ISO_IEC_17025_2005
    UNI_EN_ISO_IEC_17025_2005
    UNI_EN_ISO_IEC_17025_2005
    UNI_EN_ISO_IEC_17025_2005
    UNI_EN_ISO_IEC_17025_2005
    UNI_EN_ISO_IEC_17025_2005
    UNI_EN_ISO_IEC_17025_2005
    UNI_EN_ISO_IEC_17025_2005
    UNI_EN_ISO_IEC_17025_2005
    UNI_EN_ISO_IEC_17025_2005
    UNI_EN_ISO_IEC_17025_2005
    UNI_EN_ISO_IEC_17025_2005
    UNI_EN_ISO_IEC_17025_2005
    UNI_EN_ISO_IEC_17025_2005
    UNI_EN_ISO_IEC_17025_2005

    Hi guys, I have this line code to let an user choose and open multiples files on excel, but if the user don't choose anything or close the window the code give me an error en el next line to that one, someone know how can I do to delete that error?

    Thank you in advance

    Code
    1. File_Name = Application.GetOpenFilename("Excel Files (*.xl*),*.xl*", , "Select Excel Files To Consolidate", , True)

    Hi guys, I have this macro that runs perfectly but I would like to use it in multiple files at the same time because right now just runs one at the same time, also I would like a little help because my "DataBase" is in another workbook is not in a sheet of the workbook I am working in, and right now to use the info in the "DataBase" I am adding a need sheet (in my actual workbook) with it, this is not the ideal, the ideal is write in the macro that the "Database" is in another workbook.


    I hope you can help me, thank you in advance


    As I said you before the inspectors names in sheet Anagrafica audit can be in cells a12:a17, a12:25 etc, there is not a specific range because in every file can vary, for that reason when I made the code I never specify the range, for example in this lines of code I made that anywhere where is the name "Pier Giorgio Spazzini" replace it for the number 6.


    Code
    1. Worksheets("Anagrafica audit").Cells.replace What:="Pier Giorgio SPAZZINI", Replacement:="6"
    2. Worksheets("report stampabile").Cells.replace What:="Pier Giorgio SPAZZINI", Replacement:="6"