say i have two excel files ,file1 and file2.
file1 has coumn1-name/id,column 2-text in chinese,col3-text in french etc.
now i have to search if name/id of file1 is present in file2.
if present i need to copy contents of col2-text in chinese to file2 respective cell.
can any1 help me do this in vbscript.? I am new to text complete and dont have much idea on this.
Thank you
Hi,
Range object will help you to solve your problem.
SYNTAX :
objRange.Find("Text to be searched in excel file)
http://stackoverflow.com/questions/19876039/how-to-find-an-exact-value-in-an-excel-sheet
https://msdn.microsoft.com/en-us/library/office/ff839746.aspx
Thank you that was great help.
I am trying to find Range on columns in vbscript
Excel1.Sheets("sheet1").Columns.Range("A4")
Object not supported error is displayed.
Can any1 help?
I need to Go select the entire column range,search and find the cell index where text is present .
Then search for a new column name(say Name/id) ,goto the same index and paste a new text in that cell.
