T
Tony T.
I am setting up a macro to export a query as a .csv file.
I understand it needs to end up in the same location each
time for the macro. I would like to use %USERPROFILE%
\Desktop so that no matter who the user is it will end up
on their own desktop. It takes it as literal text. Is
there a way to use this in a macro to get it to understand
the environment variable? Thank you for your time.
I understand it needs to end up in the same location each
time for the macro. I would like to use %USERPROFILE%
\Desktop so that no matter who the user is it will end up
on their own desktop. It takes it as literal text. Is
there a way to use this in a macro to get it to understand
the environment variable? Thank you for your time.