Hi everyone newcomer here !!
I searched around all the internet and cannot find an answer or something that I could use to solve this issue... it seems impossible and I am really mad about it... I am coming into here to see if u guys are good..
I will try to make it simple:
The ERP system that runs where I work generates 2 formats of reports that could be .csv or .txt. So when it generates the reports it opens a Excel application or a Notepad application containing delimited text.
By this time I will have an Excel workbook already open containing a VBA macro module that will process and format properly all the information in the reports that I have to copy and paste manually from these .csv or .txt reports.
The .csv workbook is open in another instance of Excel and both .csv and .txt file are UNSAVED, so there are NO PATH to get.
Is it possible to copy the text from the .txt file opened in Notepad and .csv opened in another Excel instance to my active Excel instance workbook knowing they are both unsaved and without paths ?
Sorry if my question is not clear... I believe that for the question no code was needed... all that I find over the internet needs the files paths... I tried to access by the windows processes like in the task manager too with now sucess... anyway please HELP ME