• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Open excel file from hyperlink

K

Karthik Thandapani

Member
Hi,

Can anyone please provide a solution to open a macro enabled excel file from a folder without any dialog boxes?

To explain the requirement in detail: I have an macro enabled excel file which is saved in a shared folder. Planning to include an hyperlink to this file in the body of the email which I send to the recipients. They should able to open up the file with just a click.
Can we also transform that to click to open instead ctrl+click to open ?

Any help is appreciated.

Thanks,
Karthik
 
@Deepak : thanks it helps.
But do you think the same file can be accessed by multiple users?
May be, having the file read only will resolve the problem? But I have enabled with automation so read only will prompt users to save a copy, hmmmm I would like to avoid that dialogue as well.
Is there a possible solution to achieve this ?
 
If you are going to have many users accessing the file it would be best to put it on a server, that way you can assign permissions and levels of editing
 
@bobhc : Is there a way to enable download file from a folder? The email which I send is a newsletter and that would provide a copy of the file to each & every user who clicks on the link.
Anything special we can do about that ?
 
I still think that a sharepoint/sever way is the best option, I assume that if you are emailing the file to others its for them to view and edit, if so, others will not see the edit untill all are returned to you and the master updated.
If they are only able to view but no edit then just send as an attachment with the workbook protect, in so much that Excel protection borders between crap and bloody usless.

#
 
You must log in or register to reply here.
Back
Top