#1
|
|||
|
|||
VBA to convert input data to network path?
Hello forum
Admin/ Macropod - Apologies if not correct submission format. Was unsure whether to add on to Macropods original post or create a new thread as a new subject? I'm sure you will advise accordingly. Thanks. Yesterday I came across Macropod's excellent VBA for inserting pics to a doc. https://www.msofficeforums.com/newth...newthread&f=23 For my needs, I replaced the columns and picture size with a fixed number... However, as I have a very large collection of pictures, rather than mouse navigating to selecting the pictures, I want to use VBA to request a file number in the format nnnn/nn/nnnn and convert the number to complete a file path to where the required images are stored as Path = S:\\images\pictures\nnnnnn\nnnn\ Eg user inputs a reference number in the format 3342/21/0019 This number is then converted into the network path location of a folder which contains three jpegs Path = S:\\images\pictures\334221\0019\ These three jpgs are then selected and copied to a word document as per Macropods VBA. As an aside, the first digits in the reference number prior to the first "/" can be variable in length and contain a mix of numbers and letters. I've been fiddling around with message boxes but to be honest I have no idea how to even start. Any of you guys able to give me a steer? Many thanks |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Visio 2016 New homemade Shape Data export with Network Shape Data | Karlderxte | Visio | 1 | 08-17-2021 04:04 PM |
VBA - Input boxes and Convert to PDF | pongle | Word VBA | 1 | 08-04-2020 06:28 AM |
Convert String Array to Integer Array from a User Input? | tinfanide | Excel Programming | 4 | 12-26-2012 08:56 PM |
Data input in Powerpoint? | DeeDubb | PowerPoint | 1 | 04-05-2012 01:53 AM |
Mail Merge data source on network drive | Brandi | Mail Merge | 0 | 06-13-2010 11:26 AM |