В роботі

Excel VBA Macro, Folder Image Path to Excel

I need VBA macro to pull files from a folder and display it's full paths in an Excel worksheet cell. All files that are pulled should be on the same line in one cell. Example results for a cell after running macro: C:\Users\[url removed, login to view]\Desktop\Preme\Products\Catalog\[url removed, login to view] | C:\Users\[url removed, login to view]\Desktop\Preme\Products\Catalog\[url removed, login to view] | C:\Users\[url removed, login to view]\Desktop\Preme\Products\Catalog\[url removed, login to view]

*The last file path should not have a pipe at the end of it.

I should be able to call the vba macro from a cell with a simple function in the worksheet window. Example: =getImages("folderpath")

I have a long list of folders that I need to get file names from, so coding each folder path directly into the macro does not work.

Навички: Excel, Visual Basic

Показати більше: vba excel list directory, image recognition vba excel, excel image cell vba, vba excel folder list, excel image crop vba, vba excel word macro, excel list form vba, vba excel critical path

Про роботодавця:
( 18 відгуки(-ів) ) Toronto, Canada

ID проекту: #12166166

Доручено:

nagyzoltan68

Hello, I would like to work on your project, I have great experience using Excel and macros, vba. I have had many similar work before. I would like to work on your sample file. Maybe it is better to write 1 macro which Більше

$25 USD за 1 день
(63 відгуків(-и))
5.1

46 фрілансерів(-а) подали заявки на цю роботу; середня заявка - $29

$20 USD за 0 дні(-в)
(298 відгуків(-и))
7.0
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega Більше

$30 USD за 1 день
(149 відгуків(-и))
6.5
$29 USD за 1 день
(105 відгуків(-и))
6.2
ineedWorkJob

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert desktop/web software/macro/b Більше

$30 USD за 1 день
(99 відгуків(-и))
6.3
gokulanand

Hello I can get you this task in the next 30 mins to 1 hour. Do let me know if you are interested. Thanks

$25 USD за 0 дні(-в)
(95 відгуків(-и))
6.0
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach y Більше

$30 USD за 1 день
(97 відгуків(-и))
6.1
macroPOL

Hello, I am Excel and VBA expert. I can complethis project in one day. Please note that I have 100% completion rate and 5-star feedback on 50 projects.

$30 USD за 1 день
(54 відгуків(-и))
5.4
nagybatonyi

Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macr Більше

$35 USD за 1 день
(57 відгуків(-и))
5.7
zebracaro

i can do it for you quickly and exactly

$30 USD за 2 дні(-в)
(79 відгуків(-и))
5.6
kolosibalint

Hi, What you need is a relatively simple user defined function. I have already made a similar one for my own use to systematize my pictures of a quiz game. I will reconfigure it for your purposes. It can be don Більше

$50 USD за 1 день
(53 відгуків(-и))
5.3
FIBIN

Hi I am interested to work for your project . I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I will make sure that I deliver you the best with 100% ac Більше

$25 USD за 1 день
(52 відгуків(-и))
5.4
schoudhary1553

Dear Project poster, I have the same kind of experience of 5 years. looking for the new projects.Please give me the chance to complete this project. Assuring you the 100% Quality and timeliness Thanks,

$50 USD за 0 дні(-в)
(63 відгуків(-и))
5.1
MoohHHooM

Hi, i can help you with this project, please let me know more about it :) Більше

$25 USD за 0 дні(-в)
(18 відгуків(-и))
4.8
satishtl

- Can get the images full path with the pipe symbol in the specified cell. - Depending on the folder list or all folders within a particular one can be done. - The value can be generated on click of a button. - Більше

$25 USD за 1 день
(27 відгуків(-и))
4.6
Vasilchenko

Hello I can do this..................................................................................................

$30 USD за 1 день
(25 відгуків(-и))
4.8
vsprybhanu

Hi, Experienced Excel VBA and VB.Net Programmer. I have read your instructions carefully. Macro will provide you: if you select files from file open dialog (with multiple selection) then path of every files w Більше

$30 USD за 1 день
(42 відгуків(-и))
4.8
doublebc

Hello, I have a lot of experience with VBA and would be interested in helping you with this project. I actually already completed the project and created a video demo for you. You can go to the link below to view th Більше

$20 USD за 0 дні(-в)
(20 відгуків(-и))
4.3
franSystems

Upon seeing your project, I already went ahead and coded it. I have it now as a UDF, User Defined Fomula, which you can use as normal Excel formula. File upload is not enabled here so please see this link to my upload Більше

$30 USD за 0 дні(-в)
(35 відгуків(-и))
4.0
The24CarrotsInc

A proposal has not yet been provided

$14 USD за 1 день
(17 відгуків(-и))
3.9
sorinacho88

Hello, I can create a function that will work exactly as described. You will be able to call it from a cell and the result will contain all images delimited by a pipe. If you are interested please open a chat wit Більше

$35 USD за 1 день
(8 відгуків(-и))
3.4