Creating a shortcut of a file in a folder through excel vba

[bagullo]

Hi,

I am continuing someone else's work and I am finding that a piece of code that is supposed to create a windows shortcut of a file in a certain folder produces a run-time error -2147024893(80070003) (Method 'Save' of object 'IWshShortCut' failed)

the sub that produces the error is the following

Please Login or Register  to view this content.

any idea of what might be going wrong or what should I check?
thanks!

[romperstomper]

Can you manually create a shortcut in the target folder using the specified arguments?

[snb]

Did you check the arguments' values ?

Please Login or Register  to view this content.

[bagullo]

thanks ! I managed and when I foudn out I could create the shortcut then the macro also could... still misterious but we'll leave it until it gives further problems!

thanks a lot

[w2w2w2]

How would you define the path to make Excel 2013 start in a new instance?

I am failing to apply :
.TargetPath = Application.Path & thisworkbook.path

[FDibbins]

w2w2w2 welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

[georgu2]

It looks like my problem. When my macro should starts to create first shourtcut I've recieved an error:
run-time error -2147024893(80070003) (Method 'Save' of object 'IWshShortCut' failed)

Please Login or Register  to view this content.

I am supprised because it was warking until last week. Suddenly it stops without changing anything in code.

[rorya]

I find it hard to believe this part ever worked:

Please Login or Register  to view this content.

[georgu2]

sorry
Here is correct code:

Please Login or Register  to view this content.

[rorya]

If the code is unchanged, then the most likely cause is a change in the data on the sheet, or the drive/folder structures. I suggest you verify the relevant values when the error occurs.

[georgu2]

You are right
Wrong path. I have thought that if there are any mistakes in paths it will give me an information e.g. 'I row 891 is problem'...
Thank you! SOLVED