Hello everyone. I am very new to VBA programming. programming mostly in C++ even this problem is hard.
so starting with what you'll probably find as simple. crawl before walk. I have main spread sheet that is open.
and I also have a few xls files that are closed, but the sheets are laid out identical. I would like to know how
to take cell C17 from one of the closed files, read the data from it, then put it in cell A3 on the open sheet.
once I get a grasp on this, the other cells should be a snap. thank you in advance.
I can open the files but can not seem to get just a single cell from it. other examples I see on line, which do
help, seem to copy whole sheets. not just a single cell. and the syntax is quite different than what I'm used
to.
Bookmarks