Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Excel VBA
Dear Experts,
 
I have a project, I will have one Excel 2010 Sheet which has a button that in order to import data from given .dat file or .txt file. The data from those files will be copied to the specified cells in excel sheet.
 
I have a basic on Excel and VBA, but I do not know how to start with the project.
 
Looking forward some helps from experts.
-Khoa
Posted 16-Nov-12 3:26am
Comments
Sergey Alexandrovich Kryukov at 16-Nov-12 15:01pm
   
Do you have a particular question? "I don't know how to start..." is not informative enough.
--SA
khoa pham van at 17-Nov-12 7:52am
   
Thank SA,
 
That is where can I start to learn to use VBA in excel from the basic, and how I can copy from the give file (.dat/.txt file) in to specified cells in excel. It's like tutorial for me to use VBA in excel.
 
Thank you,
-Khoa.
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

In Excel 2007 in order to view the code or to start the project one has to do some basic steps.
 
Select Excel options from Excel Toolbor (present at top left of the excel) and then select popular tab and select show developer tab in ribbon.
 
This will provide you a developer tab in excel sheet.
 
Select that and click Visual basic there you can find the code for your project.
 
Place appropriate debbuger in the code and analyze what is happening there.
 
And raise issues if you get any in this process?
 
Cheers!
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Take a look at some of these links[^].
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 5,380
1 Sergey Alexandrovich Kryukov 4,693
2 Peter Leow 2,939
3 DamithSL 2,465
4 Maciej Los 2,230


Advertise | Privacy | Mobile
Web01 | 2.8.140718.1 | Last Updated 26 Nov 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid