Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 24th 07, 03:41 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: May 2007
Posts: 1
Default how do I attach a pdf with receipts to a cell or a spreadsheet?

I have receipts that I would like to add to a spreadsheet that are in pdf
format. I don't want them to appear as a picture on the spreadsheet itself,
but almost like a commnet, where you can click on a cell and see the pdf

  #2   Report Post  
Old May 27th 07, 03:32 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: May 2007
Posts: 31
Default how do I attach a pdf with receipts to a cell or a spreadsheet?

I guess by not displaying as a picture you mean not to show the file
contents, but rather a link.

To get these files in you should use insert file create from file, and
tick the box marked "display as icon" which will get the effect os a shortcut
rather like an emai attachment.

If you really do want it work from a cell then you would have to insert the
file elsewhere (eg an "attachments" worksheet and use a macro to display
this/these when a particular cell is selected. This sounds like more work
than necessary though, for what sounds like attaching your expenses receipts
to a claim.

--
Adam Vero
MCP, MOS Master, MLSS, CWNA
http://veroblog.wordpress.com
http://www.meteorit.co.uk


"Dhappli" wrote:

I have receipts that I would like to add to a spreadsheet that are in pdf
format. I don't want them to appear as a picture on the spreadsheet itself,
but almost like a commnet, where you can click on a cell and see the pdf



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Attach a Spreadsheet File to a Cell in Another Spreadsheet roadkill Excel Discussion (Misc queries) 1 May 9th 07 05:20 PM
Can I attach a PDF in a cell? Genia Excel Discussion (Misc queries) 1 February 1st 07 03:39 PM
attach a file to a cell in a spreadsheet chance Excel Discussion (Misc queries) 1 January 1st 07 05:17 AM
does anyone know how to attach a word doc into a excel spreadsheet foust Excel Worksheet Functions 3 January 23rd 06 03:51 PM
Any way to attach a picture to a cell? Dustin Swartz Excel Discussion (Misc queries) 3 January 25th 05 01:35 AM


All times are GMT +1. The time now is 08:47 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017