+ Reply to Thread
Results 1 to 6 of 6

Help On VBA code to run till end of workbooks In path Avoid datevalue of Input

  1. 07-15-2016, 01:32 AM #1
    johnmacpro
    johnmacpro is offline
    Forum Contributor
    Join Date
    02-28-2016
    Location
    australia
    MS-Off Ver
    2019
    Posts
    194

    Help On VBA code to run till end of workbooks In path Avoid datevalue of Input

    Dear expert

    I have code of vba to run into N number of closed workbook to updated formula in every workbook. Particular column I update datevalue with formula through Pop-up Inputbox for Z:Z column but It occur Pop-up Inputbox on every workbook and ask update date. i want one time enter and update on all closed workbook should not asking everytime
    for example if i start with workbook Jan, it ask Pop-up to enterdate Once i enter it should run till end of workbook in Path It should not ask for every workbook.


    Please find the code on workbookVBArun & Closedworkbook like Jan,Feb,....Dec, if you bring new code appreciated



    Thanks and
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-15-2016, 04:08 AM #2
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Help On VBA code to run till end of workbooks In path Avoid datevalue of Input 

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.
    Reply With QuoteRegister To Reply
  3. 07-15-2016, 11:53 AM #3
    johnmacpro
    johnmacpro is offline
    Forum Contributor
    Join Date
    02-28-2016
    Location
    australia
    MS-Off Ver
    2019
    Posts
    194

    Re: Help On VBA code to run till end of workbooks In path Avoid datevalue of Input

    No sir it does not work at my end Please check the code!!
    Last edited by johnmacpro; 07-15-2016 at 03:04 PM. Reason: explain
    Reply With QuoteRegister To Reply
  4. 07-15-2016, 06:15 PM #4
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Help On VBA code to run till end of workbooks In path Avoid datevalue of Input

    Quote Originally Posted by johnmacpro View Post
    No sir it does not work at my end Please check the code!!
    Hardly a useful description of the problem. What exactly does "does not work" mean in your case?

    If it errors, what is the error description and what line of code is highlighted when you click the debug button on the error dialog?

    Does it do anything, or nothing, or put the wrong formulas in the cells?
    Reply With QuoteRegister To Reply
  5. 07-16-2016, 01:08 AM #5
    johnmacpro
    johnmacpro is offline
    Forum Contributor
    Join Date
    02-28-2016
    Location
    australia
    MS-Off Ver
    2019
    Posts
    194

    Re: Help On VBA code to run till end of workbooks In path Avoid datevalue of Input

    Opps sorry sir, its works No wrong at code slight If LCase(MyFile) Like "*.xlsb" just changed now its fine!!
    Last edited by johnmacpro; 07-17-2016 at 11:34 PM. Reason: explain
    Reply With QuoteRegister To Reply
  6. 07-17-2016, 03:18 AM #6
    johnmacpro
    johnmacpro is offline
    Forum Contributor
    Join Date
    02-28-2016
    Location
    australia
    MS-Off Ver
    2019
    Posts
    194

    Re: Help On VBA code to run till end of workbooks In path Avoid datevalue of Input

    Thanks alot for being spend your valuable time for me!!Solved
    Last edited by johnmacpro; 07-17-2016 at 11:30 PM. Reason: solved
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA Code to Auto Fill Down till Next Filled Cell & reapply the code with new value
    By Ram_G in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-24-2016, 06:20 AM
  2. How to validate an input dat folder/directory path whether the path has any spaces
    By mahendra.asapu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-21-2015, 02:39 AM
  3. Need a help to avoid editing Macro for retrieving report till current date
    By Kishore@Kumar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-07-2013, 07:29 PM
  4. [SOLVED] Shared workbooks and how to avoid conflicts
    By Dena in forum Excel General
    Replies: 5
    Last Post: 11-09-2012, 03:24 PM
  5. Avoid passwords when looping through workbooks
    By kchm_2000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-28-2011, 04:46 AM
  6. [SOLVED] Avoid any input from user
    By Shinya Koizumi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-09-2006, 06:20 PM
  7. How can I avoid circular reference AND extra input
    By maintchief in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 11-10-2005, 08:45 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1