• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 223
  • Last Modified:

Macro help

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
zoomer003
Asked:
zoomer003
  • 2
1 Solution
 
SiddharthRoutCommented:
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
 
Michael FowlerSolutions ConsultantCommented:
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
 
zoomer003Author Commented:
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
 
zoomer003Author Commented:
fiXED IT THANKS THANKS THANKS!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now