This blog post is about what I call a Business Model renovation which I call a workbook where the client won’t allow any major changes but I have to fix or add extra features. I took on this major job about two and a half years ago to do major alterations to a crucial, complex, […]
Business Model Renovation Read More »
If your application needs to print dynamic reports, then ideally to save tedious manual print setup, you need a re-usable print macro. If your application needs to print several dynamic reports it’s even better to have one versatile print routine that is passed the parameters it needs to do the job. One print macro is
Re-usable Print Macro Read More »
This post is about monitoring the workbook environment when working on key workbooks or workbook applications especially if they involve VBA, which is my approach to developing key workbooks for clients. You wouldn’t do this for an ad hoc or quick and dirty workbook. But for workbooks you or your clients are going to be
Monitoring the Workbook Environment Read More »
I had a small, interesting job involving exporting to PDF last week where the client had an .xlt template with existing in-house VBA to let the user save certifying documents within the an .xls file to a default folder plus “print to pdf” ie creating a pdf file and saving it to a user chosen