473,320 Members | 1,867 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes and contribute your articles to a community of 473,320 developers and data experts.

Starting with Excel VBA Code

NeoPa
32,556 Expert Mod 16PB
One of the main reasons that Excel development is so easy to get into is that the Macro Recorder (Tools / Macros / Record New Macro...) can produce some (albeit pretty basic) code for you to look at and build upon.

Don't know the right object? Not sure of the right procedure? Excel can give you the tips you need to get into what you're wanting to do. As long as you know how to do something via the operator interface then you can find out quickly and easily at least one method of doing the same via code. The code built for you is pretty basic though. Not many developers with any pride at all will leave any in just as built, but nevertheless, the insight into what's available can prove invaluable as a start.

The Help system and your own capabilities are there to enable you to build on that. It really is a quick way to to get into the environment and become competent very quickly.
Oct 9 '11 #1
1 4442
JayF
45
I've been using Excel for years but only recently learned anything about VBA other than of it's existence. I've not had time to really delve into Excel VBA yet - I'm too busy learning Access - but I look forward to first playing with it armed with your tips above.

Thanks Neo. The world is a little better for the 576 people who have read this post. If everybody on the planet shared their knowledge as freely and persistently as you and your fellow posters do, the world would be a hugely different place.
Feb 22 '12 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Peter Smith | last post by:
Hello, I've a problem, and I'd appreciate any help you can offer. I'm developing an Excel XP Add-In with C#. The scenario is the following: 1. connect to a web service to get XML data (this...
2
by: Kumar | last post by:
Hi Folks, I have a question regarding my windows c# application. This application just reads MS Excel file and puts the data in to sql server database. In that excel file ,it has one named cell...
0
by: aaronfude | last post by:
Hi, I'm developing an Excel Automation add-in in C#, but that's all I know in terms of my environment. Basically, someone created a template for me and I'm continuing in blissful ignorance....
16
by: alexia.bee | last post by:
Hi all, In some weird reason, excel instance won;t die if i remove the comment from 4 lines of setting values into struct. here is a snipcode public...
1
by: fjlaga | last post by:
I'm developing an add-in for Excel using VB.NET. My current specific problem is how to load images in my command bar buttons. The CommandBarButton has a .Picture property of type IPictureDisp. ...
6
by: Gunawan | last post by:
Dear All, I have create an excel (COM Object) using this code Excel.Application xls = new Excel.Application(); but I can not remove it from memory although I have using close and quit ...
2
by: pixie | last post by:
Hi, I have some code that I have been using for more than a year. Excel VBA. Today it stopped working. I have no idea why. Here is the code: Range ("E1").Select If IsEmpty(ActiveCell) Then...
3
by: ohioboy | last post by:
I've worked 3 hours to solve this problem and I can't. I'm trying to write code to move data into an excel spreadsheet. When I first open Access and run the code everything works fine. As you...
4
ammoos
by: ammoos | last post by:
Hi Friends I am developing an excel application for e mail the copy of active worksheet. I successfully developed that functionality but my issue is sometimes this mail goes to spam folder since...
1
by: zohaibanwar | last post by:
this is the part of code i have completed Excel.Range chartRange; Excel.ChartObjects xlCharts = (Excel.ChartObjects)xlWorkSheet.ChartObjects(Type.Missing); Excel.ChartObject...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.