Consulting

Results 1 to 4 of 4

Thread: VBA

  1. #1
    VBAX Regular
    Joined
    Nov 2021
    Posts
    14
    Location

    VBA

    Goodmorning everyone,

    I am using a table with our company program, in the morning I extrapolate in xls format, but when I create the links to copy the values, it is better to use the VBA or use the formula "='C:\Users\1\Desktop\[s.xlsx]data'!E2"?

    I have an Excel file with the sheet name "To be pasted" only from A2 to X20000 and I have to copy the file "C:\Users\1\Desktop\s.xlsx" from E2: AB20000 which formula should I use the macro?

    Thanks for your help

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,344
    Location
    Do the copy en-bloc, VBA will increment the cell address.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Regular
    Joined
    Nov 2021
    Posts
    14
    Location
    Goodmorning everyone

    I am attaching the file, so you can see if I was wrong.


    Thanks and best regards
    Attached Files Attached Files

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,344
    Location
    That workbook fails on opening, it is trying to filter a table on each worksheet, there are no tables.

    More detail on what is going on might help you get some assistance.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •