Reputation: 301 Architect
- Active Posts:
- 1,787 (0.88 per day)
- 26-March 09
- Profile Views:
- Last Active:
- Today, 02:04 PM
- OS Preference:
- Who Cares
- Favorite Browser:
- Favorite Processor:
- Favorite Gaming Platform:
- Your Car:
- Who Cares
- Dream Kudos:
- Expert In:
Posts I've Made
Posted 21 Oct 2014As modi123_1 has pointed out...You'll be future proofing your program to some degree.
VB.Net would seem like the logical choice, albeit migration might not be as straight forward as you may think (reliance on ActiveX controls in VB6 etc.).
Posted 4 Oct 2014You're not helping yourself...
1. Look at how to use code tags, it's not difficult.
2. Be more descriptive with what the actual problem is. "I'm having an error" and "it not the output I want" are not helpful to anyone to try and help you.
When posting, look at it the other way around...would you be able to advise someone on this issue if they'd given you the same information as you're posting here??
I'm not trying to get on your case, I'm just offering some friendly advice.
Posted 2 Oct 2014That's because you need to sum up your total in the loop.
TotalTime = 0 race = InputBox("How many races have you completed?") For loops = 1 To race time = InputBox("What was your time for race " & loops) TotalTime=TotalTime + Time Next
Posted 1 Oct 2014You're not storing your time anywhere?
Look at how you store the number of races then have a look at what you've done when getting the time for each race.
Posted 29 Sep 2014It explains how to use code tags in the background of the window you use to post....
I'm not all that familiar with VBA in excel, but to create the filename with the date, you should be able to use something like you already have.
dim strFilename as string dim strPath as string strPath = "C:\Temp\" 'Create a full path using the date and time strFilename = strPath + format(now(),"YYYY-MM-DD_HHMMSS") + " MyFileName.xls" ' This should give you a full path like "C:\Temp\2014-09-29_192040 MyFileName.xls" ' You should then be able to pass this into the Save method.
- Member Title:
- D.I.C Lover
- 43 years old
- June 12, 1971
- Programming Languages:
- C#, VB
- Website URL: