In my file (excel 2007) I have several sheets that I need to upload into Hyperion every month. To do this manually I have to select a sheet , select the Hyperion tab (available on startup but only after installation) and then press submit. If I use the macro recorder the action of pressing submit, or selecting the Hyperion tab, yields no code. How to I program a macro that selects one sheet, submits the data, selects the next sheet, submits data etc?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Macro that submits data to Hyperion
- Thread starter GRE800Q
- Start date
This is a very very long shot.
Open the VB Editor. Look for the addin in the Project Explorer.
Chances are it's password protected but try and open the project.
Your looking for the Sub name so that you can call it from another module.
Other than that I can't think of anything else.
/Comfy
Open the VB Editor. Look for the addin in the Project Explorer.
Chances are it's password protected but try and open the project.
Your looking for the Sub name so that you can call it from another module.
Other than that I can't think of anything else.
/Comfy
Upvote
0
Similar threads
- Question
