Results 1 to 5 of 5

Thread: Excel + Vb help

  1. #1
    sajidbagi is offline Senior Member+
    Last Online
    1st February 2023 @ 06:54 PM
    Join Date
    04 Jan 2009
    Posts
    225
    Threads
    20
    Credits
    1,200
    Thanked
    5

    Default Excel + Vb help

    Aoa

    bhai meray paas ek excel ki file hai jis mein meinay ek column mein files k naam likhay huay hein aur woh (audio files) meinay

    "C:\My Documents\My Music"

    is location par rakhi hui hein. mein chahta hoon k mein excel mein jaisay hi file ka name change karoon to woh excel k us cell par jis par woh audion file ka name likha hua hai us par automatically hyperlink change ho jayay aur jab mein us par click karon to wohi audio file open ho jis ka name likha tha.

  2. #2
    Mubashir Aziz's Avatar
    Mubashir Aziz is offline Senior Member+
    Last Online
    6th May 2011 @ 06:39 PM
    Join Date
    17 Mar 2009
    Posts
    588
    Threads
    27
    Credits
    0
    Thanked
    6

    Default

    You can check my belwo thread

    http://itdunya.com/showthread.php?t=93697

    To get your task you can make a macro which will export the list of files "C:\My Documents\My Music" in excel sheet and adjacent column will be updated accordingly .....

  3. #3
    faheemgul's Avatar
    faheemgul is offline Senior Member+
    Last Online
    2nd October 2022 @ 10:24 PM
    Join Date
    30 Jul 2008
    Age
    38
    Posts
    447
    Threads
    99
    Credits
    4
    Thanked: 1

    Default

    very nice mubishar bhai

  4. #4
    sajidbagi is offline Senior Member+
    Last Online
    1st February 2023 @ 06:54 PM
    Join Date
    04 Jan 2009
    Posts
    225
    Threads
    20
    Credits
    1,200
    Thanked
    5

    Default

    thans

  5. #5
    Mubashir Aziz's Avatar
    Mubashir Aziz is offline Senior Member+
    Last Online
    6th May 2011 @ 06:39 PM
    Join Date
    17 Mar 2009
    Posts
    588
    Threads
    27
    Credits
    0
    Thanked
    6

    Default

    thanks faheen & sajid

Similar Threads

  1. Excel tip (Hidde formula in formula bar in excel)
    By Honour12 in forum Urdu Tutorials & Designing
    Replies: 14
    Last Post: 31st May 2016, 10:06 AM
  2. MS EXCEL - Al-Quran in Excel
    By Mubashir Aziz in forum General Discussion
    Replies: 45
    Last Post: 16th March 2015, 08:59 PM
  3. Not Working Zaara's Excel Tutorial In Pdf & 300 Excel Tips
    By iftikhar01 in forum General Discussion
    Replies: 94
    Last Post: 14th May 2012, 04:28 PM
  4. Need Help in excel
    By nsm1870 in forum Solved Problems (IT)
    Replies: 4
    Last Post: 16th March 2010, 11:02 AM

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
  •