Need help writing a macro to break a large topo into smaller grids

[guitarista72]

Hey, I'm Rob a newbie when it comes to macros. I've delved a little into VB back in high school but it doesn't help very much. OK the problem I have is that our company recently received a large TOPO map of a county and it's so HUGE none of our computers can open it without crashing. They say you need like 4GB min of RAM to open it... (nice goin guys). Anyways, i have the honor of chopping up this map into about 100 smaller grids. I'm trying to find out a way to write a macro that will do at least some of the tedious work:
1. Import the predisposed grid box onto the TOPO map.
2. Trim all the lines around it without effecting the topo inside the grid box.
3. Save the previously empty grid with the new TOPO inside of it.

If anyone has any sort of suggestions, it would be much appreciated and I can buy you lunch if you live anywhere near Pasadena, MD : ) Thanks!

[Jeff_M]

I was working on a project a few years ago to do just this. It was close to being complete and I honestly don't recall how far from a finished product it is. I DO know that it was my first large scale VBA project, so I'm sure there are a number of things that could/should be done differently.

Also, I wasn't much for commenting my code. Looking at it just now, for the first time in 2 years, I really wish I would've added a bit......

If you'd like to give it a try and utilize the code I'd be more than happy to send it to you. Just give me valid email address.

Jeff

[guitarista72]

guitarista72@yahoo.com is the email Thanks Jeff I'll give it a try. One more question, The grids i have were already pre made, so all I have to do is Paste to original coordinates on the TOPO, will it work as-is or if not what command can i use for that?

[Jeff_M]

The grid I create is based on the smallest xy in the drawing. It shouldn't be too difficult to modify to use your existing grid. I will say that while I wrote designed and coded this, I quit working on it for lack of time and motive. It was more of a learning tool at the time, so I cannot and will not give any support for it. In other words, use it and modify it as you see fit, and I'll be happy to try to answer any questions you may have, but please don't expect me to fix anything that isn't quite what you need....OK?

[guitarista72]

You mean no 24/7 round the clock tech support!? Maybe I'll call Geek Squad... Haha, thanks for the help.

[ntaylor]

Hey, I'm Rob a newbie when it comes to macros. I've delved a little into VB back in high school but it doesn't help very much. OK the problem I have is that our company recently received a large TOPO map of a county and it's so HUGE none of our computers can open it without crashing. They say you need like 4GB min of RAM to open it... (nice goin guys). Anyways, i have the honor of chopping up this map into about 100 smaller grids. I'm trying to find out a way to write a macro that will do at least some of the tedious work:
1. Import the predisposed grid box onto the TOPO map.
2. Trim all the lines around it without effecting the topo inside the grid box.
3. Save the previously empty grid with the new TOPO inside of it.

If anyone has any sort of suggestions, it would be much appreciated and I can buy you lunch if you live anywhere near Pasadena, MD : ) Thanks!

Have you got a access to Autodesk Map.

Regards - Nathan

[guitarista72]

Nope, I wish! It looks like that would make it alot easier...