Run time error 1004 - cannot insert object

D

diceman

Hi,

I have an excel file that contains hyperlinks to files. I get the hyperlink
address and then embed that file into the excel file. (The files are text
files.)
All the files and the excel file are on a network drive.
When I run the macro from my PC everything works OK.
When I try it from a different PC I get the 1004 error on the command that
embeds the files:
ActiveSheet.OLEObjects.Add(Filename:= _
HyperlinkAddress, _
Link:=False, DisplayAsIcon:=True, IconFileName:="packager.exe",
_
IconIndex:=0, IconLabel:="").Select

Any reason why it should behave in a different way when you activate the
same macro in the same file from a different PC?

Thanks,
Rakefet
 
N

NickHK

Depends how you are getting the file name.
If these are hard coded, maybe the drive mapping is different on the other
PC ?

NickHK
 

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

Similar Threads

Insert/Embed PDF File automatically via VBA 1
placing an embedded file on a sheet in a fixed position 4
Run-time error 1004 3
Automate embedding files 1
Macro to Insert Object with browsing ability 4
"Run-time error '1004' 5
Run-time Error '1004': Selection is too large. 0
Excel Run-time error '1004' General ODBC Error 1

Top