Dear all,
I am looking for some assistance. This is not home work or anything to do with my job - I just want to do this for my own benefit. Ok here goes:-
I downloaded Visual Basic 2008 Express Edition (Microsoft Visual Studio 2008 Version 9.0.30729.1SP) - mainly because it was free !!!
I want to open two separate existing excel files. I want to check if the contents of say cell A1 (from first file) are in the second file. I have used VB6 in the past (when I say past I mean very past). Can someone point me in the right direction here i.e a good website etc. I have googled myself to death and have not found anything useful (or rather that I could properly understand
).
I am sure there must be a "VB 2008 for complete idiots" book out there so if anyone knows then please let me know.
I have used VB6 to interact with txt files in the past but I cannot recall interacting with excel files. I know that VB6 and VB 2008 are different beasts and I am trying (in vain) to apply my fading memories of VB6 to VB 2008 without much (any) success.
To be honest the files are not that big so it would not take that long to go through it manually. However my stubornness has gotten the better of me.
I am open to the fact that I may not have the necessary skills to carry this task out and that I will have to take a VB course - I will probably do this in any case.
Thanks in advance for any help that you give
Kind Regards
Mr. W.A Snow
Comments rated to be Good Answers:
Comments rated to be "almost" Good Answers: