Hi everybody,
I am working on Windows 10 and using cygwin.
I have a vbscript as follows:
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set wb1 = objExcel.Workbooks.open("\\files\share\path\file1.xlsx")
wb1.Worksheets("Sheet1").Range("A1:CR89").Clear
Set wb2 = objExcel.Workbooks.open("\\files\share\path\test.txt")
wb2.Worksheets("test").usedrange.copy
wb1.Worksheets("Sheet1").usedrange.pastespecial
Set WshShell = WScript.CreateObject("WScript.Shell")
WshShell.Run "cmd.exe /c echo. >NUL | clip", 0, True
wb2.Close
wb1.Save
I want at first to open file1.xlsx, delete cells in file1.xlsx, copy the content of the test.txt file inside file1.xlsx, and finally save and close file1.xlsx.
This script works, but I was wondering if there is a way to do the same task without having to open the test.txt file with excel? Something which would temporarily copy the content of test.txt without having this file opened.
Thanks in advance for any help.
Supernono06