Solved

Macro help

Posted on 2011-03-02
4
213 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

911 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now