File Association - fileassociation
last updated on: 11/10/16 08:43AM
   How to Fix Error Embedding Pictures as comments [11/10/16 08:43AM]   
Rate this post  

Embedding Pictures as comments

Hi everybody

I am trying to add pictures as comments in an excel that I am using
locally as a personal database.
The problem is that the excel file is
getting to large.

Is there a way that when I add a picture as a comment, that picture
would not be embedded, instead just displayed, but from my local
hard drive location ? aka using it as a local resource and not embedded
in the file itself ?

And more, is there a way to point, the same way, without embedding
in the excel file the picture, to an url location ? So the comment could
show a picture from a specified url ?
I am using VBA code to automatically add the pictures as comments
from local folders using the current selected cell values as filenames,
and it works, but not for URLs unfortunately.
Don't get me wrong, I do not need the code, I need the approach to
point to a specified URL or local image without embedding it in the
file.


thank you

Anwsers to the Problem Embedding Pictures as comments

Download Error Fixer for Free Now

Hi,
assuming that you have the below URL addresses in cells A1:A5
(as text string not as url)
 
http://kellysthoughtsonthings.com/wp-content/uploads/2012/12/nature-wallpaper-175.jpg
http://cdn.wallpapers.com/Images/WallPapers/previews/tn_adorableawp6.jpg
http://images2.fanpop.com/image/category/www/871_100_100.jpg
http://images2.fanpop.com/image/category/www/9298_100_100.jpg
http://cdn.wallpapers.com/Images/WallPapers/previews/tn_cottageawp.jpg
 
 
add the above url/pictures in specific cells: C10, C20, F10, F20, I10
try this...
 
Sub Add_Pic_In_Comments()
On Error Resume Next
Dim v As Variant
v = Array("C10", "C20", "F10", "F20", "I10")
Dim x As Long
For x = 0 To UBound(v)
Range(v(x)).Comment.Delete
With Range(v(x)).AddComment
.Visible = True
With .Shape
.Fill.UserPicture Cells(x + 1, "A").Value
.Height = 90   ' <<< change as needed
.Width = 120   ' <<< change as needed
End With
End With
Next
End Sub
 
XXXXXXXXXXXXXXXXX
 
and...
delete comment/pictures
 
Sub DeleteCmtPic()
On Error Resume Next
Dim v As Variant
v = Array("C10", "C20", "F10", "F20", "I10")
For x = 0 To UBound(v)
Range(v(x)).Comment.Delete
Next
End Sub

Machine Throttling
  • Go to the Start button.
  • In the Search box, type "regedit" (without quotes) and press Enter.
  • Look for the following registry key: "HKEY_LOCAL_MACHINESOFTWARE Microsoft SQMClientWindowsDisabledSessions".
  • On the right window pane, delete the subkey: "Machine Throttling".
  • Restart your computer.

Another Safe way to Repair the Problem: Embedding Pictures as comments:

How to Fix Embedding Pictures as comments with SmartPCFixer?

1. Download SmartPCFixer. Install it on your computer.

2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in this software. Like dll downloading, windows updating and print spooler error repair.


Related: Download SONY SVE1512H1RB Synaptics PS/2 Port ClickPad driver,Method to Download SONY VGC-LT10E SigmaTel Audio Driver Update v.6.10.5614.0,Way to Download SONY VGN-CS118E/R AV Mode Button Utility v.1.1.01.09140 driver,Method to Download SONY VGN-FW375J/B Alps Pointing Device Driver v.5.7.0.92,Where to Download SONY VGN-NS270J/S Pioneer BD-ROM BDC-TD01 Firmware Update v.1.03,Data Export From Quickbooks To Excel,Date Format In Formula Bar And In The Cell Is Not The Same,Deleted The Snipping Tool,Desktop - Open Program Issues,Desktop Windows Manager Keeps Poping Up & It Reads That There Is A Problem & That Windows Will Check It Out & Send Me An Answer .
Read More: Tech Support: Endless loop of disk access following return from sleep or screen saver,[Anwsered] Error 0x800CCC0E when trying to send mail through Outlook Express.,Empty deleted mail box [Anwsered],How to Fix Error Error xpcom dll when trying to download Lotus viewer,Troubleshooting:ERROR 1079 when trying to update Direct X,does anyone know what the dialog means "System.Media.FontFamily' threw an exception windows is checking for a solution?,Does Log Me In Ignition for my Android with Windows 7 Home Premium?,Download failure for my Blackberry and the process stops during the install,Display settings keep changing when I come back from sleep mode,Downloaded files are not saved



   Trackbacks

      TRACKBACK URL: http://fileassociation.blogghy.com/trackback/1056296

   Comments

   Post a comment
Name:


Email:


2 + 3 = ?

Please write above the sum of these two integers

Title:


Comments:





About the author

Contact the author
Categories

Latest blog posts
How to Fix Error Embedding Pictures as comments
[11/10/16 08:43AM]
How to Fix Problem Disabling unwanted programs at startup
[27/09/16 05:11AM]
Solution to Error cannot open my banks homepage
[14/09/16 04:42AM]
How to Fix Problem System Repair Application has stopped working
[13/07/16 05:35AM]
Solution to Error Not able to Start Web Client getting error Web client services on the local computer started and then stopped
[04/07/16 11:06AM]
Top views posts
How to Fix Error Embedding Pictures as comments
[11/10/16 08:43AM] Daily Views 2
Troubleshoot my forward emails are going to other addresses
[17/05/16 04:19AM] Daily Views 1
Solution to Error Not able to Start Web Client getting error Web client services on the local computer started and then stopped
[04/07/16 11:06AM] Daily Views 1
Troubleshooter of Error My Windows 7 Internet Explorer routinely fails to follow a link and shows the dialog box Internet Explorer has stopped working
[31/05/16 04:01AM] Daily Views 0
Solution to Problem New non maximized windows to stay in the same position as the previous window
[14/06/16 04:58AM] Daily Views 0
Photo Albums








Powered by Blogghy

Page generated in 0.0625 seconds.