Importing/Exporting to current directory

[ustenmacduff]

I have a question about importing/exporting ...heres the command

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "SSN", "C:\SSN.xls", True

what I want to do is set this so that the C:\SSN.xls will instead be whatever the current directory the database file is in. Thats pretty much it. Thanks.

[RobDog888]

This will geive you the current db name and path.

Application.CurrentDb.Name