Hi - I am very new with VBA and coding. I apologize if my question has been covered in another forum. I've looked everywhere, I can't seem to solve my problem. I don't understand a lot of the lingo but I try to look it up when I don't know.
I have a process that I would like to write a code in VBA to run the report for me.
I am using VBA to open the exe file.
When that file opens it calls for a user name and password plus two more questions that remain consistent.
I want to use a userform to get the user name and password.
The other two things are static but are also keystrokes.
After that there are commands to run the report in the open window.
I want to run that report and print it back to excel.
I can get most of that but I am running into issues with the first part.
I am hoping someone can help me out and point me in the right direction.
Are sendkey and userform the right direction?
Or should I do this another way?
Thanks in advanced!