Button OnAction Macro Assignment "drive" letter getting reassigned

[lukez]

Hello,

I can't find any topics on this issue.
I create a button using vba and assign a macro using onaction.

.OnAction = "'c:\data\macro.xla'!copy"

The macro continues and saves the file to c:\data\temp\

Everything works fine with the button at this point. I can also saveas to a different drive (shared drive for example) z:\
The button still works in the new location.

Now, if I drag and drop (copy/paste) the file from c:\data\temp into z:\data\temp the button stops working. It says z:\data\macro.xla'!copy does not exist.
Any insights as to how I can hard code the drive letter into the button so that I can freely move the files around and not have to saveas in order to move it?

Thanks!

 

[lukez]

Posting full button code incase that's more helpful:

    ActiveSheet.Buttons.Add(10, 30, 72, 25).Select
    With Selection
        .OnAction = "'c:\data\downloads\macro.xla'!copy"
        .Caption = "Copy?"
        .Font.Name = "Arial"
        .Font.FontStyle = "Bold"
        .Font.Size = 8
    End With

 

[lukez]

Update:
I have narrowed down the issue to relocating the file to a sharepoint library. It works if I move it between drives but errors out when I put it on sharepoint. Error says "We can't connect to 'https//sharepoint.com/data/downloads/macro.xla'!copy"' Please make sure you're using the correct web address