I want to store an Excelfile with a list of items on Google Drive. For most items there is a picture in the same directory. I want people to be able to click on a hyperlink to open the picture.
I have worked out a macro to check if the file exists (gif or jpg) and to creat the hyperlink. This works well on my computer where I have the same pictures and the Excel file togeter. When I transfer all to Google Drive , then the links are wrong.
How do a create a link that is relative to the directory where the Excel file is situated? For ease I may put the pictures in a subdirectory to make the list easier to find.
28 freelancers are bidding on average $77 for this job
Hi there! I read your project of Inventory on Google Drive I am freelancer professional way! I will use PHP Excel Web Scraping Google Sheets Google Docs WAITING FOR YOU IN CHAT BOX Best: Aqeel
Hi, the above description suits my profession and I have read and understood your project requirements and If you wouldn’t mind giving me more info in my chat box, looking forward to working with you