Click here to Skip to main content
15,666,947 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:

I'm currently doing a project for import data into a Excel file every day. Thus I need the Excel file create a column and rows automatically and write the data on it. Recently I'm plan to do column and rows automatically using VBA(Excel). Can anyone help me? Because I m really new for using the VBA.

Updated 31-Aug-15 22:43pm
Richard MacCutchan 1-Sep-15 4:52am    
The first thing you have to do is ensure that the Spreadsheet gets opened every day and the macro is run. As to the actual code required, that will depend totally on the data you are trying to add.
CgKumar 1-Sep-15 5:00am    
Okey. Have any idea or references that can guide me...please help me...I m struggle over here...thanks...
Richard MacCutchan 1-Sep-15 5:11am    
There are a number of websites which specialise in Excel programming; try them.
CgKumar 2-Sep-15 21:28pm    
thanks ;)

1 solution

It is not possible to help you the way you asked the question.

Your question depend on so many things:
- Where is everyday data ?
- What is the format ?
- What append when you skip 1 day ? Do you get 2 days of data ?
- How the macro get/read the data ?
- How the macro knows where to write the data in the worksheet ?

Nota: There is not such thing as Create columns or rows in an Excel worksheet.

All theses point can be a problem, so what is your problem?
Share this answer
CgKumar 23-Sep-15 2:45am    
thank you very much....

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900