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:
RAMPOW Cable USB C, [USB 3.0 y QC3.0] Cable USB C Carga Rapida 3A, Cable USB Tipo C Nylon Duradero Compatible con Samsung Galaxy S22/S21/S20/S10, iPhone 15/15 Pro, Huawei, Xiaomi - Gris Espacial/1M
6,99 € (a partir de 24 abril, 2024 13:17 GMT +02:00 - Más informaciónProduct 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.)
GEEKOM Mini PC XT12 Pro, Intel i9-12900H (14 núcleos, 20 subprocesos, hasta 5,0GHz), 32 GB DDR4 1 TB SSD Mini Ordenador de Sobremesa, NUC 13 Mini Gaming PC Windows 11 Pro 8K | Wi-Fi 6E | USB4
749,00 € (a partir de 24 abril, 2024 13:17 GMT +02:00 - Más informaciónProduct 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.)
Kingston A400 SSD Disco duro sólido interno 2.5" SATA Rev 3.0, 960GB - SA400S37/960G
58,98 € (a partir de 24 abril, 2024 13:17 GMT +02:00 - Más informaciónProduct 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.)
ASUS RT-AX57 (Ax3000) - Router Extensible Wifi 6 De Doble Banda, Seguridad De Red, Instant Guard, Control Parental Avanzado, VPN Integrada, Compatible Con Aimesh, Gaming Y Streaming
74,90 € (a partir de 24 abril, 2024 13:17 GMT +02:00 - Más informaciónProduct 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.)
ASUS VivoBook 15 F1500EA - Ordenador Portátil 15.6" Full HD (Intel Core i3-1115G4, 8GB RAM, 256GB SSD, UHD Graphics, Windows 11 S) Color Plata - Teclado QWERTY español
389,00 € (a partir de 24 abril, 2024 13:17 GMT +02:00 - Más informaciónProduct 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.)
302XL Cartuchos de Tinta Remanufacturado para HP 302 XL Cartucho de Tinta Negro 302XL Impresora Compatible para Envy 4524 4520 4527 DeskJet 3630 2130 2134 OfficeJet 3831 3835 5230（Negro y Color
24,99 € (a partir de 24 abril, 2024 13:17 GMT +02:00 - Más informaciónProduct 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.)
Disco Duro Externo 500GB - 2.5" USB 3.0 Ultrafino Diseño Metálico HDD Portátil para Mac, PC, Laptop, Ordenador, Xbox One, PS4, Smart TV, Chromebook - Grey
26,39 € (a partir de 24 abril, 2024 13:17 GMT +02:00 - Más informaciónProduct 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 304 3JB05AE - Pack de 2 Cartuchos de Tinta Originales Negro y Tricolor, compatible con impresoras de inyección de tinta HP DeskJet 2620, 2630, 3720, 3730, 3750, 3760, HP Envy 5010, 5020, 5030
23,70 € (a partir de 24 abril, 2024 13:17 GMT +02:00 - Más informaciónProduct 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.)
Samsung Tablet 64 GB 4 GB RAM Gris Grafito
180,99 € (a partir de 24 abril, 2024 13:17 GMT +02:00 - Más informaciónProduct 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.)