AlfredoQuintero
Lifetime Supporting Member
I have not been able to crack this one out, even after much thinking and googling. I would be so grateful if I can get some guidance from the forum.
I have developed a Windows application that stores tab-separated text files with data from some PLC applications. The end user has MS Office installed on the same PC, and at this moment the customer has to open MS Excel, locate the text file, open it up, parse the data and convert it into MS Excel, doing so manually each and every time.
In order to make it even easier for the customer, increase their level of satisfaction and increase the probability of new jobs, without having yet committed to the customer, I would like to develop an MS Excel VBA macro that would work as I describe below (which would automate the task described in the above paragraph):
1) From the standard Windows file explorer, right-click the text file and in the "send-to" options I would have registered a pointer to the MS Excel file with the macro that I am trying to develop.
2) Once the file is sent to the pointer, the macro is opened by MS Excel, the macro then opens the text file, works out the full path of the text file and remembers the full path.
3) The macro then parses the tab-separated fields into separate cells, as in a normal MS Excel spreadsheets.
4) Using the remembered full path but changing the extension from TXT or CSV into an Excel workbook, the file would be saved in MS Excel.
Is this actually possible?
Thanks for reading down to this point!
I have developed a Windows application that stores tab-separated text files with data from some PLC applications. The end user has MS Office installed on the same PC, and at this moment the customer has to open MS Excel, locate the text file, open it up, parse the data and convert it into MS Excel, doing so manually each and every time.
In order to make it even easier for the customer, increase their level of satisfaction and increase the probability of new jobs, without having yet committed to the customer, I would like to develop an MS Excel VBA macro that would work as I describe below (which would automate the task described in the above paragraph):
1) From the standard Windows file explorer, right-click the text file and in the "send-to" options I would have registered a pointer to the MS Excel file with the macro that I am trying to develop.
2) Once the file is sent to the pointer, the macro is opened by MS Excel, the macro then opens the text file, works out the full path of the text file and remembers the full path.
3) The macro then parses the tab-separated fields into separate cells, as in a normal MS Excel spreadsheets.
4) Using the remembered full path but changing the extension from TXT or CSV into an Excel workbook, the file would be saved in MS Excel.
Is this actually possible?
Thanks for reading down to this point!