Building a macro and dataobject error

Designtpi · Jul 10, 2007

Hello all
I have a question on a task that has been assigned to me at work. First off my experience with Visual Basic is limited. I can record macros and understand the programing of the macro once it's recorded. BUT when it comes to writing my own code things get a little out there. Anyway since i am the most familiar with programing (I can whip up a mean Autolisp routine

) i was give the task of making a macro for a spreadsheet that we have. I started to work my way through with the help on visual basic and the wall that i came across was that what i call a variable in lisp would be something like a dataobject in Visual. But when i try the run the code in the module the line "dim x as dataobject" returns an error. (there is no dataobject in the dropdown box that pops up when you are typing. Do you need to load this function?) I surrendered

.The sheet consists of two sheet (the first page is the summery page w/ 30 or so rows with each row consisting of the vehicle #, 1 blank cell, one drop down list with weekly dates on it, then 2 cells that have the mileage of the vehicle and the date of the last maintenance on the rig. The Macro that im trying to build would first cycle through the column of blank cells checking to see if there is information in the cell. If there is information in the cell it would copy the information from the cell read the date that is entered in the drop down box search the second sheet for that date and enter the information in the correct cell. If someone would be able to take a look at it and give some pointers i would appreciate it. (also if someone would like to look at the actual sheets i can post them.)

Smitty · Jul 10, 2007

Welcome to the Board!

if someone would like to look at the actual sheets i can post them.)

Please, indicating what you have and what you want as a result. (See the link beneath my sig for how to post).

Smitty

Note for future posts: to try to break up your post so that it's readable. As it is it's really hard to read, let alone know what you want.

Designtpi · Jul 11, 2007

Alright I have been given the task of writing a macro to ease the use of entering the mileage on our vehicles. I am proficient at LISP based programing but haven't had to deal much with Visual. If some one could give me some pointers/help on where to start i would appreciate it. Thanks,

The macro would run in this order:
1. On the Summary Data Sheet it would search down B column to see if there is any information in any of the cells in that column.
2. If it does come across a cell with information in it, it would store that information, along with the date that is in the adjacent cell.
3. It would search for the date in row 2 on the Detailed Data Sheet and when it found the date it would enter the copied information from column B of the Summary Data Sheet in the corresponding cell for the vehicle #. (The row #'s for each Vehicle # on both sheets are the same).
4. The search would continue until all cells in B column on the Summary Data Sheet that have a Vehicle # in the cell adjacent to them have been searched.

Here's Summary Sheet:

Copy of Odometer Tracking.xls