Re: Using Modules in Multiple Files

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



This will depend on what application you are using and how you want to use
the procedures and some other factors but, in general, if you have a
container (a Word global template or an Excel personal.xls or equivalent)
holding all your code you should be able to set references to it in other
projects and use the procedures as though they were in your project.

--
Enjoy,
Tony


"Michael Suttkus, II" <Do Not Email> wrote in message
news:36395A44-096A-4196-84FA-CD0EC17D7F3A@xxxxxxxxxxxxxxxx
> I have certain modules which contain functions and procedures I want to
use
> in several different projects. Obviously, I could cut and paste, or even
> export and import, but these solutions are inefficient and lead to a
hassle
> when it comes time to update the files. (i.e., if I make a change to one
of
> the modules, I have to open up every other file where it is being used and
> import the new text. Yeesh!)
>
> Short of getting the administrators to let me have access to Studio and
> program my own dlls, is there any effective way to simply this?


.



Relevant Pages

  • Re: Word-Excel link only works the first time
    ... Although I inserted explicit references as Tony suggested and got rid of the ... I found a posting from someone with the inverse problem - Excel macro not ... how do I "qualify" the references? ... Dim xlApp As Excel.Application ...
    (microsoft.public.word.vba.general)
  • Re: Word-Excel link only works the first time
    ... Tony, just look at the other posting that i've posted afterwards. ... WorkSheets (and other excel objects) should always be qualified ... Dim sht As Excel.WorkSheet ...
    (microsoft.public.word.vba.general)
  • Re: AutoShapeType bug in Word 2007?
    ... Thanks for the reply Tony and sorry for my slow response... ... stopped working in Thunderbird for some reason, ... it doesn't provide the full shape manipulation nodes like Excel ... I don't know whether this can be classed as a bug or not but it is certainly ...
    (microsoft.public.word.application.errors)
  • Re: Identifying an application which holding a file and preventiting me from deleting it.
    ... Trapping an error can be done simply by Kill FileName without resorting to ... Specifically a newly generated excel file. ... application is 'holding' it. ... What APIs would I use and if anyone has sample VB6 code, ...
    (microsoft.public.vb.winapi)
  • Re: Open Multiple Instances of Excel
    ... > Windows Start button|run ... > Tony wrote: ... >> I'm looking for a way to get Excel to open multiple instances so that I ... >> easily view two workbooks at a time in a dual monitor setup. ...
    (microsoft.public.excel)