Creating a Portal to Folder/Files using Macro

Hi,

I am trying to create a portal for our senior management to use to view major reports in a quick and convieient way. Eventually, we will be making this a web portal, but for now my task is to have a nice GUI and intuitive "portal". Right now, I find the portal looking kind of...bland? and feel it could be "spiced" up with like menus or something?

I have no experience writing VBA and I have a feeling that is needed. So far, I have created the attached file by simply doing a "record macro" and clicking a tab and then stop recording and assigning the macro to a button.

The problem I have is that this does not work when trying to open an actual file or Explorer window, as clicking "record" and going to a file location and opening it is something that Excel does not recognize.

My example of a solution right now is can be seen when you click "Previous Scorecard" which are historical reports from the past, it brings you to a tab which will have all the hyperlinks to these scorecards. I find that this solution is basically the same as simply clicking a tab on excel or opening a word doc with all the links, and am trying to create something like a pop up menu or somehow make it so when you click the button, it would just "open" the folder with the file or the PDF itself.

Can someone lead me to a solution to make this little "project" better? It would be greatly appreciated!

I am not sure exactly what you want but here are some useful codes for making a "control panel"


Opens the specified workbook

Please Login or Register  to view this content.

Activates the specified workbook

Please Login or Register  to view this content.

This closes the specified workbook. False to disable prompts, true to enable (or leave it off)

Please Login or Register  to view this content.

To open other programs it takes the Shell command.

http://msdn.microsoft.com/en-us/libr...=vs.71%29.aspx

this will let you open and send commands to other programs

Hi,

I've found something which I "think" sounds like what I need to create a button to go to an external file:

CommandButton1.Parent.Parent.FollowHyperlink "FILENAME"

Are you trying to get the buttons to activate sheets? Just right click the buttons and click assign macro.

I am trying to create a menu/button that would open a pdf file, not another excel worksheet

use the shell command, I posted a link in my first response.