+ Reply to Thread
Results 1 to 6 of 6

Conditionally Run & move the .bat file shortcut(i.e .lnk file) by vba macro

  1. #1
    Forum Contributor
    Join Date
    07-16-2009
    Location
    NA
    MS-Off Ver
    MS Excel 2010
    Posts
    237

    Conditionally Run & move the .bat file shortcut(i.e .lnk file) by vba macro

    Hi Guys,

    I am looking for a macro that will play with .bat file(shortcut of that .bat file)
    vba macro will be placed in macro.xlsm

    I have a .bat file & i created a shortcut of that .bat file & we have to play with the shortcut of .bat file & that shortcut of .bat file is located at (when i clicked on properties i got target "C:\Users\WolfieeeStyle\Desktop\WolfieeeStyle\9.15\Files\Close Excel.bat" & start in C:\Users\WolfieeeStyle\Desktop\WolfieeeStyle\9.15\Files)


    First Check shortcut of the .bat file is located or not & if it is located then move that shortcut of .bat file to C:\Users\WolfieeeStyle\Desktop\WolfieeeStyle & run the .bat File
    & If the .bat file is not located then do nothing

    Thnx

    I am looking for a vba macro
    Last edited by Zaeguzah; 08-10-2020 at 04:39 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Conditionally Run & move the .bat file shortcut by vba macro

    Please do not post duplicate threads. I would normally close the 2nd (this) thread, but seeing as you have more info here (which you should have added to the 1st thread), I will close the other 1.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor
    Join Date
    07-16-2009
    Location
    NA
    MS-Off Ver
    MS Excel 2010
    Posts
    237

    Re: Conditionally Run & move the .bat file shortcut by vba macro

    Yes i know the Forums Rule Sir
    Thats y i marked the first post as Solved bcoz i was searching the details on google & i saw that we can do it by vba (so i got the information of the first post & then i asked this question with all details in it)

    From next time it will not be repeated & If it happens then i will report that post to delete it

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Conditionally Run & move the .bat file shortcut by vba macro

    Yes I saw the other 1 was closed. for future reference, just continue on the 1st thread. Thanks for trying though, many wouldnt

  5. #5
    Forum Contributor
    Join Date
    07-16-2009
    Location
    NA
    MS-Off Ver
    MS Excel 2010
    Posts
    237

    Re: Conditionally Run & move the .bat file shortcut by vba macro

    I got a macro & i edited the macro but its not working
    Last edited by Zaeguzah; 08-10-2020 at 04:35 PM.

  6. #6
    Forum Contributor
    Join Date
    07-16-2009
    Location
    NA
    MS-Off Ver
    MS Excel 2010
    Posts
    237

    Re: Conditionally Run & move the .bat file shortcut by vba macro

    Please Login or Register  to view this content.
    By seraching on google & as per my condition i tried to modify the macro but i am not getting the correct macro
    plz see, I think this macro needs a correction plz correct the macro & help me in solving this problem Sir

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. shortcut to move tab
    By stephme55 in forum Excel General
    Replies: 1
    Last Post: 05-18-2016, 01:00 PM
  2. Any shortcut to run VBA macro when macro file is close
    By Kalpesh93 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2015, 10:03 AM
  3. I need a Macro to conditionally move data from one spreadsheet to another
    By thomomma in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2012, 01:37 PM
  4. Conditionally move row to another sheet
    By meast in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-04-2011, 05:36 PM
  5. Macro to create a shortcut to insert any file into current excel workbook?
    By matt.will in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-02-2007, 03:19 PM
  6. [SOLVED] HELP for a macro to create a shortcut of an excel file on the desk
    By Francesco in forum Excel General
    Replies: 2
    Last Post: 04-13-2006, 12:20 PM
  7. Replies: 2
    Last Post: 01-06-2005, 04:06 PM

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