find path and filename of active excel document

[J.Wells]

Try, ActiveWorkbook.Name ActiveWorkbook.Path Joe

[Guest.Visitor]

find path and filename of active excel document

I am using vba in excel to convert a xls document to csv. Currently I have the path of the xls document hard coded. Does anyone know in vba how to find the path and filename of the current excel document that is active? Thanks

[Guest.Visitor]

find path and filename of active excel document

Thanks, that works.