Universal path for exporting table

[kspabo]

I've created a macro that will export one of my tables to a .csv. Everything is all fine and dandy, except that I need to find a way to have this command work on any computer. As of now, the command exports to C:\Users\Kody\Documents, and can only do so because this path exists on my computer. But if I were to send this Access file to someone else to use, they would get an error stating that the specified path is not valid. Is it possible to create a general export directory which would work with any computer this is ran on?

[alansidman]

Paths will vary according to the operating system employed. ie. Win7 and Win XP have different path settings. You may have to provide an option (an inputbox) in your VBA asking the user where they want the file exported and then use that as the file path.

[kspabo]

EDIT:

I've actually figured out how to use a basic window prompt, but is there any way to get a Windows file explorer window to show so that you can select your folder, rather than manually inputting the destination?

[ssanfu]

There is a "Browse for folder" example at http://access.mvps.org/access/api/api0002.htm

I use different code, but I can't remember where I found it.

Google: "Browse for folder VBA"


Edit
Also see http://www.access-programmers.co.uk/...d.php?p=440522

This is pretty slick: http://www.your-save-time-and-improv...ct-folder.html

[June7]

Could maybe export to the same folder the db resides in by using the CurrentProject.Path method.

[fredz]

You can also utilize the Environ() function to access the Windows Environment Variables.
Like UserProfile, Temp, WinDir, etc.
Fred