Foster Solutions (FSI)
The Solution is in the Process
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 …
As nice as Excel 2007 is, and much of Office 2007 in general, Microsoft made some annoying decisions with developer access in VBA. Charts are now Excel objects and their data are based on worksheets. This is pretty nice overall, but Microsoft does not allow access to the sheet data when pasted into Word or …
Charting is a totally different animal in Office 2007 from its previous 2003- versions. Charts are not MS Graph objects (by default) but Excel. Working with PowerPoint in VBA is never fun, because managing slides and the objects on the slides is limited, and can not be seen from the interface (like naming a slide …