fbpx

Sistema en excel para controlar vehículos (mantenimiento, combustible y choferes)

sistema en excel control de vehiculos

Sistema en excel para controlar vehículos (mantenimiento, combustible y choferes): Es una aplicación automatizada con macros que nos permite llevar el control y administración de vehículos en todo lo que respecta a mantenimientos, control de combustible y choferes. Este archivo es de aplicación práctica real, es decir actualmente trabajan con este pequeño sistema (Sector agrario), lo que nos permite comprobar su utilidad. El autor de este archivo lo compartió en el foro de AyudaExcel de forma desinteresada para que todos aquellos que  necesiten mejorarlo puedan hacerlo basándose en su código fuente el cual esta libre sin contraseñas, personalmente le realicé algunas modificaciones para que el archivo pueda ser utilizado evitando ciertas complicaciones. El nivel en el que esta programado es básico y puede servirle a muchos que recién están comenzando para entender la lógica de las macros, a continuación explico como utilizar este sistema desarrollado en excel.

¿CÓMO UTILIZAR ESTE ARCHIVO?

  1. Luego de descargar el archivo (esta al final del artículo), deben abrirlo y habilitar macros.
  2. Lo primero que nos mostrará el archivo es el menú principal.Menu principal sistema control de vehiculos
  3. El botón “Ingreso Vehículo” se utiliza para crear dos hojas de forma automática, una es para controlar los datos de cada carga de combustible y la otra hoja para los datos del mantenimiento vehicular, obviamente estas hojas no la verá directamente pero se utilizarán para cuando usemos los otros botones.creacion de kardex vehicular
  4. El botón “Choferes” sirve para registrar toda la información personal de los conductores, al hacer clic en dicho botón nos aparecerá la opción de registrar un nuevo chofer o eliminar alguno, para este caso utilizaremos la primera opción.control de vehiculos registro de choferes
  5. El botón “Mantenimiento” se utiliza para registrar todo lo que se catalogue en esa categoría (tipo de gasto), al aparecer la ventana debemos elegir de la lista el vehículo al cual le vamos a registrar el gasto por mantenimiento.mantenimiento de vehiculos excel
  6. El botón “Combustible” se utiliza para registrar información referente al llenado de combustible, datos del chofer, datos del vehículo. Recuerden siempre elegir de la lista el vehículo a cual le van asignar información.control de combustible sistema excel
  7. El botón “Reportes” lo utilizamos si queremos imprimir en PDF la información registrada.sistema en excel control de vehiculos
  8. El botón “Base de datos” nos permite revisar cierta información que el sistema ha tomado en cuenta para por ejemplo la creación de hojas, asignación de conceptos para el rubro de mantenimiento etc. Si desea eliminar las hojas creadas tendría que eliminar también la información registrada en la hoja base de datos..

DESCARGA EL ARCHIVO

Descargar Sistema en Excel para control de combustible y mantenimiento de vehículos – Actualizado 19 mayo 2017.xls

Luego de muchas preguntas, he corregido los errores que tenía el archivo, esta actualizado al 19/05/2017

Fuente: AyudaExcel

¿Te sale error al usar el archivo?

HE DESCARGADO EL ARCHIVO PERO NO ME FUNCIONA. <<LEE AQUÍ>>

Si al tratar de usar el archivo te sale el mensaje “No se puede encontrar el proyecto o biblioteca” o en inglés “Can’t find project or library” entonces debes seguir los siguientes pasos.

  1. Con el archivo abierto y luego de cerrar la ventana con el mensaje de error, presionamos la tecla ALT + F11 para acceder al editor de visual basic.Acceder a editor de visual basic
  2. Clic en el menú herramientas, luego en referencias:referencia editor visual basic
  3. Se abrirá una ventana, dependiendo del idioma en que lo tengas vamos a quitarle el check a la referencia que diga “FALTA” o “MISSING”, ya que al no tenerlo disponible en tu pc crea un conflicto razón por la cual el archivo no funciona. Luego presionamos aceptar y regresamos a excel.Falta referencia vba excel espanol

Falta referencia vba excel ingles

Luego de haber hecho todo estos pasos, el archivo debe funcionar sin problemas, en caso tengas algún otro inconveniente favor de dejarlo en un comentario para ayudarte.

REVISA ESTOS TEMAS SIMILARES


Suscríbete es gratis

Ingresa tu correo electrónico y te convertiré en un experto en Excel.

Agrega tu comentario

Comentarios
  1. Posted by Henry Pereira
  2. Posted by CHEMBERS
  3. Posted by rob28
    • Posted by Gustavo A. Sebastiani Cépeda
  4. Posted by Willy
  5. Posted by Jhosue
    • Posted by Gustavo A. Sebastiani Cépeda
  6. Posted by Pablo Herrera
  7. Posted by erwin vargas
  8. Posted by MARTIN VERGARA GONZALEZ
    • Posted by Sara
    • Posted by jorge
    • Posted by Omar
  9. Posted by jUAN
  10. Posted by claudio godinez
    • Posted by Diana
  11. Posted by Newman Quintero S.
  12. Posted by moises Ccamercoa
  13. Posted by Abraham Rojas
  14. Posted by Cristina
    • Posted by Gustavo A. Sebastiani Cépeda
  15. Posted by leonel hernandez moreno
  16. Posted by traf
  17. Posted by Francisco Ramirez
  18. Posted by Edgard
  19. Posted by fernando
  20. Posted by Rudy
  21. Posted by DESYI
    • Posted by Gustavo A. Sebastiani Cépeda
  22. Posted by daniel
    • Posted by Gustavo A. Sebastiani Cépeda
  23. Posted by JOB
  24. Posted by SST
    • Posted by Robin Solano
  25. Posted by Estudiante español
    • Posted by Gustavo A. Sebastiani Cépeda
  26. Posted by junior
    • Posted by Gustavo A. Sebastiani Cépeda
  27. Posted by juan ortiz
    • Posted by Gustavo A. Sebastiani Cépeda
  28. Posted by Herberth Lima
  29. Posted by HECTR
    • Posted by Gustavo A. Sebastiani Cépeda
  30. Posted by Diego Fresia
    • Posted by Gustavo A. Sebastiani Cépeda
  31. Posted by JosueM
    • Posted by Gustavo A. Sebastiani Cépeda
  32. Posted by Gerson Niño
  33. Posted by Fidel Santa Cruz Huanca
  34. Posted by Henry
  35. Posted by BRENDA VILLALOBOS
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by MARTIN VERGARA GONZALEZ
  36. Posted by Donald
    • Posted by Gustavo A. Sebastiani Cépeda
  37. Posted by Erica quispe
    • Posted by Gustavo A. Sebastiani Cépeda
  38. Posted by Ronny
    • Posted by Gustavo A. Sebastiani Cépeda
  39. Posted by José Luis
    • Posted by Gustavo A. Sebastiani Cépeda
  40. Posted by William José Cerda Meza
  41. Posted by William José Cerda Meza
    • Posted by William José Cerda Meza
  42. Posted by William José Cerda Meza
  43. Posted by Pablo
    • Posted by Gustavo A. Sebastiani Cépeda
  44. Posted by Juan Fernandez
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Felipe
  45. Posted by Javier
  46. Posted by Lau
    • Posted by Robin Solano
      • Posted by HENRY
  47. Posted by ALCIDES MEJIA
  48. Posted by marcos
  49. Posted by Victor Macario
  50. Posted by Huascal Mena
    • Posted by Robin Solano
  51. Posted by Jorge Angulo
    • Posted by Robin Solano
  52. Posted by milton
    • Posted by Robin Solano
  53. Posted by Nicolas TSG SRL
  54. Posted by MADELEINE YABE
  55. Posted by Alexis Tapia
    • Posted by Jinette
  56. Posted by Andres Felipe
  57. Posted by Erika
  58. Posted by Francis Miranda
  59. Posted by Alffredo Acosta Ramos
    • Posted by Robin Solano
  60. Posted by John Arboleda
    • Posted by Gustavo A. Sebastiani Cépeda
  61. Posted by ESTEBAN
  62. Posted by ZENON ELISBAN HALANOCA MAMANI
    • Posted by Gustavo A. Sebastiani Cépeda
  63. Posted by CARLOS
    • Posted by Gustavo A. Sebastiani Cépeda
  64. Posted by cuate
  65. Posted by JESUS
    • Posted by Robin Solano
  66. Posted by Jose Pineda
  67. Posted by JOHNNY
    • Posted by Robin Solano
  68. Posted by nelson roque
    • Posted by Robin Solano
  69. Posted by HORACIO MELGAREJO
  70. Posted by sergio carmiglia
    • Posted by Gustavo A. Sebastiani Cépeda
  71. Posted by sergio carmiglia
  72. Posted by andres vaca herrera
    • Posted by Gustavo A. Sebastiani Cépeda
  73. Posted by Eduardo Díaz León
    • Posted by Robin Solano
  74. Posted by Carlos Alzate
    • Posted by Robin Solano
  75. Posted by luis rodriguez
    • Posted by Robin Solano
  76. Posted by Daniel Hernandez
    • Posted by Robin Solano
      • Posted by Daniel Hernandez
  77. Posted by Rucrych
    • Posted by Robin Solano
  78. Posted by marcelo arroyo
    • Posted by Robin Solano
  79. Posted by Pablo Gil Gallo
  80. Posted by Nancy Valdez
  81. Posted by JOSE MANUEL
    • Posted by Gustavo A. Sebastiani Cépeda
  82. Posted by Yessica Mendoza
    • Posted by Gustavo A. Sebastiani Cépeda
  83. Posted by Jahira S.
    • Posted by Robin Solano
  84. Posted by Antonio Hernández
    • Posted by Gustavo A. Sebastiani Cépeda
  85. Posted by Carlos
    • Posted by Robin Solano
  86. Posted by Ivan Nuñez
    • Posted by Robin Solano
  87. Posted by MIGUEL RAMOS
    • Posted by Robin Solano
  88. Posted by Eduardo
    • Posted by Gustavo A. Sebastiani Cépeda
  89. Posted by Nataly
    • Posted by Robin Solano
  90. Posted by Jesus
    • Posted by Robin Solano
  91. Posted by Ruben Velasquez
    • Posted by Robin Solano
  92. Posted by Marcelo
    • Posted by Robin Solano
  93. Posted by FRANCISCO JAVIER
    • Posted by Gustavo A. Sebastiani Cépeda
  94. Posted by EDGAR
    • Posted by Gustavo A. Sebastiani Cépeda
  95. Posted by oscar
    • Posted by Gustavo A. Sebastiani Cépeda
  96. Posted by tati
    • Posted by Gustavo A. Sebastiani Cépeda
  97. Posted by carlos mi
    • Posted by Gustavo A. Sebastiani Cépeda
  98. Posted by luis guillermo segura muro
    • Posted by Gustavo A. Sebastiani Cépeda
  99. Posted by AMERICA
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Elí Vega
        • Posted by Elí Vega
  100. Posted by HUGO
    • Posted by Gustavo A. Sebastiani Cépeda
  101. Posted by jhon
    • Posted by Gustavo A. Sebastiani Cépeda
  102. Posted by PEDRO CANTU
    • Posted by Gustavo A. Sebastiani Cépeda
  103. Posted by MYNOR
    • Posted by Gustavo A. Sebastiani Cépeda
  104. Posted by PEDRO CANTU
    • Posted by Gustavo A. Sebastiani Cépeda
  105. Posted by aleida
    • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by aleida
  106. Posted by German
    • Posted by Gustavo A. Sebastiani Cépeda
  107. Posted by JOSE CARLOS
  108. Posted by OMAR
    • Posted by Gustavo A. Sebastiani Cépeda
  109. Posted by josue
    • Posted by Gustavo A. Sebastiani Cépeda
  110. Posted by Luis
    • Posted by Gustavo A. Sebastiani Cépeda
  111. Posted by PEPE
    • Posted by Gustavo A. Sebastiani Cépeda
  112. Posted by julio césar
    • Posted by Gustavo A. Sebastiani Cépeda
  113. Posted by Miguel
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Alexa
        • Posted by Gustavo A. Sebastiani Cépeda
  114. Posted by JOSE
    • Posted by Gustavo A. Sebastiani Cépeda
  115. Posted by Sebastian
    • Posted by Gustavo A. Sebastiani Cépeda
  116. Posted by Carlos
    • Posted by Gustavo A. Sebastiani Cépeda
  117. Posted by kimy
    • Posted by Gustavo A. Sebastiani Cépeda
  118. Posted by alexander
    • Posted by Gustavo A. Sebastiani Cépeda
  119. Posted by JOSE ANDRES MORENO NOVOA
    • Posted by Gustavo A. Sebastiani Cépeda
  120. Posted by JOSE ANDRES MORENO NOVOA
    • Posted by Gustavo A. Sebastiani Cépeda
  121. Posted by Miguel Ramirez
    • Posted by Gustavo A. Sebastiani Cépeda
  122. Posted by mauro
    • Posted by Gustavo A. Sebastiani Cépeda
  123. Posted by DIEGO
  124. Posted by DIEGO
    • Posted by Gustavo A. Sebastiani Cépeda
  125. Posted by daniela
    • Posted by Gustavo A. Sebastiani Cépeda
  126. Posted by Hugo
    • Posted by Gustavo A. Sebastiani Cépeda
  127. Posted by MILAGROS
    • Posted by Gustavo A. Sebastiani Cépeda
  128. Posted by MILAGROS
    • Posted by Gustavo A. Sebastiani Cépeda
  129. Posted by carlom
  130. Posted by Julio Orjeda Vizcarra
  131. Posted by ERNESRO
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Yennifer Zapata
        • Posted by Gustavo A. Sebastiani Cépeda
  132. Posted by elvira leyva
    • Posted by Gustavo A. Sebastiani Cépeda
  133. Posted by JAVIER
    • Posted by Gustavo A. Sebastiani Cépeda
  134. Posted by jorge mendez
    • Posted by Gustavo A. Sebastiani Cépeda
  135. Posted by raquel nava
    • Posted by Gustavo A. Sebastiani Cépeda
  136. Posted by HADYSON
    • Posted by Gustavo A. Sebastiani Cépeda
  137. Posted by Javier Garrido
    • Posted by Gustavo A. Sebastiani Cépeda
  138. Posted by CARLOS DANIEL
    • Posted by Gustavo A. Sebastiani Cépeda
  139. Posted by RAUL ANTONIO LOPEZ PEREZ
    • Posted by Gustavo A. Sebastiani Cépeda
  140. Posted by RAUL MEDRANO
    • Posted by Gustavo A. Sebastiani Cépeda
  141. Posted by Marcelo
    • Posted by Gustavo A. Sebastiani Cépeda
  142. Posted by PAULET
    • Posted by Gustavo A. Sebastiani Cépeda
  143. Posted by Jaiver
    • Posted by Gustavo A. Sebastiani Cépeda
  144. Posted by Gustavo Rodriguez
  145. Posted by Fernanda Garcia
    • Posted by Gustavo A. Sebastiani Cépeda
  146. Posted by ESTEBAN COPA
    • Posted by Gustavo A. Sebastiani Cépeda
  147. Posted by Gonzalo
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Kathy
        • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Fernanda Garcia
        • Posted by Gustavo A. Sebastiani Cépeda
  148. Posted by Juan Avalos
  149. Posted by Juan jose
    • Posted by Gustavo A. Sebastiani Cépeda
  150. Posted by JOHANNA REYES
    • Posted by Gustavo A. Sebastiani Cépeda
  151. Posted by Johnny Arrieta
  152. Posted by Juan reyna
    • Posted by Gustavo A. Sebastiani Cépeda
  153. Posted by Emmanuel
    • Posted by Gustavo A. Sebastiani Cépeda
  154. Posted by alejandro
  155. Posted by rodolfo
    • Posted by Gustavo A. Sebastiani Cépeda
  156. Posted by LUIS CARLOS
  157. Posted by Christian Castro Gómez
  158. Posted by ANA ONTIVEROS
  159. Posted by ANA ONTIVEROS
  160. Posted by Josue Herrera
  161. Posted by Omar horacio herrera
    • Posted by Gustavo A. Sebastiani Cépeda
  162. Posted by elvira
  163. Posted by elvira
  164. Posted by Ernesto del Carmen
    • Posted by Gustavo A. Sebastiani Cépeda
  165. Posted by Alejandra
    • Posted by Gustavo A. Sebastiani Cépeda
  166. Posted by Hasslon Calizaya Pinto
    • Posted by Gustavo A. Sebastiani Cépeda
  167. Posted by Jonathan Fernández
    • Posted by Gustavo A. Sebastiani Cépeda
  168. Posted by control de vehiculos
    • Posted by Gustavo A. Sebastiani Cépeda
  169. Posted by sebastian
    • Posted by Gustavo A. Sebastiani Cépeda
  170. Posted by Andrea
    • Posted by Gustavo A. Sebastiani Cépeda
  171. Posted by Jaime
    • Posted by Gustavo A. Sebastiani Cépeda
  172. Posted by greyssee
    • Posted by Gustavo A. Sebastiani Cépeda
  173. Posted by lennys cañas
  174. Posted by alberto escobar
    • Posted by alberto escobar
      • Posted by Gustavo A. Sebastiani Cépeda
        • Posted by uriel ledezma
  175. Posted by Cristina
    • Posted by Gustavo A. Sebastiani Cépeda
  176. Posted by diego
    • Posted by Gustavo A. Sebastiani Cépeda
  177. Posted by Cristhian
    • Posted by Gustavo A. Sebastiani Cépeda
  178. Posted by Cristhian rojas
    • Posted by Gustavo A. Sebastiani Cépeda
  179. Posted by Daniel
  180. Posted by Carlos Ugarte
    • Posted by Gustavo A. Sebastiani Cépeda
  181. Posted by Arturo Arellano Matos
    • Posted by Gustavo A. Sebastiani Cépeda
  182. Posted by Ricardo
    • Posted by Gustavo A. Sebastiani Cépeda
  183. Posted by HECTOR
    • Posted by Gustavo A. Sebastiani Cépeda
  184. Posted by Faustino Huanca
    • Posted by Gustavo A. Sebastiani Cépeda
  185. Posted by Joanna Alonso Espinosa
    • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by lázaro
  186. Posted by santiago
    • Posted by Gustavo A. Sebastiani Cépeda
  187. Posted by Alejandro
    • Posted by Gustavo A. Sebastiani Cépeda
  188. Posted by paula
    • Posted by Gustavo A. Sebastiani Cépeda
  189. Posted by Juan Carlos Angel
    • Posted by Gustavo A. Sebastiani Cépeda
  190. Posted by Alexander Cid
    • Posted by Gustavo A. Sebastiani Cépeda
  191. Posted by jesus
    • Posted by Gustavo A. Sebastiani Cépeda
  192. Posted by eDUARDO
    • Posted by Gustavo A. Sebastiani Cépeda
  193. Posted by Marco Abraham Serafin
    • Posted by Gustavo A. Sebastiani Cépeda
  194. Posted by Samuel Mejía
    • Posted by Gustavo A. Sebastiani Cépeda
  195. Posted by Juan
    • Posted by Gustavo A. Sebastiani Cépeda
  196. Posted by Magaly Gonzalez López
    • Posted by Gustavo A. Sebastiani Cépeda
  197. Posted by martin v
    • Posted by Gustavo A. Sebastiani Cépeda
  198. Posted by Francisco Pinto
    • Posted by Gustavo A. Sebastiani Cépeda
  199. Posted by jorge
    • Posted by Gustavo A. Sebastiani Cépeda
  200. Posted by Rodriguez
    • Posted by Gustavo A. Sebastiani Cépeda
  201. Posted by Maribeel
    • Posted by Gustavo A. Sebastiani Cépeda
  202. Posted by Nelson
    • Posted by Gustavo A. Sebastiani Cépeda
  203. Posted by sebastian
    • Posted by Gustavo A. Sebastiani Cépeda
  204. Posted by MIGUEL
    • Posted by Gustavo A. Sebastiani Cépeda
  205. Posted by leonela
    • Posted by Gustavo A. Sebastiani Cépeda
  206. Posted by Nancy
    • Posted by Gustavo A. Sebastiani Cépeda
  207. Posted by Solange
    • Posted by Gustavo A. Sebastiani Cépeda
  208. Posted by rommel saravia
  209. Posted by Isidro González
    • Posted by Gustavo A. Sebastiani Cépeda
  210. Posted by Martin
    • Posted by Gustavo A. Sebastiani Cépeda
  211. Posted by Sergio Ricaurte
  212. Posted by OMAR ORTIZ
  213. Posted by wilder
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by ADA
  214. Posted by astrid lazaro
  215. Posted by LUIS SANANGO
    • Posted by Gustavo A. Sebastiani Cépeda
  216. Posted by MANUEL REYES
  217. Posted by EDUARDO
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by astrid lazaro
        • Posted by Gustavo A. Sebastiani Cépeda
  218. Posted by Leonardo
    • Posted by Gustavo A. Sebastiani Cépeda
  219. Posted by Leonardo
    • Posted by Gustavo A. Sebastiani Cépeda
  220. Posted by jean
    • Posted by Gustavo A. Sebastiani Cépeda
  221. Posted by Felclin Rojas
    • Posted by Gustavo A. Sebastiani Cépeda
  222. Posted by WILSON GARCIA
    • Posted by Gustavo A. Sebastiani Cépeda
  223. Posted by Cristian
    • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by marco agreda matias
      • Posted by Gustavo A. Sebastiani Cépeda
  224. Posted by Liz
    • Posted by Gustavo A. Sebastiani Cépeda
  225. Posted by Liz
  226. Posted by Liz
    • Posted by Gustavo A. Sebastiani Cépeda
  227. Posted by Hector Jairo
  228. Posted by Gerrard
    • Posted by Gustavo A. Sebastiani Cépeda
  229. Posted by Gerrard
  230. Posted by José A Yunes S.
    • Posted by Gustavo A. Sebastiani Cépeda
  231. Posted by miguel
    • Posted by Gustavo A. Sebastiani Cépeda
  232. Posted by Jesus
    • Posted by Gustavo A. Sebastiani Cépeda
  233. Posted by Reynaldo Rosales
    • Posted by Gustavo A. Sebastiani Cépeda
  234. Posted by miguel pinto
    • Posted by Gustavo A. Sebastiani Cépeda
  235. Posted by Jose Antonio Yuners S
    • Posted by Gustavo A. Sebastiani Cépeda
  236. Posted by juan jose
    • Posted by Gustavo A. Sebastiani Cépeda
  237. Posted by Fabián Alarcón Estrada
  238. Posted by Gustavo A. Sebastiani Cépeda
    • Posted by José A Yunes S.
      • Posted by Gustavo A. Sebastiani Cépeda
        • Posted by sebastian
          • Posted by Gustavo A. Sebastiani Cépeda
  239. Posted by Jesus
  240. Posted by chiper
  241. Posted by Ivo Rivero
  242. Posted by Cristian
  243. Posted by miguel-venezuela
  244. Posted by miguel
  245. Posted by Cristian
  246. Posted by Denisse Pingo
    • Posted by Gustavo A. Sebastiani Cépeda