xlsm href problem

Posted on 2011-05-10
Last Modified: 2012-05-11
Hi Experts,

I have a xlsm file that i open with a href from a html file. The xlsm file have some code in the open workbook so is opens a xlm file. It works fine when i double click the xlsm file, but when it is open through a href link the xlsm file opens but it does not open the xml file?

Can someone help with this?
Dim strname As String
Dim strpath As String
Dim oExcel As Excel.Application
Dim oWX As Workbook
Set oExcel = New Excel.Application
Application.Visible = False
Application.WindowState = xlMinimized
Application.ScreenUpdating = False
strname = Replace(ThisWorkbook.Name, ".xlsm", ".xml")
strpath = ThisWorkbook.Path & "/"
Set oWX = Workbooks.OpenXML(strpath & strname)
Application.Visible = True
Application.WindowState = xlMaximized
Application.ScreenUpdating = True

Open in new window

    LVL 5

    Expert Comment


    Would you please explain more, what you are after?
    opening xlsm which has xml in the same folder from href ? is that what you want?


    Author Comment

    Yes that is what i want. But i found out something strange. If i press the link(href) in a firefox browser, then there is no problem. But nothing happens when i do the same with IE 6 (that is the version my work place are using :-( )

    So it seems that it is some security issue in IE6
    LVL 5

    Expert Comment

    It seems that you need to upgrade the ie version, but anyway before doing that please read this article

    hope it helps,
    LVL 5

    Accepted Solution

    Also please do this in yr IE6 ...
    Go to Tools > Internet Options > Advanced > Security > and check "Allow active content to run in files on My Computer".

    Pls let me know.


    Author Comment

    Hi, the Security setting was the answer :-)
    LVL 5

    Expert Comment

    Glad to be for help ;)
    Thanks for the points & the grade

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Array Formula to add additional step 1 22
    excel formula or VBA 7 36
    Excel to create SQL insert 7 30
    copying from excel to word 2 30
    Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
    Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

    733 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

    22 Experts available now in Live!

    Get 1:1 Help Now