corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

Corsa Sport » Message Board » Off Day » Geek Day » Microsoft Excel » Post Reply

Post Reply
Who Can Post? All users can post new topics and all users can reply.
Icon:
Formatting Mode:
Normal
Advanced
Help
Insert Bold text Insert Italicized text Insert Underlined text Insert Centered text Insert a Hyperlink Insert Email Hyperlink Insert an Image Insert Code Formatted text Insert Quoted text
Message:
HTML is Off
Smilies are On
BB Code is On
[img] Code is On
Post Options: Disable smileys?
Turn BBCode off?
Receive email notification of new replies?

Sam

 posted on 6th Jul 11 at 14:46

The macros in Excel use VBA - VBA being Visual Basic for Applications.

Dom means making an actual standalone application instead of just coding a macro in an Excel file.

But you would need to install Visual Basic on your PC to "develop" the application in.

I'd probably just stick with an Excel macro if you are happy enough with Excel.

[Edited on 06-07-2011 by Sam]


strick206

 posted on 6th Jul 11 at 13:58

What do you mean by a proper app Dom?

so vbasic is the thing to learn, what is it, could you elaborate for me?


Dom

 posted on 6th Jul 11 at 10:04

quote:
Originally posted by pow
TBH learning VB isn't a bad skill to have


True, knowing anyform of basic is useful (enviroments like Realbasic can compile to Win/nix/OSX) and it's pretty straight forward; could get the basics in a few days. But i still think it's worth scrapping Excel and develope a proper app.


pow

 posted on 6th Jul 11 at 08:51

TBH learning VB isn't a bad skill to have


Dom

 posted on 5th Jul 11 at 22:32

VBA is the next step for Excel but i'd really thinking about scraping Excel and design your own app (.NET, Realbasic etc).


pow

 posted on 5th Jul 11 at 20:24

Time to learn VB then ;) :)


Robbo

 posted on 5th Jul 11 at 19:23

learn vbasic


strick206

 posted on 5th Jul 11 at 19:14

I'm 'decent' on excel, but i have no idea when it comes to macros, and that is something i would like to learn, i have used access in the past but only briefly so have a slight understanding of it.

Macros is the main thing as i want to progress into the operating of a bot type system with excel taking live data from the net


pow

 posted on 5th Jul 11 at 19:02

The thing is, people try and replace what should be done by databases (Access, MySQL, SQL Server). If you're pretty good with Excel as it is, move on to start to learn Access. With that you can learn more about databases/handling information etc.


A2H GO

 posted on 5th Jul 11 at 17:20

Dom and Pow are spot on with Excel. :thumbs:


strick206

 posted on 5th Jul 11 at 17:14

Hello everyone, looking for some advice, i am quite good on excel, formulae and lookups etc, have built spreadsheets in the past to keep track of my betting and showing my profit etc. So can use excel quite well.

I want to push that to the next level, and become advanced on excel, i want to be able to use excel to work websites and search for things in conjunction with other equipment. I also want to become good with macros, i eventually hope to be in a position where being advanced in excel could be a big asset.

Is it Sam on here that is a whizz on MS Excel?

Any advice is appreciated, i don't mind enrolling to home learning or the like