UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Other Options For Running Outside Exe File?, Access 2016    
 
   
stephenAA5
post Oct 11 2018, 10:15 AM
Post#1



Posts: 280
Joined: 8-October 09



Hi, guys. Just a follow on to the other question, since there doesn't appear to be an answer...

Is there another way to launch an outside exe that does not involve shellexecute, shell, shellexecuteex?

I'm really, really stuck here.

Thanks.

Stephen.
Go to the top of the page
 
kfield7
post Oct 11 2018, 10:29 AM
Post#2



Posts: 892
Joined: 12-November 03
From: Iowa Lot


followhyperlink works well in most cases, if you don't need to pass parameters. If you specify the document, then the OS launches the corresponding app.
Go to the top of the page
 
stephenAA5
post Oct 11 2018, 11:45 AM
Post#3



Posts: 280
Joined: 8-October 09



Just tried followhyperlink, won't launch it at all frown.gif
Go to the top of the page
 
kfield7
post Oct 11 2018, 01:40 PM
Post#4



Posts: 892
Joined: 12-November 03
From: Iowa Lot


You tried

Application.FollowHyperlink YourFullPath, , True

?
Go to the top of the page
 
stephenAA5
post Oct 11 2018, 06:33 PM
Post#5



Posts: 280
Joined: 8-October 09



This gets weirder by the second. I've now spent two days on it, and can't figure anything out.

This doesn't allow longer than 4 minutes, either. BUT, stranger things are also happening.

The outside program parses an XML file (output from Quickbooks comes in XML) back into Access. Should be simple.
When launched by hand, it parses the correct number of records...67 in my smaller test record, and enters them into my database. Perfect.

When launched programmatically, it processes 4 minutes worth. OF THE OLD DATA. Huh? That old dataset isn't even PRESENT anymore!

How do I know I'm launching the same file? Because if I change the name of the target file, it errors.

Same behavior even if I create a test database, and launch it from there.

This is really, really crazy.

Stephen.
This post has been edited by stephenAA5: Oct 11 2018, 07:02 PM
Go to the top of the page
 
kfield7
post Oct 12 2018, 07:41 AM
Post#6



Posts: 892
Joined: 12-November 03
From: Iowa Lot


We might be of more help if you would explain exactly what you're trying to accomplish, what you're seeing happen, and share the code you're using to do it.
Go to the top of the page
 
JonSmith
post Oct 12 2018, 07:47 AM
Post#7



Posts: 3,921
Joined: 19-October 10



Why use this external .exe if its so much trouble.
Reading an XML is easy in VBA and it takes very little code to append it to Access.
Go to the top of the page
 
stephenAA5
post Oct 12 2018, 01:29 PM
Post#8



Posts: 280
Joined: 8-October 09



Hi, Jon. At this point, I'd LOVE LOVE LOVE to learn how to do that.

Any suggestions as to where to begin the research?

Thanks!

Stephen.
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    23rd October 2018 - 11:50 PM