open spreadsheet via dialogue

[pb21]

I have the following code that allows me to get data from an excel spreadsheet:
Set objXLBook = GetObject("d:\Datastore\EIF.xls")
Set objXLApp = objXLBook.Parent
Set objQryStudentSheet = objXLBook.Worksheets("Student details")
Set objQuerySheet = objXLBook.Worksheets("Agent details")

I would like to however do it a little differently with the user selecting the file (spreadsheet) of their choice rather than having one location as each spreadsheet will be the same but for a different centre.

How do I do this and make the returned result an object as above?

help or direction would be much appreciated.

regards

 

[Vassago]

Check the example out located here for creating a common windows file selection dialog box:

http://access-programmers.co.uk/forums/showthread.php?t=97638

You can assign the selection by the user to a variable, which you can then use in your code.

You can also use Microsoft's build in dialog box, but it doesn't work in all versions and you must enable the reference:

http://support.microsoft.com/kb/279508

 

[ghudson]

Searching the forum is a great way to discover and learn the answers to your Access programming questions.

I have a working example in my Browse [Find a directory or file] sample.