Hi
I wanted to copy and transfer the raw data (along with spaces) from a worksheet to a notepad automatically every 5 minutes by replacing the existing data in the same notepad.
i have many Worksheets in the Workbook, in which i wanted to export data from a particular Worksheet called "SPOT", Range from A2:Y90.
Notepad file saved in the location C:\ drive in the name of 'collection' in .txt format , C:\collection.txt .
I have googled and tried various methods but has none matched my criteria yet. Hoping for a solution here.
Thanks, awaiting for your assistance. Thank you.
I wanted to copy and transfer the raw data (along with spaces) from a worksheet to a notepad automatically every 5 minutes by replacing the existing data in the same notepad.
i have many Worksheets in the Workbook, in which i wanted to export data from a particular Worksheet called "SPOT", Range from A2:Y90.
Notepad file saved in the location C:\ drive in the name of 'collection' in .txt format , C:\collection.txt .
I have googled and tried various methods but has none matched my criteria yet. Hoping for a solution here.
Thanks, awaiting for your assistance. Thank you.