Export multiple excel file base on fosUsername()

[Nishikawa]

Hi,

I would like to know if it is posible to export multiple excel file base on fosUsername.

E.g. The database has 13 reports. When user click a button, the database will check a "User name" Table and find out the number of file that belongs to the user and export the corresponding files.

Therefore, if User A has 6 file under his name, the database will export only the 6 file and and not the rest.

 

[Calvin]

1. create a table with two fields (UserName and FileNames)
2. store the UserName in the table with the corresponding FileNames all concatinated in one field
3. have your function use a Dlookup method to retrieve the FileNames from the table for the corresponding UserName
4. use a parse or Split function to separate the concatenated string of FileNames into an array
5. use a Do-Loop method to cycle through the array and export your filename to Excel using Docmd.acTransferSpreadSheet or similar