<div>
Yes, it works to copy the link. But, following is the error message I get when I click on the link once the copy is made:<br />
<br />
&quot;Cannot open the specified file&quot;<br />
<br />
Need further solution.
</div>


Yes, it works to copy the link. But, following is the error message I get when I click on the link once the copy is made:

"Cannot open the specified file"

Need further solution.

<div>
Can you check to see if the location of the file exists? Make sure to see if the link is referring to the proper location.
</div>


Can you check to see if the location of the file exists? Make sure to see if the link is referring to the proper location.

<div>
The link works ok in the source location. I've checked, it works fine. But after copying it doesn't.
</div>


The link works ok in the source location. I've checked, it works fine. But after copying it doesn't.

<div>
You can try to use the tips in this article:<br />
<br />
<a href="http://support.microsoft.com/kb/211503" rel="ugc nofollow">http://support.microsoft.com/kb/211503</a><br />

</div>


You can try to use the tips in this article:

http://support.microsoft.com/kb/211503 [http://support.microsoft.com/kb/211503]


<div>
The location and address of files was ok. But there must have been some other clause causing a problem. However, the solution given by you is good.
</div>


The location and address of files was ok. But there must have been some other clause causing a problem. However, the solution given by you is good.

<div>
<div class="content wysiwyg-content">
I wish to copy the hyperlink from one excel file to another excel file where I am collecting all data of the same process. I need to do this using Excel VBA.
</div>
</div>


I wish to copy the hyperlink from one excel file to another excel file where I am collecting all data of the same process. I need to do this using Excel VBA.

Copy hyperlink VBA in Excel

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.