 |
| Register | Login | |||||
 |
Main
| Memberlist
| Active users
| ACS
| Commons
| Calendar
| Online users Ranks | FAQ | Color Chart | Photo album | IRC Chat |
|
| | ||
|
| Register | Login | |||||
|
Main
| Memberlist
| Active users
| ACS
| Commons
| Calendar
| Online users Ranks | FAQ | Color Chart | Photo album | IRC Chat |
|
| | ||
| 0 user currently in Hardware/Software. |
| Acmlm's Board - I2 Archive - Hardware/Software - Excel help needed |
 |  |  |
| Add to favorites | "RSS" Feed | Next newer thread | Next older thread |
| User | Post | ||||||||
drjayphd Beamos What's that spell? pimp! Level: 56  Posts: 1195/1477 EXP: 1387410 For next: 10766 Since: 03-15-04 From: CT Since last post: 2 hours Last activity: 2 hours |
| ||||||||
| So I've got an Excel file that I use for work. It has damn near everything I'd need to know about a variety of schools, like their mascots, driving directions (Mapquest, Google, AND Yahoo), etc. Well, I'm gonna share this with the other papers in the company, and I want to know how to set it up so people can add directions to other sites themselves. Why's this a problem? Can't they just type it in? I'm counting on them not being as geeky as me. So it wouldn't occur to them to copy the row above, paste it in, and change what needs to be changed in the links to the driving directions. Here's a typical row.
The last two columns are time and distance. So. What I want to do is have it pop up a bunch of input boxes, asking for everything. Name of field/facility, street address, city (they're all in the same state), zip code. It'll fill in everything it can, formatted properly, except time and distance. That you've gotta do manually, unless someone can find a way to get that off the page (which I SORELY doubt is doable). |
|||||||||
neotransotaku Baby Mario 戻れたら、 誰も気が付く Level: 87 Posts: 3647/4016 EXP: 6220548 For next: 172226 Since: 03-15-04 From: Outside of Time/Space Since last post: 11 hours Last activity: 1 hour |
| ||||||||
| the use of VBScripts should allow you to make a form and do this. I always see things about using VB in Microsoft Office applications so from the looks of it you should be able to make a form and such. If Office VB is VB, then I know there is a way for you to read internet pages into Visual Basic and thus rip the numbers you want (since I believe all mapquest pages are uniformly produced). To attempt to play around with it, you go to Tools->Macros->Visual Basic Editor. I personally have never used it so this is as much help I can provide. But this should be a start for you. |
| Add to favorites | "RSS" Feed | Next newer thread | Next older thread |
| Acmlm's Board - I2 Archive - Hardware/Software - Excel help needed |
| | |
