Os dejo un truco para Excel por si os pasa como a nuestros compañeros de Contraseña PC. Si tenéis la necesidad de incrustar imágenes en Excel de manera automática.
Tenéis que poner un script sacado de aquí:
La idea es que si queréis incrustar una imagen (\home.gif) en la celda G10:
ActiveSheet.Pictures.Insert(ThisWorkbook.Path & “\home.gif”).Select
‘se obtiene la ubicación de la celda G10
tope = Range(“G10”).Top
izq = Range(“G10”).Left
alto = Range(“G10”).Height
ancho = Range(“G10”).Width
‘se ubica la imagen sobre la celda G10
Selection.ShapeRange.Top = tope
Selection.ShapeRange.Left = izq
Selection.ShapeRange.Height = alto
Selection.ShapeRange.Width = ancho
Eso lo podéis hacer con cada imagen o celda o meterlo en un script o programarlo.
Os recomendamos los siguientes productos relacionados con la informática:
SanDisk 128GB Extreme tarjeta microSDXC + adaptador SD + RescuePro Deluxe hasta 190 MB/s con Clase A2 de rendimiento de las aplicaciones UHS-I Class 10 U3 V30
12,96 € (as of 21 noviembre, 2024 08:45 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
HP 15-fd1004ns- Ordenador portátil de 15.6" Full HD (Intel Ultra 5-125H, 16GB RAM, 512GB SSD, Intel Iris Xe Graphics, Windows 11) Silver - Teclado QWERTY Español
445,90 € (as of 21 noviembre, 2024 08:46 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
INIU Cable USB C, 100W 1m Cable de Carga Rápida QC de USB C a USB C, Cable Tipo C Trenzado Nylon de Datos Cargador de Teléfono USB-C para iPhone 15 Pro Samsung S24 S23 iPad Pro MacBook Tabletas LG etc
7,59 € (as of 21 noviembre, 2024 08:46 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
SanDisk 128GB Extreme PRO, Tarjeta de memoria, SDXC, hasta 200 MB/s + RescuePro Deluxe UHS-I Class 10 U3 V30
15,93 € (as of 21 noviembre, 2024 08:45 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
TP-Link Deco XE75 Pro(2-Pack) - WiFi 6E AI Mesh AXE5400 Mbps, 1x Puerto 2.5Gbps,2X Puerto 1 Gigabit, 6GHz,Triple Banda Real, Cobertura de 510 m2, Fácil Instalación,hasta 200 Dispositivos
219,99 € (as of 21 noviembre, 2024 08:45 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Tableta De Escritura LCD Tableta De Dibujo Colorido De 12 Pulgadas para Niños, 4~12 Juguetes para Niñas Niños, Regalos Borrables Y Reutilizables, Juguete De Cumpleaños De Navidad para Niños (Azul)
11,99 € (as of 21 noviembre, 2024 08:46 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
HP VICTUS 16-s0027ns - Ordenador portátil Gaming de 16.1" Full HD (AMD Ryzen 7 7840HS, 16GB RAM, 512GB SSD, NVIDIA GeForce RTX 4060, Sin Sistema Operativo) Blue - Teclado QWERTY Español
849,99 € (as of 21 noviembre, 2024 08:46 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Amazon Basics - MicroSDXC, 128 GB, con Adaptador SD, A2, U3, velocidad de lectura hasta 100 MB/s, Negro
10,89 € (as of 21 noviembre, 2024 08:45 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
[NUEVO]TP-Link Deco X1500(2 Pack)-AX1500 Whole Home Mesh Wi-Fi 6 System-Cobertura hasta 600 m2, 3X Puertos GigabIt por Unidad, Banda 160MHz Canal, ODFMA, 1024QAM, Color Blanco
109,99 € (as of 21 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)