Hi all,
I need a search box in Microsoft word. Basically what it does it that for whatever string you typed, it will search a particular column (e.g. column G) in four different Excel spreadsheets located in four different folders.
If the string is found in one or more of the Excel files. Certain cells of the row where the string is need to be returned, a hyperlink to the Excel file also needs to return so that the user could open the file if necessary. The results need to one row of headers. The headers of all four spreadsheets are the same.
Any questions please let me know.
Thanks very much.
Kind Regards,
Jason
Hello,
I have very good programming skills with VB/VBA and MS Office Application automation including Word and Excel.
I can write a customizable VBA for you that allows flexible and customisable selection of cells to search and cells to copy as well as search folders. Macro would keep have ini file to manage the required folders, and cell addresses
Please, send me demo files (1 doc and 3 xls) to make you a demo.
Define the ms office version that you wotk on.
Show me how the demo doc file will look after the macro runs.
Thank you in advance.
I have 4 years experience in VBA Macro, I have already worked with Whirlpool USA with an automated analytic tool and I am currently working on big energy project from Poland.
From the description, this project seems easy but need to check for the time calculation. Please share the document.
I'm a hungaian student from romania, i learn programming in Politehnic University of Timisoara.
I have one year experience in visual basic and i also won excel and vba contest.
I'm working fast and precisely.
Greedings
I can have your job ready in 1 day.
I would like to ask some details for the job like, are the excel files that will be searching at fixed or you want to manually change them, are the columns to be searched and the returned cells fixed too and how do you want the returned data appear to you?
Thanks in advance.
Sincerely yours
Greetings!
IT engineer with excellent VBA skills, at your service.
Let me code that script for you, it will be fast and reliable.
I'm ready to start working now, let's get things done!
Thank you.