+ Reply to Thread
Results 1 to 6 of 6

Read Table Headers and write in another table

  1. 01-10-2024, 10:59 AM #1
    leyeti77
    leyeti77 is offline
    Registered User
    Join Date
    11-06-2009
    Location
    Paris, France
    MS-Off Ver
    Office 365
    Posts
    19

    Question Read Table Headers and write in another table

    Hi team,
    First, Happy new year and best wishes to all.

    Even progressing in VBA I struggle for long time with the following macro.
    The aim is to read the width of all column of a table, and write them in a table (to be reuse is need to set back the width to what has been previously saved)
    Currently I am able to read the width of each column but not the name of the colum, 

    Please Login or Register  to view this content.
    About the "GetTable" ClassModule, it has been develop by the man who was working before me and was a real Dev

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 01-22-2024, 06:33 AM #2
    leyeti77
    leyeti77 is offline
    Registered User
    Join Date
    11-06-2009
    Location
    Paris, France
    MS-Off Ver
    Office 365
    Posts
    19

    Re: Read Table Headers and write in another table

    No one has any idea ?
    Reply With QuoteRegister To Reply
  3. 01-22-2024, 06:50 AM #3
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,181

    Re: Read Table Headers and write in another table

    We don't get many Access queries - most members are in to Excel.
    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. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  4. 01-22-2024, 09:19 AM #4
    leyeti77
    leyeti77 is offline
    Registered User
    Join Date
    11-06-2009
    Location
    Paris, France
    MS-Off Ver
    Office 365
    Posts
    19

    Re: Read Table Headers and write in another table

    Hi AliGW
    This is purely in Excel (using Table) I do not even know to use ACCESS despite it might be better for me.
    Reply With QuoteRegister To Reply
  5. 01-22-2024, 09:39 AM #5
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,181

    Re: Read Table Headers and write in another table

    OK - well, you posted in the Access sub-forum, which may be why you've had no replies! I'll move this to the Excel VBA section for you.
    Reply With QuoteRegister To Reply
  6. 01-22-2024, 09:52 AM #6
    leyeti77
    leyeti77 is offline
    Registered User
    Join Date
    11-06-2009
    Location
    Paris, France
    MS-Off Ver
    Office 365
    Posts
    19

    Re: Read Table Headers and write in another table

    Sorry for this error
    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. Turning the items in a table column into the headers of another table and auto update
    By Caraexcel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-26-2023, 02:20 AM
  2. Turning the items in a table column into the headers of another table and auto update
    By Caraexcel in forum Office 365
    Replies: 7
    Last Post: 10-26-2023, 02:20 AM
  3. [SOLVED] Tutorial Needed: User upload xlsx file, read that file, write to table
    By PrimePorkchop in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-30-2021, 10:50 PM
  4. [SOLVED] Read Table Headers to Array
    By lloydgodin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-16-2016, 05:29 PM
  5. How to automatically include table headers while saving a part of the table as prn file?
    By canis01 in forum Excel General
    Replies: 1
    Last Post: 03-28-2013, 11:31 AM
  6. Read whole file,Match the headers based on specific condition & write to text file
    By macromaniac in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 06-07-2011, 06:37 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