I create a report that takes pictures (jpg images) that are stored on my computer and inserts them into an excel spreadsheet. I then created a macro to create a webpage that gets sent to the main server to be displayed on the internet. However, when I do this, the place that I save the HTML report on my computer creates a file folder of the images that are in the report in my directories.
We are switching to a server with more space, and I wanted to upload the images to the server so these individual folders for my images aren't needed when I upload to the server, basically, it will pull directly from the server site where the images are stored.
Is there a way to pull the images down from the server through the macro, and be able to upload the file without the file folder created with all of the images? Right now my macro pulls from my C: drive, a place where the images are. Can a macro pull from the server site, the image, put it into my sheet so it can be uploaded without the duplication file folder created from my macro, and if so how?
We are switching to a server with more space, and I wanted to upload the images to the server so these individual folders for my images aren't needed when I upload to the server, basically, it will pull directly from the server site where the images are stored.
Is there a way to pull the images down from the server through the macro, and be able to upload the file without the file folder created with all of the images? Right now my macro pulls from my C: drive, a place where the images are. Can a macro pull from the server site, the image, put it into my sheet so it can be uploaded without the duplication file folder created from my macro, and if so how?