Hi All,
I have a spreadsheet that has to impot data from other workbooks so at the moment it is set up so I use the workbooks.open("C\FolderName\workbook.xls") method. Iwas wondering is the GetObject method application.GetObject(,"C\FolderName\workbook.xls") is better in teams of being ableto open workboosk quicker and take up less memory. The only reason I ask is that people want this workbook to import the required information quicker (it takes about 1.5 mins at the moment) and I was hoping that the GetObject method may be a better and efficient alternative?
Many thanks and regards.
DW