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

new to programming in VB; help!!!!

P: 3
Hi all,

I am a total newbie to programming and this is my first posting on a forum, so forgive me if I break any unwritten etiquette about posting. To get to the point I've been using VBA for access to create a tool that will resolve an IP address range using a single network address and the network bit and also convert the results to Hex. I have been able to use the network address / bit to calculate the Subnet mask as well as using the hex function to convert the network address to hex (altough I have identified a bug with this but more of tht later); the problem I have is creating the code to run the comparison between the 0's and the 1's of the network address and subnet mask to derive the start and end ip addresses, I can do this in excel with vlookup, search and len functions but I am struggling trying to translate this to code, and therefore I am in need of any suggestions from more experienced programmers to help me along. Thanks for your assistance
Jun 13 '07 #1
Share this Question
Share on Google+
3 Replies


10K+
P: 13,264
Hi all,

I am a total newbie to programming and this is my first posting on a forum, so forgive me if I break any unwritten etiquette about posting. To get to the point I've been using VBA for access to create a tool that will resolve an IP address range using a single network address and the network bit and also convert the results to Hex. I have been able to use the network address / bit to calculate the Subnet mask as well as using the hex function to convert the network address to hex (altough I have identified a bug with this but more of tht later); the problem I have is creating the code to run the comparison between the 0's and the 1's of the network address and subnet mask to derive the start and end ip addresses, I can do this in excel with vlookup, search and len functions but I am struggling trying to translate this to code, and therefore I am in need of any suggestions from more experienced programmers to help me along. Thanks for your assistance
Well you post that in the wrong forum!
I've moved it to the access forum for now.
Jun 13 '07 #2

Expert
P: 97
If your address values are numbers, you can use the logical operators - And, Or, Xor etc.
To convert a string to a number use Val() or CDbl()
Jun 13 '07 #3

P: 3
Thanx for the tips. I will have a go and let you know how I get on.
Jun 15 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.