Excel help

[Castar]

Excel buff's anywhere? I'm a firm believer that when all else fails resort to http://www.funclansnipers.com for help. :P

Here is a copy of a post I made elsewhere.
Bet I get an answer here:)


Ok I'm a newb so bear with me.

Cell A1 represents a total from a medical bill.
I want to hyperlink a copy of the actual bill in a pic,doc,txt format embedded in Excel that opens the proper program because I clicked on the blue text.
I am able to link it locally, however if I link it in that manner then email the .xls file it wont work because the link is local.

Help

Thanks, John

p.s. will the answer work in Linux ie., OpenOffice?

[Mr.BOoK]

Create a folder put the xls file in it and the image you want to link to, then link to the new folders local image. Email the folder with the xls and the images will be local in the containing folder, or maybe you can't e-mail a folder?

[Ironface_NL]

Correct me if I'm wrong, but why are you not hosting the images somewhere on the web and refer your link in excel to the hosted images? Then it doesn't matter if you email the excel file to someone else. It will look up the images on the hosted site for him or her also.

[SgtHetfield]

I agree with IronFace. You can insert objects into Excel, and I know you can insert pictures. If you could do that, you could put the picture (for example) into a separate sheet, link to that sheet, but lock the sheet.

Depends what you want to do. If people can get to the content via the web, the excel spreadsheet etc, why not e-mail the content with the spreadsheet?

Or print everything out as PDF?

Apologises - I'm not sure what you are trying to do. Previously I have produced an international bottled beer menu, and we inserted country flags in as graphics then produced a PDF and went to the printers. Is this the sort of thing you are after?

[Castar]

My X pays support to me for our son. She owes over 8,000$ in unpaid support. The way the powers that be document payment is a joke. From their printouts, which you can only get by special request, you cant tell anything because of the way they do it. Regardless, I made a spreadsheet. Now at a glance I can see everything I need to know.
On another sheet called Unreimbursed Medical Expenses is where im having trouble. Every month I have to add all the bills up. Scan in each bill. Save each bill to a fill. Create a .pdf and send it to her. Its pretty simple but alot of work.
I made the spreadsheet yesterday and it works fine then I got to thinking.....
What if under the column that is for say Dentist Bill, the numbers are blue for that month and i click on the number and open a copy of the bill. The idea is less folders, less work. Besides, I would have all the info in 1 place.
Whew.........

[Badmotor]

Look into using MSAccess. If memory servers me correct I think you do that in there, by using Excel for the data entry and then hyperlinking the bill in the reports. If you give me a bit there is a way of hyperlinking it that way in Excel also.

[Ironface_NL]

There is another way and that is importing the images into Access also. The problem is that the database is growing fast and if it becomes above 100MB it gets unstable. So on what resolution are you scanning the images. 200 DPI is enough for printing a copy of that bill. So you would at least make a new database for each year. There are several ways to solve this problem in Access but then this post will be 4 hours reading material. If you need any help on this, just hit me up. I make access databases on customer request as a side job. hyst hyst. Pays good money hyst hyst hyst

[Badmotor]

I could use some good reading material for when I am on the crapper!

hyst hyst hyst hyst

[SiN-e]

Haaaaaaa.
I got some you can have :)

[Castar]

NM i gave up and just hosted the files.....

Thanks anyway guys

[SgtHetfield]

My X pays support to me for our son. She owes over 8,000$ in unpaid support. The way the powers that be document payment is a joke. From their printouts, which you can only get by special request, you cant tell anything because of the way they do it. Regardless, I made a spreadsheet. Now at a glance I can see everything I need to know.
On another sheet called Unreimbursed Medical Expenses is where im having trouble. Every month I have to add all the bills up. Scan in each bill. Save each bill to a fill. Create a .pdf and send it to her. Its pretty simple but alot of work.
I made the spreadsheet yesterday and it works fine then I got to thinking.....
What if under the column that is for say Dentist Bill, the numbers are blue for that month and i click on the number and open a copy of the bill. The idea is less folders, less work. Besides, I would have all the info in 1 place.
Whew.........

Sorry I couldn't help - must be a total nightmare for you. :mad:

[Castar]

Oh i think its just rediculous I have to waste time on this crap period. Dont get me wrong this Excel thing is kinda fun but its the crap from her thats NUTS!! :)