Microsoft Excel Archives - Extra Mile Data

Use VBA to add days to a date but exclude Saturday and Sunday

This function finds a date a certain number of days from a start date when weekends are not included. It can be used when your work week does not include Saturday and Sunday and you want to find a business day in the future. Microsoft

posted on: Oct 8, 2013 | author: Carl Connett

Use VBA to copy MS Access PivotTable values to the clipboard

This function uses a combination of Microsoft Access, VBA, and Microsoft Excel to transfer the values from an Access form in PivotTable view to the clipboard. It is a good example of automation using late binding.

The Challenge

My goal was to automate the process …

posted on: Jul 7, 2009 | author: Carl Connett

Use VBA to return a column or row from a MS Excel range address

This VBA function returns the first row, last row, first column, or last column of a Microsoft Excel range address. It is also a good example of using a custom enumerated type.

A typical range address is a string that defines a rectangle of cells. …

posted on: Jul 7, 2009 | author: Carl Connett

Get the name and description of all MS Access database objects

This VBA procedure shows you how to create a simple list of the objects in a Microsoft Access database. The list it creates includes the object type, object name, and object description, which can be parsed using the Excel file in the download.

Descriptions can …

posted on: Apr 24, 2009 | author: Carl Connett

Rave Reviews

Working with databases can be daunting… but not when you work with Carl. Carl’s expert knowledge of MS Access and easy to follow pace and tutoring were extremely helpful. Although I was able to design and create most of my database, it was still missing some key functions and relationships. I left a message and Carl contacted me that same day. Carl took the time to work with me to understand our project and fix our problems. I will most definitely use Extra Mile Data for all my future database needs!!

Josie Molina, Executive Assistant to the President/HR Director
Ansh Labs LLC

Extra Mile Data

2018-10-02T16:20:48-05:00

Josie Molina, Executive Assistant to the President/HR Director
Ansh Labs LLC

https://extramiledata.com/testimonials/809/

I’ve worked with Extra Mile Data several times over the past few years, and they have provided 100% satisfaction, 100% of the time. They understood my needs and delivered outstanding results, on time, every time.

Danny Farley, SW Regional Sales Manager
Pure Fishing- TEXAS

Extra Mile Data

2018-10-02T16:21:12-05:00

Danny Farley, SW Regional Sales Manager
Pure Fishing- TEXAS

https://extramiledata.com/testimonials/810/

As is the case with most small businesses, finding the best person for key projects is oft times a disappointing venture. We took a chance on Carl and I’m very glad we did. His willingness to help, his wide knowledge base, his integrity and his cost structure has us coming back with new projects on a regular basis. I recommend him wholeheartedly.

Thomas E. Keegan, MSPH, Principal Managing Partner
Gemini Group

Extra Mile Data

2018-10-02T16:21:45-05:00

Thomas E. Keegan, MSPH, Principal Managing Partner
Gemini Group

https://extramiledata.com/testimonials/811/

We had tried several vendors to help take our Access based system to the next level. Deciding to bring Extra Mile Data in and help us attain the next level was probably one of the three best decisions our business made last year. I appreciate working with Carl and utilizing his vast experience to improve my business. Triple thumbs up!

Clay Murray
Spur Mercantile, LLC

Extra Mile Data

2018-10-02T16:22:11-05:00

Clay Murray
Spur Mercantile, LLC

https://extramiledata.com/testimonials/812/

I spoke with several different companies and I was not able to get the results I was looking for. Carl is in a league of his own. He is always on time for his appointments. He is meticulous, honest, easy to work with, and has been instrumental in taking my concept to reality. I recommend him to any and all who need his services.

Mark Goldstein
Production Link Software, LLC

Extra Mile Data

2018-10-02T16:22:44-05:00

Mark Goldstein
Production Link Software, LLC

https://extramiledata.com/testimonials/813/

5 Stars!!!! The problem with most techies is that they understand systems and processes, but not business. Carl is the rare exception who understands that technology is a means to an end, and not the end itself. He asked questions each step of the way to understand exactly what we were trying to accomplish, so that he could choose the best methods for achieving our desired outcome – instead of merely selecting what’s the most technically efficient.

Glenn Shepard
Glenn Shepard Seminars
Nashville, TN

Extra Mile Data

2019-03-08T10:09:11-06:00

Glenn Shepard
Glenn Shepard Seminars
Nashville, TN

https://extramiledata.com/testimonials/5-stars/

Carl and Extra Mile Data was the easiest and quickest way to solve my MS Access problems. Our database is running properly, efficiently and faster after Carl made the necessary changes to fit our needs. He also taught me how to make any updates in the future making me more confident with our database. Extra Mile Data is highly recommended!

Andrew H. Huffine
Ridge Funeral Home & Cremation Service, LLC.

Extra Mile Data

2018-10-02T16:17:07-05:00

Andrew H. Huffine
Ridge Funeral Home & Cremation Service, LLC.

https://extramiledata.com/testimonials/803/

Carl at Extra Mile Data has been extraordinarily helpful to our companies. He applied his vast knowledge and patience to match to solving all of our complex database needs that we were unable to handle ourselves. He and his company were a tremendous find and will be used again and again as needed.

Lynn Coleman-Kirk
Signature Companies

Extra Mile Data

2018-10-02T16:18:55-05:00

Lynn Coleman-Kirk
Signature Companies

https://extramiledata.com/testimonials/805/

I was looking for a database solution for my business and I'm glad I found Extra Mile Data. Carl was able to get me up and running with a database in no time at all and within budget. He has since helped me build this database into a very effective and efficient tool I use daily for my projects. I've very much enjoyed working with Carl and I will certainly continue to use him for any database programming in the future. 'Thanks Carl'

Normand Menard, RPFT C-Tech
Upland Environmental Ltd

Extra Mile Data

2018-10-02T16:19:26-05:00

Normand Menard, RPFT C-Tech
Upland Environmental Ltd

https://extramiledata.com/testimonials/806/

My project “MS Access Salesperson Database” was at a standstill and then I found Extra Mile Data. With the professional help given to me by Carl my project was completed on time and on budget. Carl not only explained the programming as he went along, but he also showed me how I could add coding as well to achieve my desired results (Truly an Extra Mile). The database is an integral part of the day to day operations for our sales force and their supervisor.

Jim Lipko, IT Administrator
The P.A. Hutchison Company

Extra Mile Data

2018-10-02T16:19:53-05:00

Jim Lipko, IT Administrator
The P.A. Hutchison Company

https://extramiledata.com/testimonials/807/

We hit a brick wall in the middle of our project, thankfully we found Extra Mile Data! Carl was great he took the time to understand our project, fix our problems, and help us with future Database endeavors.

William Green, Manger of IT/Marketing
Mascot Construction

Extra Mile Data

2018-10-02T16:20:23-05:00

William Green, Manger of IT/Marketing
Mascot Construction

https://extramiledata.com/testimonials/808/

Extra Mile Data

Use VBA to add days to a date but exclude Saturday and Sunday

Use VBA to copy MS Access PivotTable values to the clipboard

Use VBA to return a column or row from a MS Excel range address

Get the name and description of all MS Access database objects

Categories

Rave Reviews

Services

Services

Services