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?
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

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.?
 

Watch MrExcel Video

Forum statistics

Threads
1,102,455
Messages
5,487,002
Members
407,575
Latest member
calc

This Week's Hot Topics

Top