VBA to import data in already opened third party software.

dxzaber

New Member
Joined
Feb 1, 2015
Messages
35
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

New Member
Joined
Feb 1, 2015
Messages
35
99 Views but no reply. Am i asking for something impossible or very difficult or my post missing any information.?
 

Forum statistics

Threads
1,084,776
Messages
5,379,812
Members
401,629
Latest member
LEMANOIS

Some videos you may like

This Week's Hot Topics

Top