|
Re: Excel help!
Ok then, drifing away from topic if Access is no good to you, but I do think your college is making life too hard by getting you to use inappropriate software.
Access can import and export from / to Excel. As far as I'm aware this is fairly crude in that the results of an access query (sort of equivalent to the macro you are trying to run) would paste / export into one data table (access) / sheet (excel). I haven't actually tried running a query that uses eexcel to write an access table.
You've possibly done much of the leg work for access with your excel spreadsheet, in that each sheet of the spreadsheet becomes an access table. Queries then bind each table together, with forms and reports added on (not essential) to provide the end user with nice easy interfaces for the information input / extract they want, without knowing what goes on behind the scenes.
|