Anyone other than Hal and Jeff successfully using Flyboy's ECUx spreadsheet?
09-09-2006, 09:26 AM
#1
Member
Thread Starter
Join Date: Aug 2006
Posts: 2,686
Likes: 0
Received 0 Likes
on
0 Posts
Anyone other than Hal and Jeff successfully using Flyboy's ECUx spreadsheet?
I keep getting run time errors and a request to debug when I attempt to upload an ECUx .csv
<a href="http://www.myaudis4.com/info_ecu.htm">Click!</a>
<a href="http://www.myaudis4.com/info_ecu.htm">Click!</a>
09-09-2006, 10:08 AM
#2
AudiWorld Super User
Join Date: Apr 2000
Posts: 3,849
Likes: 0
Received 0 Likes
on
0 Posts
1) What OS are you running it on? I can't get it to work on my Mac, but works fine
with WinXP. I believe it's with the way the different systems locate files.
2) When did you download the spreadsheet? The most recent version has a button to "clear all data" and a "Combo chart".
3) Are you enabling Macro's when you open the spreadsheet?
4) Are there any other spreadsheets open when you run that program. If so, that will crash it. It does some copy and pasting of data and other open spreadsheets will cause problems.
If none of these fix the problem could you provide a little more detail about what you do when you get the errors. I've run the program on a couple different systems successfully, but it's not a terribly robust program, so you need to play by it's rules to get it to work right.
2) When did you download the spreadsheet? The most recent version has a button to "clear all data" and a "Combo chart".
3) Are you enabling Macro's when you open the spreadsheet?
4) Are there any other spreadsheets open when you run that program. If so, that will crash it. It does some copy and pasting of data and other open spreadsheets will cause problems.
If none of these fix the problem could you provide a little more detail about what you do when you get the errors. I've run the program on a couple different systems successfully, but it's not a terribly robust program, so you need to play by it's rules to get it to work right.
09-09-2006, 10:22 AM
#3
Member
Thread Starter
Join Date: Aug 2006
Posts: 2,686
Likes: 0
Received 0 Likes
on
0 Posts
1.) WinXP 2.) Downloaded newest today (thanks Hal) 3.)Yes 4.)No
So none of those fix my problems.
More detail, hmmm....
I hit "get ECUx data" and choose file, then I get the error.
"run time error '9'
subscript out of range"
A window pops up showing this message and your options are end, debug, or help. Help did not explain it in any terms I understood.
TIA!
More detail, hmmm....
I hit "get ECUx data" and choose file, then I get the error.
"run time error '9'
subscript out of range"
A window pops up showing this message and your options are end, debug, or help. Help did not explain it in any terms I understood.
TIA!
09-09-2006, 10:29 AM
#4
AudiWorld Super User
Join Date: Apr 2000
Posts: 3,849
Likes: 0
Received 0 Likes
on
0 Posts
If you select debug it should take you to the line in the code where the error is occuring.
If you could paste the line into a post I could then take a look here and see if I can't guess why it's failing. It sounds like there's something about the file you're importing. Could you email the csv file to me, then I can try to reproduce the error on my computer. Have you tried to import a different csv file?
09-09-2006, 10:47 AM
#6
Member
Thread Starter
Join Date: Aug 2006
Posts: 2,686
Likes: 0
Received 0 Likes
on
0 Posts
I've tried a few different CSVs that are logged using Mark P's group file.
Workbooks(2).Worksheets(1).Cells.Copy _
Destination:=Workbooks("4xECUx.xls").Worksheets("1 ").Range("A1")
That is the section of code highlighted. <shrug>
All the files I'm trying to use are uploaded to Nye's site so you can see the raw data there:
<a href="http://nyet.org/fats/uploads/Typical-9-6-2006_9-25-55_PM%20Doc.csv">http://nyet.org/fats/uploads/Typical-9-6-2006_9-25-55_PM%20Doc.csv</a>
<a href="http://nyet.org/fats/uploads/Typical-9-1-2006_6-07-08_PM_JC.csv">http://nyet.org/fats/uploads/Typical-9-1-2006_6-07-08_PM_JC.csv</a>
<a href="http://nyet.org/fats/uploads/Typical-8-31-2006_12-12-54_AM.csv">http://nyet.org/fats/uploads/Typical-8-31-2006_12-12-54_AM.csv</a>
<a href="http://nyet.org/fats/uploads/Typical-8-24-2006_12-17-56_AM.csv">http://nyet.org/fats/uploads/Typical-8-24-2006_12-17-56_AM.csv</a>
<a href="http://nyet.org/fats/uploads/Typical-8-24-2006_12-15-04_AM.csv">http://nyet.org/fats/uploads/Typical-8-24-2006_12-15-04_AM.csv</a>
Destination:=Workbooks("4xECUx.xls").Worksheets("1 ").Range("A1")
That is the section of code highlighted. <shrug>
All the files I'm trying to use are uploaded to Nye's site so you can see the raw data there:
<a href="http://nyet.org/fats/uploads/Typical-9-6-2006_9-25-55_PM%20Doc.csv">http://nyet.org/fats/uploads/Typical-9-6-2006_9-25-55_PM%20Doc.csv</a>
<a href="http://nyet.org/fats/uploads/Typical-9-1-2006_6-07-08_PM_JC.csv">http://nyet.org/fats/uploads/Typical-9-1-2006_6-07-08_PM_JC.csv</a>
<a href="http://nyet.org/fats/uploads/Typical-8-31-2006_12-12-54_AM.csv">http://nyet.org/fats/uploads/Typical-8-31-2006_12-12-54_AM.csv</a>
<a href="http://nyet.org/fats/uploads/Typical-8-24-2006_12-17-56_AM.csv">http://nyet.org/fats/uploads/Typical-8-24-2006_12-17-56_AM.csv</a>
<a href="http://nyet.org/fats/uploads/Typical-8-24-2006_12-15-04_AM.csv">http://nyet.org/fats/uploads/Typical-8-24-2006_12-15-04_AM.csv</a>
09-09-2006, 10:54 AM
#7
AudiWorld Senior Member
Join Date: Sep 2005
Posts: 1,863
Likes: 0
Received 0 Likes
on
0 Posts
my spyware and antivirus were causing my apr home programmer not to work,see if theres some sort of
conflict between software by trying it on another computer or laptop with less stuff on it.
Trending Topics
09-09-2006, 04:23 PM
#10
AudiWorld Super User
Join Date: Apr 2000
Posts: 3,849
Likes: 0
Received 0 Likes
on
0 Posts
I downloaded the xls file on my website and used that spreadsheet
file to import each of the csv files you linked to. The excel file and csv file are working fine for me.
When you downloaded the file, did the file name remain 4xECUx.xls ? And there are no other excel files open when you do the import? My other guess is that perhaps it's a macro security setting. Do you get a single prompt to enable macros when you open the 4xECUx file, or multiple prompts.
The program is failing when it tries to copy the data from your csv file to the first page in the spreadsheet. When I've run into this issue it been because of a naming problem, the 4xECUx file name being changed, or having multiple open speadsheet files.
Here's the step by step of what I do.
1. Open Excel
2. Open the 4xECUx file
3. Enable macros when prompted
4. Select Get ECUx Data
5. Use the file open box to find the ECUx csv file I want to import and select open.
6. It will present a prompt depending on whether or not data was found. (It sounds like you are getting this far).
If you're following these steps and it isn't working there's something outside of the program causing issues.
When you downloaded the file, did the file name remain 4xECUx.xls ? And there are no other excel files open when you do the import? My other guess is that perhaps it's a macro security setting. Do you get a single prompt to enable macros when you open the 4xECUx file, or multiple prompts.
The program is failing when it tries to copy the data from your csv file to the first page in the spreadsheet. When I've run into this issue it been because of a naming problem, the 4xECUx file name being changed, or having multiple open speadsheet files.
Here's the step by step of what I do.
1. Open Excel
2. Open the 4xECUx file
3. Enable macros when prompted
4. Select Get ECUx Data
5. Use the file open box to find the ECUx csv file I want to import and select open.
6. It will present a prompt depending on whether or not data was found. (It sounds like you are getting this far).
If you're following these steps and it isn't working there's something outside of the program causing issues.