Hi all,

I have been doing a lot of work in Excel, and have found that using application.getopenfilename gives more control to the user as the program is more dynamic.

I am now doing some work with MS Project, in order to export into an Access Database (hence why I am posting here. Any chance of a Project forum here? ;) ) but I can't find a command that will create this dynamicity.

I would like the user to be able to specify which database they want the project information exported to. Does anyone know how I can do this?

Thanks

Patrick

Visit my site: http://www.drybonesuk.com

__________________
Visit my site: http://www.drybonesuk.com

You are doing this FROM Project to Access? Or is this something you want to invoke from Access?

If from Project, what does your code look like so far? Your best bet might be to use a canned procedure like TransferDatabase.



mmcdonal