Can someone PLEASE tell me how to make reference to a cell in a closed workbook WITHOUT using the R1C1 reference format. I need to use Cells(x,y)so I can loop.
It may just be a syntax thing but here is what I want:
activecell.value = Workbooks("C:My Documentsemployee.xls).Worksheets(1).cell(x,y).value ----> Or something to this effect. I know the syntax is off but if ANYONE can help, I would greatly appreciate it.
It may just be a syntax thing but here is what I want:
activecell.value = Workbooks("C:My Documentsemployee.xls).Worksheets(1).cell(x,y).value ----> Or something to this effect. I know the syntax is off but if ANYONE can help, I would greatly appreciate it.