Saving temporary text file to particular location with the name of current Date and Time

Hi,
I am extracting my company daily production information from oracle application in text mode and i am copying the information to my worksheet using simple recorded macro at least minimum of 10 times a day to monitor the production.

The issue now is if i wanted to look back the production details by 9 am i don't have the data for since i have already updated with the latest reports.

So i just wanted to check the possibilities of saving the text report (Temporary internet file or from the clipboard since the data is already copied to clip board) in the location of "\\ZSI24261\PMS" (Shared Folder) with the name of current date and time after completing the below procedure. (Sorry I don't know where to post the code so i have given it here please advise me i will do it in future)

Sub Import_PMSData()
'
' Import_PMSData Macro
' Macro to import data's of Planning Management Report.
'
' Keyboard Shortcut: Ctrl+Shift+Q
'
    Range("L6").Select
    ActiveSheet.PasteSpecial Format:="Unicode Text", Link:=False, _
        DisplayAsIcon:=False
    Range("L6").Select
End Sub

I can save the text file when i am uploading the latest data's from oracle but the issue is this file has been shared within our department and some of staffs are updating this data from their side as well so they are not prompt on doing this action (Even i am forgetting to do this some times).

Expecting your support on this issue which will help us a lot.


Regards
Muralidaran.