Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VBA in Web Template (Excel 97 & 2003)

    A user asked me if an Excel Workbook that uses VBA macros can be put on our Intranet and still expect the macros to work (when accessed thru the Intranet).
    I tried searching here but did not find anything.
    If VBA macros do work when accessed this way, are there any special commands needed?

    Thanks,
    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: VBA in Web Template (Excel 97 & 2003)

    If you mean by "put on out intranet", having the XL workbooks available on a network drive accessible to all, there should be no real problems. We do this with many files in our network.

    It is important to keep the macros in the workbook so that the users all have access to them (as opposed to in an addin or someones personal.xls).

    Steve

  3. #3
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA in Web Template (Excel 97 & 2003)

    Steve,

    I sent your response to the user and have not heard back yet.
    If they are talking about having a link on an internal website that opens a workbook that is stored on the network, I assume that as long as all the macros needed are in the workbook, it would work.
    I will let you know what the user response is.

    Thanks for taking the time to reply!
    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

  4. #4
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA in Web Template (Excel 97 & 2003)

    Steve,

    The user is asking if we post the link on the internal web page, when the the user using IE 6.0, clicks on the link to the workbook and it opens the workbook, will the macros work?
    Chuck Reimer
    I'm from the Government and I'm here to help...

  5. #5
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: VBA in Web Template (Excel 97 & 2003)

    Charles

    The answer I would say is yes. When you download from a link the brwser will ask if you want to "save to disc" or open. If the excelw/b is stored on a file server somewhere there is no reason why the macros would come with it. Obviously if the end PC has high macro security levels it may halt the macros working....hope this helps?
    Jerry

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: VBA in Web Template (Excel 97 & 2003)

    How is it linked? Is it opening XL and the file (it should) or is it opening as a some kind of web page (I don't know)?

    [You could create a sample file and test it...]

    Steve

  7. #7
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA in Web Template (Excel 97 & 2003)

    Steve/Jerry,
    Thanks. I think we will just have to try it. He was asking up front to see if there were any "Gotchas" before he finished the work. I will suggest he test with a small sample. Thanks for the input.

    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

  8. #8
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA in Web Template (Excel 97 & 2003)

    In my experience, the best answer is "it depends" on what your VBA does. None of my Excel applications work when run in a web browser because I have a lot of code that shows/hides columns/rows and sometimes entires sheets. There are many other things you can do in VBA that will fail miserably when run in a browser. If the VBA is simple stuff, and no pop-up forms then it should be ok.

    Deb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •