Results 1 to 2 of 2

Thread: VBA to import data in already opened third party software.
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Feb 2015
    Location
    Dhaka,Bangladesh
    Posts
    35
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default VBA to import data in already opened third party software.

    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?

  2. #2
    New Member
    Join Date
    Feb 2015
    Location
    Dhaka,Bangladesh
    Posts
    35
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA to import data in already opened third party software.

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

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •