Posts by jhas56788

    MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

    Hi Experts,



    I am looking for a macro that will do the the things mentioned below



    Macro will be placed in a macro.xlsm

    macro.xlsm & sample.xlsb both are located in different path so the path should be hardcoded in the macro, so i can change it as per my needs



    I am looking for a msgbox which contains the data as i mentioned in the sample file (The data will change but when i run the macro then i need a msg box of the same along with the data in the msgbox & that msgbox will only be closed by the paasword, cancel option should not work,without putting paasword in it that msgbox will not be closed)



    I have Highlighted the data for which i need a msgbox(In actual file there will not be any highlighted data, I have highlighted it only for understanding purpose)





    Thnx For the Help

    https://www.excelforum.com/exc…e-msgbox.html#post5383814


    https://www.excelguru.ca/forum…-MsgBox&p=44480#post44480

    Files

    I am looking for a macro that will

    First Check Close Excel.lnk is located or not & if it is located then move that Close Excel.lnk to C:\Users\WolfieeeStyle\Desktop\WolfieeeStyle\9.15\ & then run that Close Excel.lnk

    & If the Close Excel.lnk file is not located then do nothing



    Thnx



    https://chandoo.org/forum/thre…-file-by-vba-macro.44815/

    https://www.excelforum.com/exc…ba-macro.html#post5378034

    If u r unable to solve this problem Roy Sir then No issue atleast let me know

    I will break this process into two pieces

    & i will start a new thread to solve this problem in a different way & plz do not close that post bcoz if its not solvable then i have to think & solve it in a different way

    This code gives output but in column A plz see the sample pic all data is pasted to column A only

    I GOT THE CODE FROM GOOGLING AND SEEING MANY VARIATIONS OF THE VBA CODE AND I MADE THE SAME

    plz correct the code so that it doesnt get any errors

    Sorry Roy Sir i met with an error Problem is not solved

    issue is with this line

    Code
    1. Ws2.Cells.NumberFormat = "General"

    It paste the data column A only Plz help me in solving the same Sir