Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making a Form for User-friendly Macros?
I am creating an Excel file with several sheets on it. To make this as brief
as possible, I am (sadly) the most technologically savvy person in my department. I need to find a way to create a macro that others can easily change, so that when they change the file name, the macro code doesn't have to be changed- it just has to be run. For example: I make "Assessment Template", and create a macro that works with it. That macro has to open another Excel file, so that path is written in the macro code. Just in this example, when I open this on another computer, I will have to change the code- something other professors won't do. What I was wondering is, is there a way to create a form in Excel that the professor fills out before they run the macro. It would have the following: the name of the data file the name of the sheet the data is being transferred to the number of rows information will be taken from from the number of columns the information will be special pasted into And so on... Is it possible? If so, where would I find out how to do this? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User-friendly lookup solutions needed | Excel Discussion (Misc queries) | |||
I need a user friendly route sheet! Help! :} | New Users to Excel | |||
How do I create an user form to run macros in excel? | Excel Discussion (Misc queries) | |||
Looking for a production schedule excel/access & user friendly? | Setting up and Configuration of Excel | |||
how to do a web query on an web browser on an user form using macros | Links and Linking in Excel |