Posts by nmkhan3010

    Am having two excel file ‘s (“A” & “B”)

    “A” is updated till now. (Taken from the server not having the comments or resolution filed)

    “B” is not updated till now. (Local Drive file with comments or status of incidents update)

    My intention is copying the fields from A to B which are not available in the B file. (only copy the fields which are not in B & It shouldn’t be disturbed the match cases of both A & B fields)

    After copying the not matched fields from A to B file and we will work on that and add comments or status filed to that unmatched cases everyday. So, it shouldn’t be disturbed the match cases in B file.

    Work fields columns from A to S

    In two files common field is “INCIDENT NO” which is in “B” Column.

    Please find sample sheets & do the needful.

    hi,

    I need a macro for removing a immediate duplicate words in a documents.

    Example :

    Input: financial income income Input : interest income (here no repeated word income so remain same anywhere in the doc)
    Output: financial income Output: interest income (here no repeated word income so remain same anywhere in the doc)

    Input: unit: unit: INR
    Output: unit: INR

    Input : gain gain from sales
    Output : gain from sales


    In the above cases immediate repeated words removed manully like income, unit: & gain
    If there is no same repeated word it remains constant and it has not to be changed in anywhere.

    Ex: income from sales, unit: INR, gain from investments are replaced above words & will not be reflect anywhere in a document if it is having a single words income, unit:, gain.

    Wildcard Find/Replace : Please check and make this is in macro... Wild card is not working, please check and review once.

    Find = (<*>[email protected])\1

    Replace = \1


    please do the needful ...:):):)

    Hi


    Am having code of batch replacing strings and getting error for char more than 250, can any one help to fix this issue...


    My code is shown below:


    Thanks in advance ....

    Hi,


    Thank you for replying ....


    Sorry for inconvenience caused to you, now am attaching the same files in the ZIP folder.

    Please review once and code was running successfully but copying the files into the folder and showing message as "Does not exits" even if it having a same file in the folder.


    Thanks in advance for your consideration.................

    Hi,


    Thanks for replying and folder has created successfully but files are not moving into that and it could be a better to add source path as input box because path need to be changed everytime and everyday


    INPUTBOX("PLEASE ENTER PATH", "SOURCE PATH")


    Destination path is the same as input path....


    Please find the zip files for testing and thanks a lot for considering this......

    This is totally different previous post was regarding copying specific files based on the excel sheet value, if it is available give a comment as "Copied" and i f not available "Does not exits" and now i want to seperate the files with the common name and create a folder with the common name and copying all the files into that.


    i hope you understand my objective.....

    Hi,


    Am having number of documents in folder with common name like "FinancialTables" & "Taggedtables"


    I want to create a folder with the name financial tables and copied all the files with the name having financial tables in to that folder.

    I want to create a another folder with the name tagged tables and copied all the files with the name having tagged tables in to that folder.


    File formats .rtf, .docx , .pdf , .doc


    main objective is to sepeate a files with financial tables and tagged tables that are tagged with the file names


    PFA


    Thanks in advance .........

    Hi


    Am very very thankful to your hard and code was still not copying the files if it exits in my machine...


    I tried a lot but still not working both code and macro was running successfully with out throwing any errors but output folder was always empty ...


    Thank you so much....


    If you have time you can review or else skip this, it might be my excel problem and am very thankful to for your propmt response .....


    Once again Thank You................

    Hi,


    Please check once....




    Please see the above ....


    Settings are the same...

    Macro was running properly but not copying the files listed in A column but not giving any error message i think it was not looping here ....


    Can you please help me.......

    1. objFSO.CopyFile Source:=SourcePath & Range("B" & CStr(iRow)).Value & _
    2. sFileType, Destination:=DestinationPath

    Hi,


    i want to copy the list of files from A column and below macro was copied but it was not looping to copied command, can any one help me....



    Range is "Column A" and Msg box is "Column B" Format types .doc, .rtf,.docx , .pdf


    Please anyone help me in this regards or if possible make it as easier to loop and thanks in advance.



    <img src="https://www.ozgrid.com/forum/core/images/smilies/emojione/263a.png" alt=":)" class="smiley" srcset="https://www.ozgrid.com/forum/core/images/smilies/emojione/[email protected] 2x" height="23" data-tooltip="smile" id="wscSmiley_0_0">




    Code
    Range is "Column A" and Msg box is "Column B"  Format types .doc, .rtf,.docx , .pdf
    
    Please anyone help me in this regards or if possible make it as easier to loop and thanks in advance.
    
    
    <img src="https://www.ozgrid.com/forum/core/images/smilies/emojione/263a.png" alt=":)" class="smiley" srcset="https://www.ozgrid.com/forum/core/images/smilies/emojione/[email protected] 2x" height="23" data-tooltip="smile" id="wscSmiley_0_0">

    Hi,


    I need a macro for BROWSE, SEARCH AND COPY FILES FROM ONE LOCATION TO ANOTHER BASED ON THE LIST GIVEN IN EXCEL SHEET USING VBA.


    Range is selected in excel


    Source path: "Shold be given manually"

    Destination path: "Shold be given manually"


    Msg "Files Copied "


    Besides list name colum can we update "copied" if it found and "N/A" if it is not found.


    Format types: .doc, .rtf , .docx , .xlsx , .pdf

    Hi,


    I need a macro for BROWSE, SEARCH AND COPY FILES FROM ONE LOCATION TO ANOTHER BASED ON THE LIST GIVEN IN EXCEL SHEET USING VBA.


    Range is selected in excel


    Source path: "Shold be given manually"

    Destination path: "Shold be given manually"


    Msg "Files Copied "


    Besides list name colum can we update "copied" if it found and "N/A" if it is not found.


    Format types: .doc, .rtf , .docx , .xlsx , .pdf


    Please any one help me .....


    Thanks in advance.............

    Hi,


    Thanks a lot for replying.............


    In sheet2 "A" column i have created a drop down list of all languages from the range "C: column.


    Now if i want to select "Turkish" in A2 i need to scroll down from "Albanian" to "Turkish" (means 63 times i need to scroll down by down arrow)


    If we create a searchable drop down list in "A" column such as if enter "T" it will displays all languages having a letter "T"


    suppose if i enter "TUR" it shows tur list from that range ....


    Please Find the sample attachment.


    I need the result whether it has done by VBA or Userform or with formula no issues.....


    Thanks in Advance....

    Hi,


    I have data i need to count of fields based on the data by dialy, weekly and monthly.



    Weekly format : 03/01/2020-03/07/2020 , 03/08/2020-03/14/2020 .......................................... (this can be done through formula)

    Monthly format : 03/01/2020-03/31/2020 , 04/01/2020-04/30/2020 ........................................ (this can be done through formula)


    Above two columns are in weekly report and monthly report sheet and based on the data in sheet1 all the date fields get updated in weekly and monthly


    Just count and sumup all the fileds based on dates (Dialy, weekly, monthly)



    PFA and do the needful ...


    Thanks in advance...........


    :)