VBA/Notepad - Please Help

[cdeep]

Hello all,

I'm new to the forum and pretty new to programming too. I'm trying to work on a problem that is pretty difficult for me. Hope one of you guys can help me.

Here's what I'm trying to do - I have a list of words in an excel sheet. I'd like to open an existing text file and compare the list of words (in excel) with the words in the notepad file and prompt if there is a word that does not match with any word in the list. I know how to open a notepad file and other basic stuff. any help will be appreciated. Thanks!

P.S- I searched the forums. I could not find anything similar. Sorry if the issue has been addressed!

[RobDog888]

Welcome to the Forums.

You can open an Excel workbook by using code like so...

Option Explicit
'Add a reference to ms excel xx.0 object library
Private moApp as excel.application
 
private sub form_load()
    set moapp = new excel.application
end sub
 
private sub command1_click()
    dim oWB as excel.workbook
    set owb = moapp.workbooks.open("C:\Test.xls")
    if owb.sheets(1).cells(1, 1).value = strFirstMatchVar then ' assuming that this is your read in textfile value: strFirstMatchVar 
        'do nothing since found
    else
        msgbox "not found"
    endif
    owb.close true
    set owb = nothing
 
end sub