VBA

CBI (Customer to Business Interaction) Excel data export

0
2 years ago
by valerashylin in ,

Hi guys,

Recently we had an opportunity to develop an Excel add-in to carry out custom export of data regarding the employees salary payments into a CBI (Customer to Business Interaction) format. This is a standard for the text flat file data formatting implemented by banks for batch data loading. More information could be found on www.cbi-org.eu

(more…)

Techedge Time and Expenses report use instructions

0
2 years ago
by valerashylin in ,

Hi all,

here you can find a set of instructions on how to use the Time and Expenses Excel reports.

The Time Excel report can be found here:

http://www.plinky.it/blog/index.php/2009/01/27/techedge-timereport-in-excel-ii/

The Expenses Excel report can be found here:

http://www.plinky.it/blog/index.php/2009/02/01/techedge-expenses-report-in-excel/

(more…)

Minor updates of TECHEDGE Time and Expense Excel reports

0
2 years ago
by valerashylin in ,

Hi all,

today I made some minor updates to TECHEDGE Time and Expense Excel reports. Basically, Ivan found out that from our Techedge office the timereport on the URL .it does not work. So, I just inserted a timeout of 30 seconds. Therefore, if you run a function of loading data on the web or updating the projects list, after 30 seconds it will throw an error if the ie is still busy.

So, now thanks to Ivan we eliminated one more bug. :)

These Excel reports are available at:

ExpensesReport_Example.zip and

TimeReport_Example II.zip

Enjoy! :)

You might also want to see the previous post about the updates:

http://www.plinky.it/blog/index.php/2009/03/31/update-of-techedge-time-and-expense-excel-reports/

Best wishes,

Valera :)

Update of TECHEDGE Time and Expense Excel reports

1
2 years ago
by valerashylin in ,

Hi everybody,

today I’ve updated the time and expense Excel and reports for filling in the online reports automatically. Even though they are still in Beta version you can freely use them as I do for already a year. :)

The primary modifications are:

  • when opening any of these reports you will find a Techedge menu under which there will appear Time report or Expenses report submenus
  • Slightly improved error management (better don’t do any errors in filling in your reports, don’t forget fields, don’t put text in numeri fields; but if you do at least the application will not crush and you will probably be able to continue your work with it)

(more…)

Automate Excel charts building and moving to Power Point presentations

0
2 years ago
by valerashylin in ,

Hi,

Today we would like to present you yet another Excel add-in that we created for one our client. This is another implementation of the tool to build and transfer Excel charts into PowerPoint presentations.

The tool is quite universal so you could easily adapt yourself to use it.
The solution is quite simple and it uses at maximum the natural capabilities of Excel.

So, imagine you have a huge set of data which you have to analyse somehow, create charts on separate subsets of data and transfer them into PowerPoint presentations to then submit them to your clients. With this add-in you are actually supposed to have
- a table with data
- an area where you can insert row numbers
- an area that is filled dynamically with data by means of formulas and that takes a row number as an input
- sheet charts that have as data source the before mentioned area

(more…)

Go to Top