Tag Archives: VBA

Minor updates of TECHEDGE Time and Expense Excel reports

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

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)

Continue reading Update of TECHEDGE Time and Expense Excel reports

Quizzes on Plinky

Quiz

I would like to present you a new feature in mi blog site.

Quiz yourself

This will be a collection of quizzes to test your knowledge in IT.

Currently I have created only two tests to verify your knowledge of ABAP an JAVA. Stay tuned to get more quizzes.

Enjoy πŸ™‚

Take the quiz

For any suggestion or critics post a comment

Transfer Excel charts to Power Point presentations

So here is an add-in for MS Excel that enables automatic transfer of Excel charts into PowerPoint presentations based on the selected presentation template.

The main features of the add-in are:
– compatibility with Office 2003 and Office 2007 (in fact, there are 2 add-ins that function virtually in the same way);
– high flexibility in customization of PPoint presentation templates (you put rectangular shapes in the place where you want to see the respective chart from Excel and insert the number of the chart to be associated with);
– the ZOrder position of the rectangular shape will be assigned to the inserted chart shape;
– high general flexibility of the system (it allows transferring any charts from any Excel workbook to any presentation with rectangular shapes indicating the position of the charts to insert);
– charts on all the worksheets are transferred, not only on the active worksheet

Charts are inserted via a new blank workbook which means that only relevant data will be transferred to PowerPoint. This is especially necessary for Office 2003 since the inserted chart brings with it the whole Excel workbook which sometimes may be huge enough.

For Office 2007 this problem is irrelevant since Office 2007 does not allow embedding Excel charts with source data (it creates a link to the source data) into PowerPoint presentation.


The add-in was designed and rendered public by YellowRiver (www.yriver.it). You can find more in OUR PROJECTS chapter of the YellowRiver web-site.

Leave your comments on Plinky blog and on YellowRiver blog (yriverit.blogspot.com).

All the suggestions and ideas are greatly appreciated.

Gantt chart converter to PowerPoint

This is an MS Project file that contains the necessary macro to transfer the Gantt chart into a PowerPoint presentation.
As for the time being it is not in the format of a COM add-in since I had no Visual StudioΒ 2008 installed on my computer and Visual Studio 2005 does not support add-ins for MS Project yet. With VS2008 it will be possible and as soon as I get it I will convert the VBA code into a “normal” add-in.Now if you have a project designed in MS Project and you need to make a presentation of it (as I did) you can simply copy project tasks into the present file and click the CHOOSE LEVELS TO TRANSFER button on the Transfer2PPoint custom toolbar to choose the task levels to include.
The topmost task is currently excluded from the visualization.

This is a video presentation of the work of the macro:

More solutions, information and contacts on http://www.yriver.it/ (http://www.yriver.it/it/projects.php – a PROJECTS section).

Special thanks to Ivan for offering his blog space.

Download at:

http://www.plinky.it/vba/GanttChart2PPoint_1.0.0.zip

Zip password -> www.yriver.it