Allow User Change Data Source Path

Hello everyone,

I am new to the VBA side of excel. I built a spreadsheet with minor macros that tracks information I currently export from a tracking system. Now that we have viable data at one location, there is need to go network wide. My problem I can export the data to excel then into access on my desktop or laptop but, now there will 12 other workbooks and databases out there. I do not want to be "the king' of data. I would like the users to be able to change the Data Source path on as an as needed basis.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thank you for the help. I try run the file picker but, does not see the database in the location. My other question do attach this the rest my code? Does picker fire each time I run the export macro.

Thanks Again

I figured out the file issue typo.

Thanks

Oops. I see it now. I'm glad you got it.