How to paste from clipboard to already existing text file ?

Hello Forum members,

I am wondering if there is a possible way to paste the data from clipboard to a already existing text file after deleting the old text in it and save it with VBA?
I have a text file Data.txt at the location C:\MyData\Data.txt. What I want is to first delete the existing text of the file and then paste the data present in the clipboard and save it even without opening the text file in the whole process.

Is it possible or I am asking something silly?

Thanks in advance.

Originally Posted by patel45

Why not delete file and create it again ?

Sorry to say that but didn't expect such a reply from a Valued Forum Contributor.

Originally Posted by Norie

What Patel45 has suggested is the only to do this.

Yeah, I understood what Patel45 said but couldn't believe it because I thought VBA had a solution to this. I have searched google and other forums as well and found that there are experts addressing the issue closely related to my query. But their solutions, codes and requirements were really very much complicated and beyond my capability to understand. So I thought it would be better if I submit a query in this ExcelForum as I have lots of respect for the experts over here and I have always found the answers to my queries.

I still believe that VBA has the solution to my query. Lets see if a master of VBA suggests a possible way to do it.
So lets hope that someone would be able to answer it.

Thanks & Regards.

hi sktneer, I do not understand refusal to delete the file if its content is deleted, option as you want it without deleting the file

Please Login or Register  to view this content.

Originally Posted by watersev

hi sktneer, I do not understand refusal to delete the file if its content is deleted, option as you want it without deleting the file

Please Login or Register  to view this content.

Thanks a lot watersev ! for helping me.
I am getting compile error and it says user-defined type not defined on line 3 i.e.

Please Login or Register  to view this content.

Please suggest what can be done to correct this compile error?

Moreover I have no objection in deleting the text file and recreating it with the same name. I am sorry, I didn't mean that.

Thanks once again for finding some time to help me with this code.

Regards.

For this code to run, you need to add a reference to the Microsoft Forms 2.0 Object Library.

To do this, follow these steps:
On the Microsoft Visual Basic Tools menu, click References to display the References dialog box.

The References dialog box shows all object libraries registered with the operating system.
Scroll through the list, and then click to select the Microsoft Forms 2.0 Object Library check box.

If the Microsoft Forms 2.0 Object Library check box isn't available, follow these steps:
Click Browse.
Navigate to the file Fm20.dll, located in one of the following folders:
In Microsoft Windows 95/98, the file should be located in the \SYSTEM folder.

-or-
In Microsoft Windows NT or Microsoft Windows 2000, the file should be located in the \SYSTEM32 folder.
After you have located the file Fm20.dll, in the Add References box, click Open.

Originally Posted by watersev

For this code to run, you need to add a reference to the Microsoft Forms 2.0 Object Library.

To do this, follow these steps:
On the Microsoft Visual Basic Tools menu, click References to display the References dialog box.

The References dialog box shows all object libraries registered with the operating system.
Scroll through the list, and then click to select the Microsoft Forms 2.0 Object Library check box.

If the Microsoft Forms 2.0 Object Library check box isn't available, follow these steps:
Click Browse.
Navigate to the file Fm20.dll, located in one of the following folders:
In Microsoft Windows 95/98, the file should be located in the \SYSTEM folder.

-or-
In Microsoft Windows NT or Microsoft Windows 2000, the file should be located in the \SYSTEM32 folder.
After you have located the file Fm20.dll, in the Add References box, click Open.

Thanks watersev ! Added reference to the Microsoft Forms 2.0 Object Library as per your suggestion. But the code isn't doing anything. I am writing my steps what I am following...

1) Copy new data on clipboard.
2) Come back to excel sheet and from there I run the code.
3) What it was supposed to do was to replace the older data in the Data.txt with the new data present on the clipboard and save it. But when I open Data.txt after the step 2, it is still having the older text in it.

Any suggestions?

Thanks indeed for your patience.

Regards.

The code works as expected. If the data.txt file is missing it will be created with the text data (if any) written to it.
Are you checking correct file after code execution?
What are you copying before code excution?

Originally Posted by watersev

The code works as expected. If the data.txt file is missing it will be created with the text data (if any) written to it.
Are you checking correct file after code execution?
What are you copying before code excution?

Thanks watersev for your reply.

With your help I have created this code and its working. I don't know if it is not supposed to be a good coding but its doing the required job.

Please Login or Register  to view this content.

Thanks for your support. And please let me know if there is a way to write this code in better way.

Regards.

Why must you delete the older file if your new text is in a different file?