Using Output To command

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hello All

I want to use a series of Output To commands to create and save a series of
reports. Ideally I would like the file to be saved to the same location each
time, but with a filename that will include (at the end) the text that is
contained in a certain textbox on the current form (this text in fact refers
to the 'period' to which the report relates). Looking at the parameters of
the Output To command, I can specify a path and filename in the Output File
field, but this would obviously overwrite one with the next - hence I need
to assign different filenames.

I'm sure this must be possible, but cannot see how. I hope someone can help.

Many thanks
Leslie Isaacs


.

Relevant Pages

  • RE: Running a macro across a folder
    ... number in the code above with the number you delect in the recorded macro. ... filename and the new filename? ... saves third Party Excel reports one directory c:/orchard from email ... and re-saves it as long as I specify both filenames. ...
    (microsoft.public.excel.programming)
  • Re: Discovering variable types...
    ... >I considered adding an Overlapped flag to my open procedures but bailed on the ... >memory allocations for your variables from disk as well. ... VWIN32_DIOC_DOS_INT13 Performs Interrupt 13h commands ... FOpenWrite(FH, 'FileName') ...
    (comp.lang.pascal.delphi.misc)
  • RE: Running a macro across a folder
    ... filename and the new filename? ... saves third Party Excel reports one directory c:/orchard from email ... each month - I wrote the original macro which 're-brands' one report with ... sheets in a specified folder? ...
    (microsoft.public.excel.programming)
  • Re: How to find queries which are not longer required in a mdb
    ... Is there a tool available to check the necessity of a Query. ... Queries are used in Forms and Reports. ... Query: Product Sales for 1995 ... GetTempFileName FilePath, "Obj", 0, FileName ...
    (comp.databases.ms-access)
  • RE: Running a macro across a folder
    ... filename and the new filename? ... saves third Party Excel reports one directory c:/orchard from email ... each month - I wrote the original macro which 're-brands' one report with ... sheets in a specified folder? ...
    (microsoft.public.excel.programming)