Posts by nmkhan3010

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

    Files

    • TEST 1.zip

      (206.96 kB, downloaded 27 times, last: )

    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
    1. Range is "Column A" and Msg box is "Column B" Format types .doc, .rtf,.docx , .pdf
    2. Please anyone help me in this regards or if possible make it as easier to loop and thanks in advance.
    3. <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...........


    :)

    Files

    • NEW DPR.xlsx

      (29.03 kB, downloaded 25 times, last: )

    In Sheet2 column A languages has to be entered through drop down list but if I want to choose "Turkish" from drop down I need to scroll down until "T" letter comes, is there any possibility to search with letters and shows the match cases suggestions in the drop down list. Like if enter "T" it shows all languages having T...


    please find the attachment and please do the needful...


    :)

    Files

    • TTTT.xlsx

      (12.06 kB, downloaded 56 times, last: )