I tried with LastAccessTime function insted of Created function.. Here is my modified code. Please Check this and could you please modify and give me the updated one.. Am still lerning it.. Awaiting your replay.. And one more thing.. Thanks a lot.. Thursday, July 9, AM. Try using LastWriteTime instead of LastAccessTime last access indicates the last time a file was read and you're interested in when it was written.
Thursday, July 9, PM. Hello Madhu,. Files copied to a new destination path will keep the same file name. To rename the copied file, simply include the new file name in the destination path.
For example, this will copy the file to a new location and the file in the new location will have a different name:. Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Font-size: A A A. This method allows us to copy one or more files from one location the source to another destination. Sunday, May 26, PM. I posted the link to the Shell documentation.. You must use the "CopyHere" method to copy folders and groups of files. I am aware it copies to the clipboard. I had hoped that a "paste" would likewise paste the clipboard to a file.
It does. You can only copy one file at a time. That is decidedly not VBA. It is a command line executable created in Visual Studio vb. Net I only posted it to show that I was able to solve my problem, but not in vbScript. I could use the same exe in Python or Power Shell. Given that then what is your question? Call the EXE from vbscript using the "run" or "exec" commands.
Got it. That really should have been my first question. Excellent choice. Monday, May 27, AM.
0コメント