[MS_AccessPros] Copying values from Excel - rounding errors

 

In my Access 2007 application I use VBA to open two Excel workbooks and copy values between them.

In the source sheet, the cells are formatted as currency with 2 decimal points, but the underlying values are obviously more than 2 dec places.

However, in the destintion sheet, it is only copying the 'displayed' values, ie 2 dec places.

The code I use is:
xlDestSheet.Cells(intRow, strTrips).Value = xlSourceSheet.Cells(intRowCounter, 10).Value
What am I doing wrong?

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 9
• New Files 6

Visit Your Group

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___