<acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> to insert images from file path
Basically I have an Excel ‘Shopping list’ that I am doing for a client, where she chooses products from Products db., and she assign the list to a client from the Clients db.
The product database is exported to CSV Comma Delimited from a website.
Everything is working fine except the image part,
I’ve used the Data Validation/List for the ID and vlookup function like so: =IFERROR(VLOOKUP([ID],PRODUCTS,2,FALSE),"") to pull the rest of the data in the columns the image.
The image field is populated with: /users/manager/webapps/products/images/imagename.jpg…
Using front slash
How can I convert the above path to show the image instead of the path? and when it is viewed locally the path should show point to C:\inetpub\wwwroot\interiordesignonline\users\manager\webapps\products\images
With back splash?.
Thank you,
Another issue:
Using the formatted table ‘Ctrl + T’, how can I have the row height when tabbing or enter to inherit the row height from the above row, I am assigning the row height to 60?
Basically I have an Excel ‘Shopping list’ that I am doing for a client, where she chooses products from Products db., and she assign the list to a client from the Clients db.
The product database is exported to CSV Comma Delimited from a website.
Everything is working fine except the image part,
I’ve used the Data Validation/List for the ID and vlookup function like so: =IFERROR(VLOOKUP([ID],PRODUCTS,2,FALSE),"") to pull the rest of the data in the columns the image.
The image field is populated with: /users/manager/webapps/products/images/imagename.jpg…
Using front slash
How can I convert the above path to show the image instead of the path? and when it is viewed locally the path should show point to C:\inetpub\wwwroot\interiordesignonline\users\manager\webapps\products\images
With back splash?.
Thank you,
Another issue:
Using the formatted table ‘Ctrl + T’, how can I have the row height when tabbing or enter to inherit the row height from the above row, I am assigning the row height to 60?
