LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 44
Default Excel macro to open Notepad and save with Date/Time in filename

I've tried to create this macro using the Shell command which works for
opening Notepad but I can't get the part about putting the date and time into
the filename of the Notepad file. The date and time format could have blanks
between such as mm dd yyyy hh mm ss but if it has underscore or other
characters that is ok.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel wants to save an open file to another filename in VBA script BPoppe Excel Programming 0 November 9th 07 09:24 AM
Newbie, how to save file with date and time as filename Michael Excel Programming 6 March 30th 07 05:44 PM
Date Filename Save as Dialog Macro Thingy!!!!!! Cobbcouk[_2_] Excel Programming 2 March 31st 06 06:46 AM
Can a MACRO prompt for the filename to open and/or save? Dave Peterson[_3_] Excel Programming 1 September 3rd 03 04:53 PM
Save Filename+Date+Time? Scooby912 Excel Programming 1 July 25th 03 06:21 PM


All times are GMT +1. The time now is 08:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"