+ Reply to Thread
Results 1 to 6 of 6

macro do not create new tables

  1. #1
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    macro do not create new tables

    This macro looks for a certain network path
    tables in an .mdb file opened with Excel.

    Please Login or Register  to view this content.

    Find 2 tables and save them as defautl
    where you open Cartel1 / Cartel2 in the same
    folder of the main excel file.

    So far, so good
    ask for help for a change:
    This macro is connected to a button that starts it

    create the 2 tables and save them,
    if I click the button again, create other tables Cartel3 / 4 - Cartel 4/5 etc ..

    You can put a block or a counter that checks if they are already there
    do not the 2 tables Cartel1 / 2 create other tables?

    I hope I explained myself.
    A greeting.
    max_max

  2. #2
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: macro do not create new tables

    Hello, maybe I explained myself not well?
    max_max

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,356

    Re: macro do not create new tables

    Please be patient! You asked your question at almost 1800 BST on a Friday evening - don't forget it's the weekend!!!
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  4. #4
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: macro do not create new tables

    This macro added to the previous one macro Sub ricerca_1 changed to:

    if in WK1.path are present Cartel1.xlsx / Cartel2.xlsx
    blocks the macro Sub ricerca_1():


    Please Login or Register  to view this content.
    max_max

  5. #5
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: macro do not create new tables

    I put a lock on the button and it should work.

    Please Login or Register  to view this content.
    The msgbox "TABELLE CARICATE" it is displayed only once, it should be displayed each time you click on the button.
    Help to correct?
    max_max

  6. #6
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: macro do not create new tables

    I attach the files.
    In the zip file there are 3 files:
    File search_find_new_3 opens Cartel1/2
    max
    Attached Files Attached Files

+ 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. [SOLVED] Macro to create 3 Pivot Tables as per Sheetname
    By pnasir in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-04-2017, 10:57 PM
  2. Macro to create 2 Pivot tables in the same sheet
    By mtma in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-14-2015, 09:30 AM
  3. macro to Create 3 tables from tables in the attached sheet
    By irfanparbatani in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-12-2015, 08:13 AM
  4. Replies: 0
    Last Post: 03-10-2015, 03:34 PM
  5. Macro script to create pivot tables
    By marielouise1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-05-2013, 01:21 PM
  6. [SOLVED] Macro to Create Pivot Tables
    By Jiptastic in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-04-2013, 06:38 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