Storing Excel code - do you need a workbook? 1

[shauntwo]

Hi,

I have a current setup between Access and Excel where, using Access forms, I generate queries and transfer them out to a pre-defined workbook that has a macro stored with it. Once the workbook loads, the user clicks a simple button to execute the macro. I'd like other users to use my forms on their machine, but that would presently mean I'd have to update my transferspreadsheet method to specify a particular destination folder, and that would take time.

How does one create a "library" of Excel modules, that can be referenced selectively by the user when needed? I know that I can create a toolbar that executes the modules on demand, but I'm getting the impression that I still need a default workbook to store these in. What options do I have to make my modules more versatile, so that I can just dump my Access results into Excel?

Thanks,
Shaun

 

[merlinx]

Have you considered an excel add-in?

Depending on what you have you might put it in a project using an excel object.

 

[MichaelRed]

Weeeeeeellllllllllll,

Since I'm a big !Fan of Excel, my thoughts are to just run, run, run away - way far away. Having (temoprarily) overcome my excelphobia, the next thought is to suggest the creation and distribution of the process as an Ms. Access app, thus neatly avoiding the necessity of using excel, and retaining my excelphobia as a useful part of paranoia inc.

MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[CajunCenturion]

LOL Michael Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein