kavya_v
Occasional Contributor
Joined 11 years ago
User Profile
User Widgets
Contributions
Re: how to search for contents,copy text from one excel file to another excel in vbscript
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.1.8KViews0likes0Commentsissue in selecting values from drop down
I have to select values from dropdown iteratively and im using the following code. I can get the full name of the dropdown item but storing the value in a varaible and using it doesnot work Can any1 please tell where i went wrong.?? for i=0 to 1 Aliases.RCWinTrans9.wndRCWinTransX8Class.MDIClient.Acti_9_Smart_Test.Item.splitbuttonLanguages.dropdownbuttonOpen.Click 'To get the full name of dropdown item iteratively name=NameMapping.Sys.RCWinTrans9.Item.GetUnderlyingObject.Child(i).FullName 'log full name of the child in the dropdown 'This is working absolutely fine log.Message(name) Aliases.RCWinTrans9.wndRCWinTransX8Class.MDIClient.Acti_9_Smart_Test.Item.splitbuttonLanguages.dropdownbuttonOpen.Click /I am trying to click on the name ,but this throws runtime error name.click1.6KViews0likes6Commentshow to search for contents,copy text from one excel file to another excel in vbscript
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 you1.9KViews0likes3Comments