Back to discussion

Saving Excel file w/ Date as Name w/ VBA

Last post was 05 Sep 2001 at 20:59
vb6 United States
  • 19 years ago

    I'm opening a text file in Excel and formatting it. Then, I would like to save it in Excel format with the date as the name of the file.


    This process will occur daily, as part of a subroutine, so the date/name will need to be variable. I'm doing this with VBA.


    Thanks in advance for your help.


    Jason B.

    Report abuse
  • 19 years ago

    Are you using VBA?

    Report abuse
  • 19 years ago

    Yes, I am using VBA.

    Report abuse

Post a reply

Enter your message below

Sign in or Join us (it's free).

VB 6 forum discussion

VB 6 tutorials

Quick links

Recent activity

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Web Development

Developer Jobs

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

Cancel
“You can stand on the shoulders of giants OR a big enough pile of dwarfs, works either way.”