Results 1 to 33 of 33

Macro creates links for all files in folder. How can I customize where to place the links?

Threaded View

JPWRana Macro creates links for all... 05-20-2013, 03:09 PM
protonLeah Re: Macro creates links for... 05-20-2013, 08:50 PM
JPWRana Re: Macro creates links for... 05-21-2013, 10:46 PM
JPWRana Re: Macro creates links for... 05-24-2013, 02:01 PM
JPWRana Re: Macro creates links for... 05-24-2013, 01:59 PM
protonLeah Re: Macro creates links for... 05-30-2013, 04:00 PM
JPWRana Re: Macro creates links for... 05-31-2013, 01:50 AM
JPWRana Re: Macro creates links for... 05-31-2013, 01:49 AM
protonLeah Re: Macro creates links for... 06-01-2013, 08:44 PM
JPWRana Re: Macro creates links for... 06-03-2013, 12:08 PM
protonLeah Re: Macro creates links for... 06-05-2013, 01:01 AM
JPWRana Re: Macro creates links for... 06-05-2013, 12:43 PM
JPWRana Re: Macro creates links for... 06-05-2013, 12:19 PM
protonLeah Re: Macro creates links for... 06-05-2013, 10:38 PM
JPWRana Re: Macro creates links for... 06-05-2013, 11:58 PM
JPWRana Re: Macro creates links for... 06-06-2013, 02:53 PM
JPWRana Re: Macro creates links for... 06-06-2013, 02:52 PM
protonLeah Re: Macro creates links for... 06-06-2013, 07:30 PM
JPWRana Re: Macro creates links for... 06-10-2013, 11:50 AM
protonLeah Re: Macro creates links for... 06-10-2013, 07:23 PM
JPWRana Re: Macro creates links for... 06-13-2013, 11:07 AM
JPWRana Re: Macro creates links for... 06-18-2013, 11:07 AM
JPWRana Re: Macro creates links for... 07-12-2013, 06:48 PM
protonLeah Re: Macro creates links for... 07-15-2013, 01:55 PM
JPWRana Re: Macro creates links for... 07-16-2013, 05:09 PM
JPWRana Re: Macro creates links for... 07-16-2013, 06:10 PM
protonLeah Re: Macro creates links for... 07-20-2013, 07:49 AM
JPWRana Re: Macro creates links for... 07-20-2013, 01:11 PM
JPWRana Re: Macro creates links for... 07-20-2013, 01:16 PM
JPWRana Re: Macro creates links for... 07-20-2013, 01:26 PM
JPWRana Re: Macro creates links for... 07-20-2013, 12:57 PM
protonLeah Re: Macro creates links for... 07-20-2013, 03:06 PM
JPWRana Re: Macro creates links for... 07-23-2013, 01:14 AM
  1. #1
    Forum Contributor
    Join Date
    10-23-2004
    Location
    Los Angeles
    MS-Off Ver
    2010
    Posts
    256

    Question Macro creates links for all files in folder. How can I customize where to place the links?

    I have a macro that creates a link for every file (specifically those files are only pictures-jpeg), and sets those links in Column A. If I have 110 jpegs in that folder, it will create 110 links all on Row A.

    Those pictures have a specific naming system where... depending on what they are called, they belong to a specific column and row. There are about 45 different widgets, and each widget is named by numbers, and each widget has 2 pictures (for the most part) one ending in "est" and one ending in "id".

    One column has the "est" pictures, and the other has the "id" pictures. The first 45-48 rows are for the corresponding widget number. How can I change the vba coding so that... when the link is created, it NOT ONLY puts the links that end in "est" and "id" in the correct columns, but also the right widget number in the right row?

    I have uploaded the file so you guys can see...

    1) Where the macro places the links (in row A)
    2) Where those links are SUPPOSED TO BE in columns K & L, and the corresponding rows in column C.

    Any help would be greatly appreciated.
    Thanks
    Attached Files Attached Files
    Last edited by JPWRana; 05-20-2013 at 03:13 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1