I'm working on a project and I'm looking to do some sort of send keys function. I got some VBA code from a friend but it doesn't seem to be doing anything.
Here is the piece of code I have:This does nothing. If I go through step by step, I see nothing happening.
Please Login or Register to view this content.
Here is what I am trying to do. The macro I have going adds some data to a sheet. We have a built in add-on in excel that I am trying to access once this data is available. The add-on is a menu bar that using alt and "1" opens. To put it simply, the code I put above is the correct keystrokes I want to send to continue the macro. I'm just not sure why its not working. It does not cause any VBA errors, the code just runs through it without performing any functions. I do not have vista and I am on excel 03. Thanks for any help, advice, or suggestions you guys have. The people contributing and adding insight or solving problems deserve more credit. Thank you.