• Skip to main content
  • Skip to header right navigation
  • Skip to site footer
Foster Solutions (FSI)

Foster Solutions (FSI)

The Solution is in the Process

  • Home
  • What We Do
  • Case Studies
    • Databases/Automation Case Studies
    • GIS/Market Research Case Studies
    • Local Government Case Studies
    • FSI – crosspollination – examples
  • Articles

Excel/VBA

You are here: Home / Archives for Articles / Excel/VBA

Filling the BI/Reporting Gap

February 19, 2021 by tech guys

There is, and I believe there always will be, a gap in what large Business Intelligence (BI) and reporting software systems can provide to serve the needs of business professionals. BI/Reporting software has come a long way since the 90s when I started down the BI/Reporting path. But despite the great advances, building a solution …

Read moreFilling the BI/Reporting Gap

Create TXT settings file for VBA apps

June 21, 2014 by tech guys

It’s very useful and easy to use a text file as a settings file for VBA applications. The below code is a function that will open a file called adm_settings.txt in the directory of the application file and loop through it to see if it can find the passed setting.  If it does, it will …

Read moreCreate TXT settings file for VBA apps

Excel Function to reduce Cell Formats

December 5, 2012 by tech guys

If you build large Excel workbooks, you may have come across a weird error suddenly when you edited your file.  You get an error that says “Too many different cell formats”.  This will happen particularly with a large file that you have copy and pasted a lot of information from external sources. The following vba …

Read moreExcel Function to reduce Cell Formats
  • Page 1
  • Page 2
  • Page 3
  • Next

Ready to get started?

Client Survey

Please take this survey if you are interested in a new or modified website. We will assess and get back with you as soon as possible.


Finding Solutions

We work with you to make things faster, easier and better.

  • Facebook
  • LinkedIn

Sites

  • Home
  • Blog
  • About
  • Features
  • Contact
  • Marketing

Features

  • Home
  • Blog
  • About
  • Features
  • Contact
  • Marketing

Support

  • Home
  • Blog
  • About
  • Features
  • Contact
  • Marketing

Copyright © 2025 · Foster Solutions (FSI) · All Rights Reserved

Back to top