Export to excel witha a variable name

[Herkatus]

Hello!

I'm having a problem with access 2007 so I googled it and I stumbled with this site.

I'm trying to export a table form access to excel but I wan't the exported file name to be extracted from one specific cell in the table.

I thought about assigning tempvar with a sql query like

SELECT FIRST(table.column)
FROM table

and then using the tempvar as part of the name on the path of the extracted file. But it didn't worked.

Then I thought about using VBA but I don't have many knowledge to use it. Any Ideas?

TY