Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
attach a file to a cell in a spreadsheet
how do i, or can i attach a file to a particular cell in a spreadsheet?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
attach a file to a cell in a spreadsheet
You can't really attach a file to a particular cell, but you can put the
link icon in a particular cell, size the same as the cell, and set it to move and size with the cell. It will look as though it part of the cell, but it really isn't. Use code like the following: Dim OleObj As OLEObject With ActiveSheet.Range("C3") '<<< Change to appropriate cell Set OleObj = ActiveSheet.OLEObjects.Add(Filename:="C:\Susan.doc ", Link:=True, _ DisplayAsIcon:=True) OleObj.Top = .Top OleObj.Left = .Left OleObj.Width = .Width OleObj.Height = .Height OleObj.Placement = xlMoveAndSize End With There is, however, no way (directly) to determine from a cell whether there is a document associated with that cell. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "chance" wrote in message ... how do i, or can i attach a file to a particular cell in a spreadsheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Saving worksheet in new file with date AND cell value as file name | Excel Discussion (Misc queries) | |||
Need to insert file modified date of Excel spreadsheet in a cell | Excel Discussion (Misc queries) | |||
Reference a cell on another worksheet in the same spreadsheet file | Excel Discussion (Misc queries) | |||
Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) |