Insert file as OLEobject by referencing a cell

[dklein11]

Hi. I've been banging my head against the wall for 3 hours and I can't figure this out.

In F2 I have c:\example.txt
In F3 I have c:\example2.txt

I'm trying to insert the files in G2 and G3 respectively

Please Login or Register  to view this content.

I get runtime error 1004 cannot insert object. But if I use the following code it works fine

Please Login or Register  to view this content.

I have F2 and F3 formatted as text. Can someone help me figure out what's wrong?
Thanks!!
Dave

[event21]

Hi -

What error you got in the first one?

event

[dklein11]

here's what i get when i try to call Filename:=fPath

when i send fPath to a msgbox i can see that it's the correct path+filename+extension. the only thing I can think of is that for some reason VBA doesn't think fPath is a string

error.JPG

[event21]

Hi -

I don't have 2013 for now so I could not test it, however, it does work in 2010

event

[dklein11]

I must be doing something fundamentally wrong because I tried this code and it evaluated to "The file does not exist" even though the path and file in the msgbox is correct. And if I change ObjFso.FileExists(FolderPath) to ObjFso.FileExists("same string in the msgbox") it then evaluates to "The file exists". hmmm

Please Login or Register  to view this content.

[event21]

Hi -

Try to use the debug.print command to pull out the filename from the variable

event

[dklein11]

Hi all.

Thanks again to everyone who's helped. I was able to combine the different advice from this thread as well as some other threads into VBA that:

1) opens windows file viewer
2) searches through the selected folder and lists the files and some of the properties for each file in the folder
3) then changes the file names into hyperlinks
4) then embeds the PNG, JPG and PDF files into the spreadsheet

Please Login or Register  to view this content.