Change Import/Export directory via VBA

[Magster]

Hello all,

I would like to change the path of a stored import (Excel) via VBA rather than displaying the Manage Data Tasks window to my end-users. I'd like to display a popup allowing them to search for the correct folder, and then I would insert the selected string.

So far I found Application.CurrentProject.ImportExportSpecifications.Item but that is read-only and asking for the name of my stored import.

 

[ghudson]

Did you try searching the forum? Browse [Find a directory or file]