Macro Output File Naming Problem

  • Thread starter Thread starter data123
  • Start date Start date
D

data123

I 'm setting up a macro to export a file. How do I export a file wit
a specific parameter as the file name? For instance I wanted to nam
the file based on the specific field in the report
I am running muliple reports for muiltple users and I want to name th
report based on the user Id I'm running the report on.

I tried usin
c:\[reports]![test]!_usagereport.rtf as the file name
I getting the file name as [reports]![test]![userid]_usagereport.rtf

instead of userid1_usagereport.rt

How do I fix this
 
Data123,

Can you please give some more details?... What actions are you using in
your macro? How is each userid report being generated? And how does
the report "know" which userid to use? Etc.
 
Back
Top