Using filename hyperlinks in Macros

[Marlene.Sawhney]

Hello Everyone,

Here is the problem I am having......


I am trying to automatically attach a file to an email in Outlook every

week...right now the file is attaching and going to my drafts in
outlook, which is perfect.


The problem is that the filename changes every week. Right now the
name of the file is:


M:\Pricing\Weekly AUD and CAD\Canadian\2006.12.15 CAD Pricing.xls


Next week, the file will be:
M:\Pricing\Weekly AUD and CAD\Canadian\2006.12.27 CAD Pricing.xls


I have a formula in Excel that concatenates the file name and a formula

that creates it as a hyperlink and it opens...which is fine.


BUT- when I run the macro it doesn't attach the file when I use the
concatenated/hyperlink formula....however it did attach when I
hyperlinked the file on my own


I have a lot of files......and I need to do them weekly....so thats why

it would be difficult to this manually


In the end, I need a macro/formula/anything that can concatenate the
file name and then hyperlink it AND still work when I run my
macro...ANY help would be awesome!


Thanks everyone and happy holidays!

 

[Shauna Kelly]

Hi

I assume your code is running in Excel. You've posted your question to a
Word newsgroup. I suggest that you re-post your message to an Excel
newsgroup, and include the relevant portions of your code so that the people
there can see what's happening.

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word