If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formula to Embed a file object in my excel sheet.
Hi,
I want to embed(insert) a file object in my current sheet from a external Java program. Is there any formula to perform this operation ? Thanks. Regards, Hemil |
#2
|
|||
|
|||
Formula to Embed a file object in my excel sheet.
If you mean to create a link you can use the below formula
=hyperlink(link_location,friendly_name) If you are looking to embed a file then try the below macro. If you are new to macros.. --Set the Security level to low/medium in (Tools|Macro|Security). --From workbook launch VBE using short-key Alt+F11. --From menu 'Insert' a module and paste the below code. --Get back to Workbook. --Run macro from Tools|Macro|Run selected macro() 'Change the asd to file fullpath and filename Sub Macro3() ActiveSheet.OLEObjects.Add Filename:="fullpath and filename within quotes", _ Link:=False, DisplayAsIcon:=True End Sub If this post helps click Yes --------------- Jacob Skaria "Hemil" wrote: Hi, I want to embed(insert) a file object in my current sheet from a external Java program. Is there any formula to perform this operation ? Thanks. Regards, Hemil |
#3
|
|||
|
|||
Formula to Embed a file object in my excel sheet.
Hi,
I cannot use Macros as it cannot be invoked from my library. I need some function which can be executed to embed objects. "Jacob Skaria" wrote: If you mean to create a link you can use the below formula =hyperlink(link_location,friendly_name) If you are looking to embed a file then try the below macro. If you are new to macros.. --Set the Security level to low/medium in (Tools|Macro|Security). --From workbook launch VBE using short-key Alt+F11. --From menu 'Insert' a module and paste the below code. --Get back to Workbook. --Run macro from Tools|Macro|Run selected macro() 'Change the asd to file fullpath and filename Sub Macro3() ActiveSheet.OLEObjects.Add Filename:="fullpath and filename within quotes", _ Link:=False, DisplayAsIcon:=True End Sub If this post helps click Yes --------------- Jacob Skaria "Hemil" wrote: Hi, I want to embed(insert) a file object in my current sheet from a external Java program. Is there any formula to perform this operation ? Thanks. Regards, Hemil |
#4
|
|||
|
|||
Formula to Embed a file object in my excel sheet.
There is no inbuilt function in excel to embed an object.
From menu InsertObjectCreate from File Browse to navigate to folder and select the file InsertCheck 'Display as icon' and hit OK. If this post helps click Yes --------------- Jacob Skaria "Hemil" wrote: Hi, I cannot use Macros as it cannot be invoked from my library. I need some function which can be executed to embed objects. "Jacob Skaria" wrote: If you mean to create a link you can use the below formula =hyperlink(link_location,friendly_name) If you are looking to embed a file then try the below macro. If you are new to macros.. --Set the Security level to low/medium in (Tools|Macro|Security). --From workbook launch VBE using short-key Alt+F11. --From menu 'Insert' a module and paste the below code. --Get back to Workbook. --Run macro from Tools|Macro|Run selected macro() 'Change the asd to file fullpath and filename Sub Macro3() ActiveSheet.OLEObjects.Add Filename:="fullpath and filename within quotes", _ Link:=False, DisplayAsIcon:=True End Sub If this post helps click Yes --------------- Jacob Skaria "Hemil" wrote: Hi, I want to embed(insert) a file object in my current sheet from a external Java program. Is there any formula to perform this operation ? Thanks. Regards, Hemil |
Thread Tools | |
Display Modes | |
|
|