By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,902 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

a2k - validating excel file before importing

P: n/a
If I need my Excel file to contain only 3 columns before I import it into
Excel using VBA, how could I check that this is so? Also another check that
I might like to perform is ensuring that a given column contains only
numbers.

ta
Martin
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Deano" <de*********@hotmail.com> wrote in message news:<41***********************@ptn-nntp-reader04.plus.net>...
If I need my Excel file to contain only 3 columns before I import it into
Excel using VBA, how could I check that this is so? Also another check that
I might like to perform is ensuring that a given column contains only
numbers.

ta
Martin

1. How about going to column 4 and checking for something other than
null?
2. contains only numbers... Umm... attach said xl file, query column
for IsNumeric(xlsColumn)=False?
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.