Hello I need assistance in creating a code in excel VBA that will achieve the following steps, I have found some resources in online forums but have been unable to implement on my own:
1) I am currently using an ipad database program to assist in managing my contact details as well as a corresponding photo of each contact.
2) My database software is capable of exporting all text data to excel, however the corresponding .JPG are exported separately. When exported, the JPG files are named based on a specified text data parameters (e.g. excel text export has name Michael, JPG export file name is Michael). I want to have my own separate excel file be able to recombine these two together without having to go through the steps manually for each entry. Note that each text name will be unique.
3) All picture data and the import excel file for the to be created macro will be located on my desktop in filepath "C:\Users\Michael Potter\Desktop\Pictures"
To further clarify my request and for your reference, I have found the following chat in the link below which is a good proxy for my objective and I believe a near solution. I just need someone who can assist me to implement. [url removed, login to view] I am highly excel proficient, however limited in VBA.
ALSO SEE EXCEL FILE ATTACHED AS AN EXAMPLE.
I need this done ASAP and expect the price to be <$250 and would require the freelance send me a working code and provide some basic assistance in implementing. Please email me at your earliest convenience with a quote.
6 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
I develop Access and Excel tools for corporations for a living. There was no file attached to your project so if you could send me an example of what your phone exports I should be able to get this done in no time.
My roommate and I have a good deal of VBA experience. We can deliver well-commented, working code for this within 24 hours of receiving the spreadsheet and images.