Posts by Snoopy1990

    Hi All,


    This is my 1st time using macro and would like to create and excel which can locate the files name based on the serial number. However the serial numbers(highlighted in green) are part of the title of the excel workbook. The time and date changes also (highlighted in green) which I don't think matters.


    Example of file workbook name:
    80-178111-12_282214-3801_FTP-Part1_20160308_195958.xls


    Within the workbook, in sheet 1 from cell (A47:H53) is the data which needs to be shown. The data in here are all based on formulas. Would like this to be shown as text.


    So far I have come up with 2 separate macros but can't figure out how to combine them.


    To look up for serial number:




    To copy from closed work book and paste. This however i have to set EnableCalculation to False.



    Appreciate the advice as I would like to learn up on macros.