Save from Hyperlink

Posted on 2008-11-07
Last Modified: 2012-05-05
Is there a way to save a file from a hyperlink?

In other words, save the Excel file from:

to 'C:\temp'

thanks in advance

Question by:UniqueData
    LVL 2

    Expert Comment

    If you want to do it in VBA, this link might help.

    I've used it before to do similar stuff.
    LVL 119

    Accepted Solution


    Dim xlObj As Object, fname As String
    fname = ""
        Set xlObj = CreateObject("Excel.Application")
        xlObj.workbooks.Open fname
        xlObj.activeworkbook.SaveAs "C:\temp\myXXX.xls"
        Set xlObj = Nothing

    LVL 7

    Author Comment


    thanks for the perfect solution, as usual.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    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

    8 Experts available now in Live!

    Get 1:1 Help Now