File attempts to link when sent to a different computer via e-mail

M

Michael Lanier

When I send a file I've created to a different computer via e-mail, it
prompts the user asking if they want to update the links. Eventually
I plan to certify the file and distribute it. Will this continue to
be a problem once certified or is there a different problem that needs
to be addressed? Thanks for any help.

Michael
 
M

Michael Lanier

Additional information:

I believe the reason the file attempts to update is because it is a
copy created by the following macro:

If ActiveWorkbook.Worksheets("Proposal").Range("P3").Value = "On"
And _
ActiveWorkbook.Worksheets("Proposal").Range("P4").Value > 1
Then
ActiveWorkbook.Worksheets("Proposal").Copy
ActiveWorkbook.SendMail Worksheets("Proposal").Range("P15"),
Worksheets("Proposal").Range("U17") ActiveWorkbook.Close False
End If

I'm thinking the copy is attempting to link to the original file.
Would it make sense to introduce a macro that would eliminate the
attempted link from within the copy itself?

Michael
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top