Execute / Calling Functions within VBA?

[ccscott]

Any advice on how to execute / call the following function mentioned here on this message board?

http://www.tek-tips.com/faqs.cfm?fid=1971

Basically, I'd like to insert via variables the arguments of this function to execute on an on_update command.

Thanks in advance!

 

[grgimpy]

It looks like it gives examples at the bottom of the FAQ:

Open a folder:
fHandleFile("C:\TEMP\",WIN_NORMAL)

Call Email app:
fHandleFile("mailto:bpo@yahoo.com",WIN_NORMAL)

Open URL:
fHandleFile("

http://uk.yahoo.com";,

WIN_NORMAL)

Handle Unknown extensions:
fHandleFile("C:\TEMP\TestThis",Win_Normal)

Just set variables equal to the file location and put a string variable in there instead.

 

[ccscott]

My apologies if I wasn't clear in my original post...What I was really trying to figure out was how to call/execute this function within a sub_afterUpdate()?

 

[ccscott]

RESOLVED. Thanks!

 

[SkipVought]

ccscott,

This is a two-way thing, here at Tek-Tips. You GET help and you GIVE help.

In your case, you posted a question and then closed the thread with, "RESOLVED. Thanks!"

Those browsing your thread with similar issues, or an inquiring mind, might as, "Resolved? HOW?"

Would you please share your sucessful solution?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[ccscott]

The solution was to issue the "CALL" command prior to the utilizing the function within my code. The problem that I was experiencing was that I was actually utilizing this command appropriately; however the file did not exist in the specified directory, so the code actually had nothing to open.

Apologies for not appropriately posting the resolution. Thanks for bringing to my attention.