is it possible???

[AFR]

hello

i have a database "in Excel" that I would like the user to post onto a forum
i was able to let a macro open th right page with this command: "Call ShellExecute"
but thats all it does....
how can i make it:
1)log in "given username and password"
2)attach file "same file evertime","Excel file"
3)and log back out??

any help?

[JordanChris]

It sounds like you want to manipulate another program from your application.
There are 2 ways (in fct there are others as well, but I will describe 2) of doing this:
1.
- SHELL the program you want to manipulate. This runs the .EXE.
- Set the Focus of Windows to that program (make it active, using AppActivate).
- Use SendKeys to send keystrokes to that application.

2.
- Use the published callable interface into the second program.

Approach 2 is by far the best - but not all programs have a callable interface. Getting your app to talk to Excel would be easy - but getting Excel to talk to another app might not be possible.

So: Either use approach 1; ot tell us more about the application you are trying to control.