Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-15-2014, 11:22 PM
BobBridges's Avatar
BobBridges BobBridges is offline Is there a way to delete the beginning part of an array so it doesn't overflow? Windows 7 64bit Is there a way to delete the beginning part of an array so it doesn't overflow? Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

I kinda thought that reading the file twice wouldn't hurt you. If it gets to be more than a few megs in size, then it may be time to try a more complex method.



By the way, about integers greater than 32K; I think you'll find — let me look it up just to be sure .... yes, the Integer data type is stored in two bytes of storage and can therefore go "from -32,768 to 32,767". But the Long data type uses a full word (four bytes) of storage and can hold values "from -2,147,483,648 to 2,147,483,647". And in Office 2010 there's even a LongLong type that doubles storage yet again (8 bytes, 64 bits) and holds "-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807". So you can probably hold more data in your arrays than you feared.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a way to delete the beginning part of an array so it doesn't overflow? Delete bookmark which doesn't have a name rarulkumar Word VBA 2 04-19-2013 03:19 AM
Control direction of resizing textarea on overflow noodle PowerPoint 0 03-31-2013 04:52 AM
Is there a way to delete the beginning part of an array so it doesn't overflow? Convert String Array to Integer Array from a User Input? tinfanide Excel Programming 4 12-26-2012 08:56 PM
Is there a way to delete the beginning part of an array so it doesn't overflow? Files beginning ~$ RobinW Word 1 06-28-2012 05:35 PM
Is there a way to delete the beginning part of an array so it doesn't overflow? Before the table but after beginning of doc? Jaymond Flurrie Word VBA 2 08-16-2011 06:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:36 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft