Solved

Macro help

Posted on 2011-03-02
4
214 Views
Last Modified: 2012-05-11
Hey guys i jus need little more help... i actually want more data to be parsed .. i am sorry for makin you guys work extra .. sorry .. any help will be highly appreciated!


its jus when i try it, it says error overflow


Thanks
"svid", "period", "cno_mean", "cno_sigma", "clock drift", "clock offset", "phase lock", "rtc_frequency", "e_to_acq_ratio", "sync_agc_gain", "GPS_SIRF_STP Total", _
    "GPS_SIRF_STP Sets of data", "New max", "New min"

Open in new window

Shanghai-TM6-test.xls
0
Comment
Question by:zoomer003
  • 2
4 Comments
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35021179
I am not getting any errors when I use the above in Public Sub ParseData()

Which line are you getting the error on?

Sid
0
 
LVL 23

Accepted Solution

by:
Michael74 earned 500 total points
ID: 35021203
You just need to change the line

Private Sub WriteSummaryData(summarySheet As Worksheet, curTime As String, dataCol As Integer, destRow As Integer, data As Integer)

to

Private Sub WriteSummaryData(summarySheet As Worksheet, curTime As String, dataCol As Integer, destRow As Integer, data As Long)

the value being passed to data was too large to be held as an integer hense the overflow

I have attached a copy of the workbook with the change made

Michael

Shanghai-TM6-test.xls
0
 

Author Comment

by:zoomer003
ID: 35021238
perfect, jus one question .. it is not givin me any values for clock offset clock drift and phase lock? can you fix that please
0
 

Author Closing Comment

by:zoomer003
ID: 35021280
fiXED IT THANKS THANKS THANKS!
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question