You can do it manually while recording a macro. Try the following from
worksheet menu

Data - Import External Data - New Database Query

Select Excel File.



"JeremyJ" wrote:

Our company has multiple locations with a server at the main office where all
of our data is accessed and stored. Is it possible to use VBA from a remote
location to access data in an Excel 2007 Document from that server?

If there is a solution can you please point me in the right direction.
Thank you.