VBA to import data in already opened third party software.

[dxzaber]

Sub openspcolumn()


CreateObject("Shell.Application").Open (ThisWorkbook.Path & "\SP" & "\slendercolumn.col")




End Sub
.............................................................................................................................................................

This code opens slendercolumn.col file. Then I manually click file>import>import data>then select a .txt file from ThisWorkbook.Path .


How can I Do this data import with a macro?

 

[dxzaber]

99 Views but no reply. Am i asking for something impossible or very difficult or my post missing any information.?