|
-
Oct 16th, 2000, 08:18 AM
#1
Thread Starter
New Member
I am using shellexecute to launch an excel data file from vb : ret2 = ShellExecute(0&, "OPEN", filename, "", "", 1)
where filename is, for example, "text.xls".
Test.xls is an "!" delimitted text file. The problem is, when excel opens, it bypasses the Text Import Wizard.
I cannot use the Excel object in VB.
2 questions.
1) Once I have a process id (ret2), can I send commands to Excel from VB?
2) Is there anything I can add to the shellexecute command that Excel will recognize so the Import Wizard will show up?
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|