#1   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
Posts: 113
Default vba

i write a lot of code vba in access database. is there a
way to do it in excel if so how are there any good
websites that can help me get started
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 863
Default vba

It's the same VBA language. In Access it's automatically hooked into the
Access object model. In Excel, it's the Excel object mode.

Have you spent any time looking at the code examples posted in this newsgroup?


On Thu, 17 Feb 2005 13:28:40 -0800, "Dan"
wrote:

i write a lot of code vba in access database. is there a
way to do it in excel if so how are there any good
websites that can help me get started


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 39
Default vba

Dan

I made the reverse cross-over as well (most go from Excel to Access). Most
of the language is the same. Aside from the habit of everyone calling their
code a 'macro' <bg you shouldn't find the switch that hard.

There are a couple of tutorials here that may help you get running:
http://www.geocities.com/WallStreet/9245/

My difficulty was coming to task with not having events attached to
everything.
Try this site for some guidance:
http://www.cpearson.com/excel/events.htm

Lurk on this group for a while, pick up the MVP's site and have a look at
how they solve problems.

Once you begin to get the knack, to get yourself up to speed in a hurry,
start answering some quesitons.

HTH
Steve



"Myrna Larson" wrote in message
...
It's the same VBA language. In Access it's automatically hooked into the
Access object model. In Excel, it's the Excel object mode.

Have you spent any time looking at the code examples posted in this
newsgroup?


On Thu, 17 Feb 2005 13:28:40 -0800, "Dan"
wrote:

i write a lot of code vba in access database. is there a
way to do it in excel if so how are there any good
websites that can help me get started




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 11:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"