Tag Archives: Data types

A problem with integers in VBA

Posted on 01/10/2019 by dougaj4

A recent question at Quora asked: “Why am I getting an overflow error in Excel VBA when doing a simple arithmetic calculation like str1 = 24*60*30 where str1 is a variant or long or double?” I hadn’t encountered that problem … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , | Leave a comment

Importing Text Files; Unix Format

Posted on 10/11/2015 by dougaj4

Text files generated on Unix systems have a different convention to denote the ends of lines to that used on Dos/Windows systems (see Newline for more details).  This was causing problems with the Text-in2 spreadsheet, with small files being imported with … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , , , , , | Leave a comment

Dealing with dates 2: Getting cell data type and format code

Posted on 08/06/2015 by dougaj4

When working with imported data, or data from an opened csv file, it is often important to know the data type that has been used to store the data.  This may not be obvious, for instance in the previous post we … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , , , , | 6 Comments

Transfer of arrays to/from Python with Pyxll – Part1; Data Types

Posted on 16/03/2014 by dougaj4

This post will look at options for transferring arrays between Excel and Python using Pyxll, including data types, and problems associated with transferring mixed data types.  In the following post I will look at the relative performance of the various … Continue reading →

Posted in Arrays, Excel, Link to Python, VBA | Tagged , , , , | 2 Comments