Import .csv file with more than 65536 rows into multiple excel she

S

Snehal Patel

Hi,

I have .csv files, all of which have more than 65536 rows. I want to import
it into Excel file with multiple sheets. I don't know much about macro. Can
anyone please help me with the code to import the .csv file into multiple
..xls file.

Thanks in advance,

Snehal Patel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot import CSV file into ACCESS 1
Import Multiple CSV Files from Same Folder into Open Workbook 5
Excel VBA macro to auto import new CSV file from fixed directory 1
Merging from an Excel file with graphics 1
Merge Excel file into Word Document 3
Excel And Notepad 3
Split a text file with more than 65536 lines over many worksheets 5
Data Import Question 0

Top