Search results for query: *

Thanks for the input. Anything I learn I never consider to be a wast of time. I just have to figure out the proper code structure to use to access the worksheets I need. I've got the whole VBA subroutine written its just I just can't get connected to the workbooks I need to pull the data from. I...

I have to add cells from each sheet in the different workbooks placing the totals in cells of my EOM worksheet.Then I can easily sum the cells on the EOM sheet to give the catagory and YTD totals I need. Maybe an example will clarify the situation. Each of the worksheets I'm grabbing cells from...

Thanks for the response. Does it make any difference that there are four worksheets each in a different workbook? The output I'm trying to generate is an EOM report. My big problem is my background in procedural programming makes it easier to code in VBA since I don't really have the time to...

I'm coding an application where I have to reference certain cells in four closed worksheets each in an external workbook. I'm having a problem with the method I should use to do this. All the workbooks exist on the same server and the cells I need to reference are in the exact same locations on...