Web Development

Ask something
Discussion Locked

Macro in Excel to get values from a clos

0 helpful
4 replies

by ashishshekhar

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is there a way to program a macro which gets values from other excel files without opening the other excel files ? I ve tried to use the ADO function , but cant figure it out. Any assistance is appreciated

4 replies

by nsohenick

Go to Data>Import External Data>New Database Query. There you can let Excel know you are looking for another excel file. Then you can browse to find the file. You can use microsoft quesry to filter and manipulate the data. Then you will be asked where to out the data.

I use this feature then hide the worksheets that I place the data. I also allow for my spreadsheet to update the data range everytime it is open.

This discussion is closed to new replies.