How to make a  preliminary distribution of an MS Office piece; can you recommend an entry-level installation process?

Posted on 2014-08-29
Last Modified: 2014-08-30
I need to make an initial small-scale trial distribution of my demo office piece. It contains excel and visio components that are bound together.  Since changes in these file names will blow up the creation of the worksheet and document objects that enable exchange of data between applications, I think I should hiding these files in the directory and using a shortcut component to start up the piece (is that the best solution?).

The piece also has a set of sub-folders containing graphics and text files.

Hopefully this can be kept simple. This will be my first experience; can you point me in the right direction please?

Question by:Kelvin4
    LVL 77

    Expert Comment

    by:David Johnson, CD, MVP
    q: does the end user have office and visio ?  could you elaborate on what you are trying to accomplish?

    All that I can think of is to put all of the data files in a subdirectory and use relative directories with a shortcut to the 'working directory"

    Author Comment

    Thanks for taking this up. I have office, including visio professional. I write vba and XML for the fluent XL ribbon.

    I use Excel 2010 file to open and to control intricate shape processes in Visio 2013 via early binding:
    In Excel module:
    Set visioApp = New Visio.Application 'early binding
        If IsFileOpen(visFilePath) Then        'visFilePath is a variable that defines the visio file.. relatively or absolutely
            Set visQDoc = visioApp.Documents.Add(visFilePath)
        end if

    As there is bilateral passage of event information, the visio file needs to recognise the Excel file as an object ( xlAppFromVis), thus in Visio code module:
     If xlAppFromVis Is Nothing Then
            Set xlAppFromVis = GetObject(dirPath & "VisAuthDev_Current.xlsm").Application
     end if  

    Both these objectivisations require the name of the files concerned (and as you say a relative path).

    In addition, the Excel file opens and drive page-turns on a PDF file (Help for User).
    There are sundry sub-folders.

    To limited number of trialists (say <10, for limited time. Plus to archives on cloud.

    Also, I would like it if this installation method provided me with a means of archiving versions of the office 'package of applications). It seemed a good way of keeping all the files and sundry sub-folders in good order.

    I can hide my program files ok, but I need a Shortcut to start excel (which starts Visio and Acrobat.
    My worry is that the TARGET PATH in the standard windows 7 shortcut is accessible, and can be read and altered by the user. How can I raise shortcut security?

    Finally, I need to automatically uninstall all components at the end of the period of the trial license agreement.
    This would be a practical step toward protecting the code.

    I'm too inexperienced in this topic to be more detailed.. I understand your reference to basing the directory structure on a 'working directory' with relative file paths.

    ** Can you pick up on the type of shortcut that will give me the security of file names and paths?

    Otherwise challenging questions from you may well help me better to define my objectives.

    LVL 77

    Accepted Solution

    Unless your users want to pay a huge amount you can't bundle your application for distribution. You would have to include office, adobe acrobat, and visio.

    What you can do is use remote desktop and force the opening of your application on login  be sure that you comply with  the various manufacturers terms of service and licensing.  This can be done either in house or using virtual servers.

    Author Closing Comment

    I will follow up Remote Desktop.
    LVL 30

    Expert Comment

    by:Scott Helmers
    Kelvin -- another thought: it sounds like what you really need is to create an installation program that takes care of all of the file and folder placement for you.

    There are quite a few programs available that build installers. I've used several and have settled on Advanced Installer. I have a paid version of the product and it lets you do just about anything, however, they also offer a freeware version that could be sufficient for what you need.

    There is a bit of a learning curve but their help text is good and they provide excellent customer support (at least for the paid versions; don't know about the freeware).

    Author Comment

    Nice to read you, and many thanks for sharing your experience. I shall look into Advanced installer.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Integrate social media with email signatures

    Is your company active on social media? Do you also use email signatures? Including social media icons in your email signature is a great way to get fans for free. Let all your email users know you’re on social media quickly and easily, in a single click.

    Several part series to implement Internet Explorer 11 Enterprise Mode
    Join Greg Farro and Ethan Banks from Packet Pushers ( and Greg Ross from Paessler ( for a discussion about smart network …
    Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
    With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now