Results 1 to 10 of 22

Thread: Importing a csv File to a range

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #9
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    14
    A simple bracket count:

    Code:
    c01=c01 & vbcrlf & join(WorksheetFunction.Transpose(application.index(sn,j)), ",")
    BTW. If both workbooks are loaded and the ranges have the same size:

    Code:
    sub m_snb()
        Workbooks("B.xlsm").Names("Banka").RefersToRange = Workbooks("A.xlsm").Names("Banka").RefersToRange.Value
    end sub


    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 06-10-2023 at 04:30 PM.

Similar Threads

  1. Macro To Close All CSV Files
    By Howardc in forum Excel Help
    Replies: 5
    Last Post: 03-15-2014, 05:24 PM
  2. Save Excel 2010 File In CSV Format VBA
    By mag in forum Excel Help
    Replies: 7
    Last Post: 01-08-2013, 07:16 PM
  3. Macro to export sheet as CSV
    By Howardc in forum Excel Help
    Replies: 2
    Last Post: 07-25-2012, 08:59 PM
  4. Replies: 1
    Last Post: 06-02-2011, 10:38 AM
  5. Save File In CSV Format VBA
    By Raj Kumar in forum Excel Help
    Replies: 3
    Last Post: 06-01-2011, 07:22 AM

Posting Permissions

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