search a file

Dear All I have and excel file includes records which in column H as range H1 = 360001 H2 = 360002 H3 = 360003 ETC I asked my clients to save a document in shared folder names with what mentioned above, as a copy of invoice for 360001 named 360001 and the same with the rest all what i need to...

Hi there to evereybody! Im Juan and i'm writing from argentina. I have a TXT file with millons o lines (literally) like this: 22082019;01092019;30092019;20000163989;D;S;N;0,00;0,00;00;00;ETCHEVERRIGARAY JUAN CARLOS I would like to use a command button to search for the number i've marked...

Hi! I would like a search macro to retrieve a file from a subdirectory and the file will have a lot number with report on end and be a .xlsm. and then it retrieves it. Example; Click button for msgbox to ask what lot number user enters it then it searches through "L:\Job Packets"Product""Lot...

Hi all, My VBA skills aren't good enough for me to experiment so I'm hoping someone can tell me if the following is possible :confused: In short, I have inherited a large number of excel documents from which I need to collate a report. I can do so manually but obviously I'd prefer it if excel...

Hi, This is my basic template to search through a specific file type within a folder. ChDir ("Your Directory Here") 'Selecting a folder to search through. With Application.FileDialog(msoFileDialogFolderPicker) .Title = "Please select a folder" .Show...

Hi All I am looking for a simple bit of code to seach column D for a name and select the next cell in column E. The data sould be validated so there are no duplicates, but the list will end up in excess of 1000 names so I would like a button at the top to prompt for a name, then auto...

Hi All, I have list of ID's in excel. In folder there are file which has this ID's. I need to search the folder with this name and open the file. Can you help me in creating macro for this. I receive error if one particula ID's is not available in the folder. I want that id to be skipped and...