Over 1 million tech questions and answers.

VBA programming on excel

Q: VBA programming on excel

I was just wondering if anyone could help me with writing a macro in excel. I am fairly new to VBA. I am trying to set up a Macro that will chart data and display values above a target line green and values below the target line red. If anyone can help me with this that would be great!

Thanks,
Matt

RELEVANCY SCORE 200
Preferred Solution: VBA programming on excel

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: VBA programming on excel

Hi cub18,

Welcome to the forums.

Plenty of people will help you on here, but you need to give a bit more information, and an attached spreadsheet is always a great benefit when attempting to solve issues like this.

It sounds like you just need to use conditional formatting, but again it depends on the details.

Read other 3 answers
RELEVANCY SCORE 54

I was asked to make a program using excel for the main purpose of managing shares, stocks, investments and others. That's why I am looking for good tutorials for excel programming, for this will be my first time doing something of the sort.
If any1 could give good recomendations and/or tips, it would be fantastic.
Thanks in advance guys. As usual, life savers ;)

Just noticed that Excel Programming is VB. So also comments on this area would be helpful.

A:Excel Programming

Are you asking how to set up a spreadsheet to "manage" investments, or perhaps about Macros to automate the process? I think it would help us if you could clarify what you expect the spreadsheet to do.
Thanks,
John

Read other 5 answers
RELEVANCY SCORE 54

I am trying to change the D53 cell reference in this statement to a variable defined as integer, without success. I would be willing to change the whole range definition to a variable if necessary. Any suggestions would be appreciated!!

ActiveChart.SetSourceData Source:=Sheets("WorkSheet").Range("A29:d53"), _
PlotBy:=xlColumns
 

A:Excel VB Programming

Welcome to the board, Bob W.

Where will the values come from?

x = Application.InputBox("How many rows?", "Size chart range")
y = Application.InputBox("How many columns?", "Size chart range", 4)
ActiveChart.SetSourceData Source:=Sheets("WorkSheet").Range("A29").Resize(x, y), _
PlotBy:=xlColumns

, perhaps.

HTH,
bomb
 

Read other 1 answers
RELEVANCY SCORE 54

Say, for example, I have a list of interest rates and the more people I sign up to my program, the higher my interest rate is. The time money would be invest for, is on the left-hand side, and the amount of people signed up is on the top.The items listed down on the left-hand side are as follows:~ Weekly~ Fortnightly~ Monthly~ 2 Months~ 3 MonthsThe top of the cells are from 1 - 10.The interest increase both as they go down, and across to the right.My question about this, is if I were to have a different table, and in that table I have people who sign up people, and I have (I have cell referenced each part)A1 - NameA2 - People signed upA3 - Interest rateB1 - JohnB2 - 3B3 - (the interest rate)C1 - AimeeC2 - 7C3 - (the interest rate)I was to know that from the first table set up, how can I get Column 3 to represent the cell from the amount of people that have signed up. So, that in Column 3, the interest rate that is shown is from the first table, and gets the amount of interest from the people signed up.No, it's not just simple "cell referencing" because I want the interest rate to be based on both the, time period, and how many people signed up, and I want it to be automatic instead of me doing it manually.Is it possible?NOTE: Here is a perfect example of what I want to achieve, just some things change.

A:Excel Programming?

I'm not an Excel guru but I'm sure that you could make something work with either a combination of VLookup and HLookup or just Hlookup and an if statement.Here's a pretty good link on embedded vlookups. hlookups work the same way except it searches by the row rather than a column.http://pubs.logicalexpressions.com/Pub0009...icle.asp?ID=446

Read other 2 answers
RELEVANCY SCORE 54

Hi

Id like to set Toggle Button 1:

When Value to show Cell A1
Else, cell 1 to be hidden.

Advice please!

Thanks!

M
 

Read other answers
RELEVANCY SCORE 53.2

I have two spreadsheets; the first has two columns, UPC and ITEM; the second has many columns of which UPC is one. I need to create a lookup function or something that will insert the value of ITEM from the first spreadshet into a new column I will create in the second spreadsheet based on the UPC matching. I prefer to use Access for these situations but I don't want to do that with this data. Is this easy to do?
 

A:Excel LOOKUP Programming

Yes. Give me 5 minutes & I'll post a formula. Or does it have to be "programming"?
 

Read other 3 answers
RELEVANCY SCORE 53.2

I want to use MS Excel for keep records of a warehouse. I have created an invoice with necessary formulas and it automatically calculates everything, writes the final total in words. Now I want to connect this invoice with a warehouse record to automatically keep records of invoices issued and to automatically reduce the quantity of goods from the warehouse. This should help me to find the availability of goods at the warehouse at any given time and also to see the sales progress.
The problem is I don't know the formulas to be used for this type of programming.
Please help me with some idea about the formulas to be used.
Thank you.
 

A:Microsoft Excel programming

Read other 11 answers
RELEVANCY SCORE 53.2

Hi Guys,

Let me start off by stating that I'm still trying to learn all the juicy functions you can do with Excel, and I've just gotten myself a little project where I think I can learn but I need some kind of help from you guys.

Basically what I'm trying to do is somehow automate a creation of a report via excel, first method I thought of was to use macros, but since the data that'll be included in the report will be on a different cell each time, macro might not work as I imagined it to be, then I thought of the IF function, I have not yet tried doing that, but would that work? Can you please share your thoughts? Ask me any additional info and i'll try to explain it as simple as I can.

Cheers.

A:[HELP] Programming in Excel 2013

Your description is entirely too vague in order for anyone to offer any kind of help. Can you be more specific as to what kind of a report you want to generate and what data you will be using?

Perhaps you could post a sample of the worksheet with the data and a sample of what you want the report to look like.

Read other 2 answers
RELEVANCY SCORE 53.2

Anybody know how to format a cell like this?

I would like my cell to total up a bunch of items, much like the Epsilon (at sum), but then I want the display font to be blue when it is positive, and then red when it is negative.

Thank you.

------------------
"There are no stupid questions, just stupid people." -- Mr. Garrison on South Park
 

A:Excel Programming... or formatting

Highlight the cell, rows or columns you want formatted. On the Menu-Format>Conditional Formatting. Using the
Cell is: Greater than: 0 and
Cell is: Less than: 0
and specifing the patterns or font you want for each particular scenario should get you what you want.

The above uses two Conditional Formats you may be able to get your conditions set up using only one box. It also leaves 0 without a format so you may want it to be inclusive on the negative or positive result.

 

Read other 3 answers
RELEVANCY SCORE 53.2

I am writing a food costing program in excel to calculate a number of costs, conversions etc. in Microsoft Excel. I have my code working to what I would like it to do but I have hit one snag. I want to be able to copy and paste the code throughout the spreadsheet and I need certain values to remain the same and some to change accordingly.=LOOKUP(A13,Centennial!A6:Centennial!A26,Centennial!E6:Centennial!E26) that is the code and I need the values of the ranges to stay the same(A6,A26,E6,E26) and A13 to change as i copy and paste. How do I keep those values constant?
 

A:Excel Programming Constant Value

use a $ sign to fix the position

A6

to keep the column from changing type

$A6

to stop the row changing type

A$6

to fix both column and row

$A$6

so for your look up range

$A$6.$A$26
 

Read other 3 answers
RELEVANCY SCORE 53.2

when i try to make an vba code in excel vba extension at the moment i added
this line to the code of a button:

Range("A1").End(xlDown).Offset(1, 0).Select
it says there is an error but i did exactly what they said on this video
https://www.youtube.com/watch?v=CzP8nO9UVvY
its explained just after 25:12 minutes

A:excel vba programming code

I tried the code and it works without errors. Are you sure it's that line it complains about?

This shorter one works to: Range("A1").End(xlDown).Select

Read other 9 answers
RELEVANCY SCORE 52.8

Hello to the members of Tech Support. This is my first post, so thanks in advance for the help! So here is goes.

-I have 9 worksheets with approximately 77500 rows and 23 columns of data between all nine.
-At the top of the worksheet I have a table data running from E7 to N7. This data is carried over from the previous month's data.
-Column AA has a formula: =Z13+(O13-Q13)*3340.4
Where Z13 is the first row where the data begins, and Z### is where the data ends. Rows of data vary from month to month. The formula carries on such that row 14 uses the same formula but insert 14 vice 13. The number 3340.4 is the number found in cell E7 and always the multiplier in the formula.
-Column AA on worksheet 2 requires the same formula. =Z13+(O13-Q13)*4567.3. However note that the 4567.3 is the next number over in cell F7 and is now the multiplier until the last row.
-Worksheet 2 has a different number of rows (which also varies from month to month.).
-The data for each month is always found in cells E7-N7.

Worksheet 3 would use date in G7 and so on....

Any help with the coding of this Macro would be greatly appreciated.
Thanks
Can someone help me with the macro to automatically
 

Read other answers
RELEVANCY SCORE 52.8

Hello All techies here,

I am very much new to this forum.I am aware that it is possible to send emails from Excel using VB programming but I am very much unaware of VB programming and tricks.

I am working on a work where I need to generate automated mails from excel via outlook based on the contents of the selected cell and some logics.

Here is the URL for image that will give some rough idea.

https://fbcdn-sphotos-d-a.akamaihd.net/hphotos-ak-snc7/s480x480/391681_552548121437857_52068638_n.jpg

or
https://fbcdn-sphotos-d-a.akamaihd....480x480/391681_552548121437857_52068638_n.jpg

or

from this sheet(shown in image) I want to generate mail with logic like this :
case 1) If i click on MSS in row ABC ,click on APD and then press " @ " then it should generate a mail like below and send it to [email protected] and cc : [email protected]

subject : "card request"

mail body
**********
Hello,

My name is ABC (i.e. A2 content).
I need to have some MSS card of APD type
value 1
value 2
value 3
if above cards are not present then we can also use VD
value 4
value 5
value 6

Regards,
Shashank1320
*************

case 2 )but if I press MCS in row ABC ,APD and then press @ then it should send mail to [email protected] and cc : [email protected]

subject : card request
mail body
*****
Hello,

My name is ABC (i.e. A2 content).

I need to have some MCS card of APD type
value 1
value 2
value 3

if above cards are not present then we can ... Read more

A:Email sending from Excel programming

Welcome to the forum,
I suggest you do a search for similar posts, give or take minor differences they all come down to the same solution.
Once you've found something taka a look and try it out.
 

Read other 3 answers
RELEVANCY SCORE 52

Question to the group:
I do a lot of intensive VBA programming within MS Access (2003 and 2010) for clients and have always programmed on PC platforms within Windows 2000, XP, 7 operating systems. Everything's worked just great. No problems.
I recently purchased a MacBook Pro and had Windows 7 installed on Bootcamp. I've installed MS Office 2010 and the installations are all humming along nicely and everyone seems to be playing well together.
My problem is that my existing Excel and Access applications that use VBA code generate boatloads of errors on the Mac platform (with Windows 7 running on Bootcamp). Attempts to program anything but the simplest VBA scripts also generate errors that do not appear on the PC platforms.
My questions are: Is this a problem with References or program/computer settings? Have other programmers tried to do the same thing I am doing and had the same problems? Is the Mac system simply incompatible with a Bootcamp/Windows/Office/VBA layering? Is there a solution? I can't find any other references to this problem in the searches I have performed so far. Any input would be appreciated.
Thanks in advance.
 

Read other answers
RELEVANCY SCORE 52

hi to all,

i'm writting a marco to populate the row and col in the spreadsheet. I provide an form interface for the user to key in the data before reflect the data in the spreadsheet. my question is how do i detect the first blank row and transfer the data into that blank row in the spreadsheet.

i only have 9 columns and therefore i hardcode the colum, however, i need to find the blank rows so as to insert the data.

Cells(currentRow, 1) = txtTime.Text
Cells(currentRow, 1) = txtDate.Text

can someone tell me how to fiind the index of the rows???????

Thank in advance
 

A:excel marco programming detecting blank row

The code you have writes txtTime and txtDate to the same cell. Try:

newrow = Range("A65536").End(xlUp).Row + 1
Cells(newrow, 1) = txtTime.Text
Cells(newrow, 2) = txtDate.Text

, assuming you have at least one row already.

I couldn't tell you what data type to use for newrow. Zack could tho', he might drop by later.

HTH,
bomb
 

Read other 3 answers
RELEVANCY SCORE 51.6

Excel 2016 Formulas is fully updated to cover all of the tips, tricks, and techniques you need to maximize the power of Excel 2016 through the use of formulas. This comprehensive Training Program explains how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. Whether you're a beginner, a power user, or somewhere in between this is your essential go-to for the latest on Excel formulas

Enrol This Course Now

PART=1
1. Workbooks (File) & Worksheet Handling
Excel Limitation

Excel Shortcut use and benefits

Excel Setting and Custom List Creation

Excel Tamplate and File Location System

Advanced Paste Special

Calulation with Paste Special

Link Data range as Picture Link

Loopkup Picture in Excel Worksheet

2. Advanced Formating for Reports and Dashboard
Formatting Triks

Date & Time For Trinks

Advanced Custom Formating (Number Format using Code)

Condtional Formatting

Advanced Conditional Formatting using Formulas

File,Sheets or Cells Protection Method

Benefits of Data Table or Cells Style

3. Data Handle and Data Analysis
Data Fill and Selection Method

Advanced Sorting and Filter Trinks

Data Summerization with Pivot Table

Calculation with Pivot table

Extranal Data Pivot Table

Relationship and Slicer in Pivot Table

Power Pivot in Excel 2016

Use SQL Query in Pivot Table

4. Page Setting and Form Creation
Drow Form in Excel Sheet

Hyperlink i... Read more

Read other answers
RELEVANCY SCORE 51.6

I am writing a food costing program using excel. The program is designed to pull prices from various tabs(different suppliers) to a main Supplier Costing Page containing all the information on products for all suppliers. The code allows the user to enter in the name of the product, then uses the LOOKUP function to search for the product and returns the value in that row. The code I used to pull the information from the different suppliers works properly:

A19 value Steak Strip Loin C/C St. Silver FRSH

=LOOKUP(A19,Centennial!$A$6:Centennial!$A$100,Centennial!$R$6:Centennial!$R$100)

Centennial is the tab for that supplier. It pulls the correct value from the page 0.74, to cell R19
The problem I am having is that when I try to use this format of code on another tab it does not return the correct value:

=LOOKUP(A33,'Supplier Costing'!$A$6:'Supplier Costing'!$A$100,'Supplier Costing'!$R$6:'Supplier Costing'!$R$100)

The code should return the same value of the previous line of code as it is the same product:0.74 to cell R33 this time, however it returns the value of another product on the Supplier Costing tab. Is the LOOKUP function not searching the tab for the whole string? Any help or suggestions would be extremely helpfull. Thanks
 

A:Solved: Excel Programming Code Produces Wrong Value

Read other 12 answers
RELEVANCY SCORE 51.6

Hi there

I found an example on the internet on how to solve a linear programming problem using Excel 2000 Solver. I have attached a workbook with all the information you will need to solve the linear programming problem. I must be doing something wrong because my solution is different from the example I found on the internet. Here is the link to the internet example

http://www.ateneonline.it/chase2e/studenti/tn/6184-7_supA.pdf
 

Read other answers
RELEVANCY SCORE 42.8

Hiya

Visual Studio Tools for the Microsoft Office System can help you take advantage of the productivity enhancements in the Microsoft .NET Framework to extend Microsoft Office Word 2003 and Microsoft Office Excel 2003 using Visual Basic .NET and Visual C#. The tools include new Visual Studio .NET projects for creating code behind Word documents, Word templates, and Excel workbooks.
System Requirements
Supported Operating Systems: TabletPC, Windows 2000, Windows 2000 Service Pack 2, Windows 2000 Service Pack 3, Windows ME, Windows NT, Windows Server 2003, Windows XP, Windows XP 64-bit

.NET Framework
Office 2003

http://www.microsoft.com/downloads/...5f-c764-4cc3-a5f3-48c9103f6b2f&DisplayLang=en

Regards

eddie
 

Read other answers
RELEVANCY SCORE 42

Hiya

Learn about COM interoperability between Microsoft C# and large, complex COM servers. This article shows how to prepare the Office XP COM objects and how to use them in a C# program, and offers some tips on understanding why things have to be done in certain ways.

System Requirements
Supported Operating Systems: Windows XP

To run the sample, you will need the following software installed on your computer:

Microsoft Windows® XP or Microsoft Windows 2000 and related service packs (SPs)
Microsoft Office XP and related SPs
Microsoft .NET Framework and related SPs
Microsoft Office XP Primary Interop Assemblies (PIAs)
Microsoft Visual Studio® .NET
http://www.microsoft.com/downloads/...0c-d2f3-48bb-8e76-7c8892b5ed95&DisplayLang=en

Regards

eddie
 

Read other answers
RELEVANCY SCORE 33.6

hi,
i am trying to create a sort of computer search using C++ ( Dev-cpp compiler ) but i have no idea how to access the hard disk ( or any other drive).

Please help!

thanks
 

A:Need Programming Help!!!

hi

how do u meen u dont know how to get to the hard drive
 

Read other 4 answers
RELEVANCY SCORE 33.6

what's the easiest programming language for beginners
 

A:programming

Read other 6 answers
RELEVANCY SCORE 33.6

I have limited programming experience Close to none. I would like to build a program where I could click on a icon, have it ask me for my input ,or a series of questions or options and give me an answer.Give me a a,b,c,d answer than move on to next question until enough input to give answer.
Example:
What kind of law
a Penal law
b civil
c traffic
d trucking Law
Section of law Input
221.05
Has he had any previous convictions
a yes
b no

Answer Fine of 250 - 500

I'm confused with what I should learn first.C+,Access,Excel
Is there a online site that works well with teaching and what do I start with?
I would be doing this on my own so I don't want to spend a small fortune but can spend some.
Thanks
Any help appreciated and I hope I'm in the right forum
 

A:New To Programming

Read other 11 answers
RELEVANCY SCORE 33.6

Hiya

Bit of a long shot, but does anyone do any of this type of programming? If so, the requirements are XP Pro, but just curious if you can do this on XP Home.

If not, I'll invest in an upgrade for my other system and use it on there

Thanks

eddie
 

Read other answers
RELEVANCY SCORE 33.6

Am trying to create a program with vb6 about disease diagnosis system please help if we have any vb6 programmers here. thanks.
my email: [email address removed]
 

A:Programming with VB6

Hmm; Sounds like a decision tree system.

Recommend PHP, easy to learn and lots of built-in functions, including arrays, lists, sort and pattern matching.

If the data is voluminous, you should store the 'facts' in a database (MySQL).
 

Read other 3 answers
RELEVANCY SCORE 33.6

Share ideas on php programming, from beginners to professional programmers.
 

A:pHp programming

webkajah said:


Share ideas on php programming, from beginners to professional programmers.Click to expand...

go to php.net
 

Read other 2 answers
RELEVANCY SCORE 33.6

Does anybody know good websites to learn programming please ?!!
i wanna learn programming but i dont know how to start and from where to start
 

A:Help with programming

Might help if you told us what kind of programming you wished to learn.
 

Read other 10 answers
RELEVANCY SCORE 33.6

Hello everyone,

New to the forums and I really need some help. I'm trying to create a little man program that would accept any three user inputs and return them in order from largest to smallest. I really have no clue where to start since I'm completely new to programming. Please help..
 

A:Little Man Programming

Read other 8 answers
RELEVANCY SCORE 33.6

I have been trying to consolidate several programs onto a USB Bootable hard drive. I have been using the Choice command in the Autoexec.bat file to give me a choice of what programs to start. However choice is only returning errorlevel 1; no matter what number I push. Any ideals? Work in progress.

Note: I use a second choice to allow a 20 sec time so I may see what Echo measage is displayed. However no matter what I push I always Get
Starting Re-image 1

@ECHO OFF
:START
CLS
ECHO -------Enter Number-------------

ECHO 1- Image PC with XP image.
ECHO 2- Image PC with 2000 image.
ECHO 3- Load Ghost 2003.
ECHO 4- Load Techie's Toolkit.
ECHO 5- Load ERD Commander.
ECHO 6- Start Computer with CD-ROM Support.
ECHO 7- Start Computer without CD-ROM Support.
ECHO 8- Run GDISK to delete all partitions.
ECHO 9- Load Drive Scrubber for DOD Cleaning.

ECHO -------Enter Number-------------

ECHO OFF

CHOICE /N /C:123456789W /T:W,20 Select a number (Windows will start in 20sec)%1
IF ERRORLEVEL 1 GOTO XP
IF ERRORLEVEL 2 GOTO 2000
IF ERRORLEVEL 3 GOTO GHOST
IF ERRORLEVEL 4 GOTO TOOLKIT
IF ERRORLEVEL 5 GOTO ERD
IF ERRORLEVEL 6 GOTO CD
IF ERRORLEVEL 7 GOTO NOCD
IF ERRORLEVEL 8 GOTO GDISK
IF ERRORLEVEL 9 GOTO DSCRUB
IF ERRORLEVEL w GOTO WIN

REM ------------1------------------------------
:XP
ECHO Starting Re-image 1

CHOICE /N /C:Z,M /T:M,20 Will start over in 20 sec
IF ERRORLEVEL Z GOTO OVER
IF ERRORLEVEL M GOTO OVER2
:OVER
ECHO START OVER
GOTO START
:OVER2
ECHO START OVER
GOTO S... Read more

Read other answers
RELEVANCY SCORE 33.6

i have no programming knowledge and i what to start
learning to program.
what are good books to start. thank you!
 

A:programming

I'd recommend looking around on the internet
first, then decide which language you want to
learn. You can also find a lot of tutorials to help
you get started.
 

Read other 2 answers
RELEVANCY SCORE 33.6

Hey I want to start to code. I was wondering where you all would reccomend i started? I did Python for a while then, dropped it...any suggestions?

thanks
 

A:New to programming

Read other 11 answers
RELEVANCY SCORE 33.6

Hi, I have a text file which contains the column headings as well as the data(that goes into the headings) in a jumbled way.COuld anyone help me with a script to separate the columns & data?I have attached the text file. The details of the text is as below:
The ones in upper case are the headings)column names), the ones in the brackets are the data and the ones that follow the brackets in lower case are the units.
COuld anyone help?
Thanks,
Cali
 

A:C programming

Read other 6 answers
RELEVANCY SCORE 33.6

i need help with this question...anyone could help me out please ??

Use for loop to create a C program that can calculate and display result as below: (3 marks)

square root of 6=2.449490
square root of 5=2.236068
square root of 4=2.000000
square root of 3=1.732051
square root of 2=1.414214
square root of 1=1.000000

anyone can write the programme out for me please ??
 

A:C programming

Read other 7 answers
RELEVANCY SCORE 33.6

Hello all
I am not sure where to post this question so I will post it here.

I just started learning programing a few months I have just got the basics of programing right as of now(i.e) Writing very simple programs like base convertors and things like that. I am using C as of now. I was wondering how do you create a GUI, I dont want the program to run in the dos mode when some one runs it. If some one could tell me where I could find an online tutorial as to where I can learn about the above mentioned I would be very thankful.

Thanks in advance.
 

A:Programming help!!!!

It reallly depends on what operating system you are running. But, I will guess that you are running Windows. I never really found a good online tutorial outlining windows gui programming. I would recomend that you get any book by Herbert Schildt. I got Windows 2000 Programming from the Ground Up by him and I learned so much. I would especially recomend that book to you, except for the fact that it is geared towards C++.
 

Read other 2 answers
RELEVANCY SCORE 33.6

Hello everyone.

I am a college student in the Computer Information systems field. I have decided that programming is one of the areas which I wish to study. I really want to learn as much as I can about programming and it's how-tos and such, but I ma a bit impatient when it comes to waiting on certain quarters for certain courses. I was wondering if there are any certain Web sites which I could look at to begin learning independently? I will be starting a course in C++ in January, but I know little about this language. Will I need a certain software application to program in this language, or can I use any type of word processing program or MS-DOS application?
I am just wondering if there are any areas out there with resources on how to independently learn various programming languages. I don't have much money at all, so I cannot afford to buy books or other materials such as software...Fortunately, I have financial assistance and scholarships to pay for college...
Thanks in advance for any help and guidance.
 

A:New To Programming...

http://www.cppreference.com/
http://www.google.com/search?q=c++;+tutorials&sourceid=opera&num=0&ie=utf-8&oe=utf-8

Those links should help.

Keep in mind that a lot of tutorials are old and do not show you how to do things the modern way. You can always ask for everyone here to critque your code to see if it's good and modern.
 

Read other 2 answers
RELEVANCY SCORE 33.6

Hi, I'm wanting to learn to do some programming. I just need to know where I can get the stuff to do it with. What exactly do I need? Recommendations? Where can I get it? I'm really wanting to learn how to do this. Please help.

P.S. I've done some minor basic programming, but i want to learn to be able to write major programs. Or at least the steps I need to take to be able to write decent programs. Anything will help. I've writtin small programs to return text results, but I want to do more, like learn a little about making games, apps, etc.
 

A:Programming

Read other 9 answers
RELEVANCY SCORE 33.6

Hiya

I'm going to go back to programming, but the last compiler I used was Borland C++ version 3. I have version 6 in my shopping basket at Amazon, but was wondering if I should look at VB .Net.

The reason I'm curious, is that C++ doesn't seem to be mentioned anymore, and it may be a dying code. The version I can get for the same price is Visual Basic .NET Standard 2003 from Microsoft.

As they're retailed at ~£70, I don't want to get C++ and start learning again, and compiling a few programs, etc, to find out its no good. I know that .Net is for the web, whereas C++ is Windows based. But what are the other differences?

Look forward to any response, as I'd like to try and get out of my mundane job

Regards

eddie
 

A:C++ or .Net programming?

Read other 16 answers
RELEVANCY SCORE 33.6

i was wondering on where to begin..

my main purpose is to use excel and code it with vba so that a user can input specified field information and press a submit button. once that submit button is pressed, the information on the excel spreadsheet will go into probably an access database on a server.

how can i go about doing that?

thanks
 

A:VBA programming

Read other 11 answers
RELEVANCY SCORE 33.6

If I were going to start learning how to create different programs, how would I start? Should I start by reading, downloading a program, or what? I tend to suck at learning through reading, so I'd prefer to go through a program teaching me how to program with different "languages"(I guess that'd be what you call them).

Thanks.
 

A:Programming

Look for something like ITT Tech, DeVry or a community college course
on programming.
 

Read other 13 answers
RELEVANCY SCORE 33.6

After going through the PHP tutorials online, I have come to know that the following is required for PHP :
a) Installation of Apache server
b) Installation of PHP and
c) Installation of MySql
Since Oracle is there in my computer, I assume that MySql has been installed. For the PHP, I had come across the following site : http://www.php.net/downloads.php
Here, I ahd downloaded in.php.net from my location(i.e India)
Now, Im unable to open the tar file.Could anyone let me know how to go about it?
 

A:PHP programming

Oracle is unrelated to MySQL, and you can use this to install Apache, MySQL, and PHP:
http://www.wampserver.com/en/
 

Read other 1 answers
RELEVANCY SCORE 33.6

Hi,
Im having an ASP script with me.If i double click the file & open it with a notepad, I can see the code.Could anyone tell me how do I run the file so that I can see the output?I have attached the file for reference.
Now, what I could guess from the code is that it displays the birthday message.But what Im trying is to make the script work in such a way that this message goes to a particular person(his email id that has to be taken from an Access file) whose b'day falls on that day.
COuld anyone help me with this?
 

A:ASP programming

Read other 6 answers
RELEVANCY SCORE 33.6

Hey guys, i hope someone can help me.

I have created several Tables and forms and macros and reports in Microsoft access. they all link to the same databse which is constructed by the tables (certain fields related).

Now i need to integrate that with my Intranet, Google isnt really helping and my brain feels like to guy who played Lord of the Rings: Rise of the WitchKing against me this weekend, :-( LOST and TIRED!!! so if anyone can help??

Plz!!

Thank you very much!!
 

A:Programming Anyone??

Internet access to a DMBS (eg Access) has this data flow:

Code:

the browser[1]
has a web page
usually some < form data >
click submit -------> http GET or POST ---> webserver[2]


---> webserver[2] -- runs the requested CGI program
|
|
which accesses the DBMS
reads the query results
formats a HTTP reply
browser[2] <----------------- and writes it to STDOUT

So you need
1) HTML coding for the browser,
2) CGI programming to receive the request (eg PHP,Perl)
3) and an API to connect/query to your Access DBMS
(btw: it needs to be on the webserver, not your pc)
 

Read other 3 answers
RELEVANCY SCORE 33.6

hi all

Please help me to make an idea to develop a photo capturing program with my vb programm. Means I want to do my own program in vb to achieve this (without using any theord party controll)

I know there is an MCI control(OCX) in vb to run and record some musics and avi.

But I don't know how to program it for my web cam !!

Please help me !!
Thanking you

James
 

Read other answers
RELEVANCY SCORE 33.6

I have Visual Basic 6.0
I am trying to learn how to make games with visual basic. I've read tons of online articles, followed tutorials, read books, and still nothing really explains each piece step by step.

Does anyone know where I could find something/someone to teach me how to make games with visual basic?

I understand how to use Visual Basic itself. I just lack the knowledge of how to turn the controls, modules, etc. into something productive. I'm thinking about going out and buying some books on DirectX. I'm sure they will come in handy.

Right now all I want to be able to do is make a simple game. (Pac-Man, Pong, Tetris, etc.)

But soon I want to make my own RTS (real time strategy game).
I don't know where to start, where to go. Please Help.
 

A:Help with VB programming

hey,
im not the best in VB or anyting but i have a petty good understanding and i dont think u could amke a very good RTS in VB. thats pretty complex, if u wanna do something like that, try learning C++ or something more advanced.

good luck in ur efforts anyway!!
 

Read other 3 answers
RELEVANCY SCORE 33.6

I'M NOT SURE IF I'M IN THE RIGHT CATEGORY, BUT HERE GOES! I WANT TO CREATE A PROGRAM WHICH SOLVES CROSSWORD CLUES. IE, YOU PUT IN THE LETTER YOU KNOW WITH QUESTION MAKRS FOR BLANK SPACES, AND THE PROGRAM SEARCHES OUT ALL THE MATCHING WORDS FROM ITS OWN DICTIONARY (WHICH I WILL INPUT). I HAVE NEVER DONE ANY PROGRAMMING BEFORE, AND WANT TO KNOW WHERE I CAN GO TO FIND OUT MORE ABOUT THIS.
 

A:Programming

Hi, teresa

This crossword program... bit of a biggie to start with if you're not exactly experienced in programming. Are you sure you're not re-inventing the wheel with it? There are loads of good programs on the web that do what you're asking. Try the following link...

http://www.ekelundh.com/crossword/

If you're really determined to build such a program it'll take years just to type out the dictionary database. However, if you use Perl to do the processing with an HTML interface you can atleast get started. Perl is free to download from :

http://www.activestate.com/Products/ActivePerl/

and there are literally thousands and thousands of tutorial sites on Perl, HTML and lots of other languages.

Perl is good for doing letter and word searching functions, though not the best. But it is free and nice and flexible.Following is a Perl tutorial.
http://www.comp.leeds.ac.uk/Perl/start.html

Best of luck.

JoyousMonkey
 

Read other 1 answers
RELEVANCY SCORE 33.6

Hi all,

Can you please help me to finish may program.
i am using visual basic and microsoft access for may database.
may program is about save and print the search data.
i already search, add, create and save but may problem is to print the only search data. or pls. help me to understand more about programming. I have only basic knowlofge about the program.but i want to create a simple program for our company.

thank you so much
ythak
 

A:help for programming

Have you tried using some online tutorials ?
 

Read other 3 answers