Samdreamth Profile

Latest Blog Posts

• 2-Years Birthday & Blog Renewal
  on May 10, 2013 in Comments
  Blog’s 2-years birthday Yesterday the blog that you are currently reading accomplished two years of web existence! To tell you the truth, when I started this blog I couldn’t imagine that it will be alive after 2 years. I still remember the first...
• Suggested Books
  on May 8, 2013 in Useful Stuff
  Introduction A week ago a blog reader (Hakim) asked my opinion about books for learning Excel and VBA. After suggesting him some books, I had the idea of writing this post in order to get together all the books that I would like to recommend to any...
• Open PDF File With VBA
  on Apr 29, 2013 in Office Tips
  Judging from the blog stats, the subject of opening PDF files using VBA code is really popular. Having a discussion with a blog reader (Jean-Sébastien) in the comments of my previous post VBA Macro To Open A PDF File, I thought that I should try to...
• Open A PDF File With VBA
  on Apr 29, 2013 in Office Tips
  Judging from the blog stats, the subject of opening PDF files using VBA code is really popular. Having a discussion with a blog reader (Jean-Sébastien) in the comments of my previous post VBA Macro To Open A PDF File, I thought that I should try to...
• Save Web Pages As PDF Files
  on Apr 26, 2013 in Office Tips
  Introduction Sometimes a task that you consider as “simple” tends to be so demanding that at the end you blame yourself for your initial assumption. The previous sentence describes exactly what happened to me the previous days. Around 10 days ag...
• Export Excel Ranges As Power Point Tables
  on Apr 13, 2013 in Office Tips
  Some months ago I published a VBA code for exporting all Excel charts to a new Power Point presentation. Having read that post, a blog reader (Hari) asked me if is possible to transfer Excel data to Power Point. I sent him a code that I wrote on the...
• Draw A Polyline In AutoCAD Using Excel VBA
  on Apr 5, 2013 in Useful Stuff
  A friend of mine, who is surveying engineer, asked me recently if it is possible to draw a polyline in AutoCAD using coordinates from an Excel file. He had a large Excel file with points coordinates (x, y) and he wanted to connect them through a poly...
• VBA Macro To Convert PDF Files Into Different Format
  on Mar 29, 2013 in Office Tips
  A couple of days ago, Peter asked me on this post if it is possible to save a PDF file as an Excel table by using VBA. I started thinking his question and I thought that it could be quite useful if I can automate the procedure of saving a PDF file in...
• Daily Schedule Charts
  on Mar 22, 2013 in Useful Stuff
  Figure. 1: "Schedule 2" chart. It is always useful to organize your daily tasks, especially on days that you have a lot of things to do. During the previous week I noticed that there are some days that I have a really heavy schedule, so I tried...
• External Workbook References (Add-In)
  on Mar 13, 2013 in Freeware Tools
  Problem There are a lot of people that using external workbook references during their daily work. A sales manager for example could summarize the annual sales of a department by summing 12 monthly reports that are stored in 12 different workbooks.
• Vapor Pressure Calculation
  on Mar 7, 2013 in Freeware Tools
  As the title implies this freeware tool was created in order to help you calculate the vapor pressure of a component based on its known temperature. The calculation is based on Antoine’s equation, which is a vapor pressure equation and describes th...
• COPERT Micro: A Tool To Calculate The Vehicle Emissions In Urban Areas
  on Feb 28, 2013 in Articles
  This is somehow a special post: from Sunday till previous Tuesday I was in Brussels in order to participate at CONCAWE’s 10th Symposium. A special feature of this event was the "Young Researcher" poster competition.  The call for abstracts was...
• Search Your VBA Code (Excel Add-In)
  on Feb 22, 2013 in Freeware Tools
  A couple of days ago, a blog reader (Harm) asked me if it is possible to search in all subs/functions/forms of the VBA code to see if there is a particular string present. Although I had written in the past a code that loops through all the VBA code...
• Quick Back Up Of Your Files
  on Feb 14, 2013 in Freeware Tools
  All the freeware tools that are uploaded in this blog were developed for one main purpose: to make our daily routine easier. Probably one of the most common routine tasks that we have to cope with every day is the back up of our files. If your daily...
• Quick Motor Calculation For Various Applications
  on Jan 31, 2013 in Freeware Tools
  This workbook contains three short relationships that will help you find the motor power that is required for your application.  I have included the following applications: Pump motors Lift/elevator/crane motors Fan/compressor motors All th...
• Export A Large Access Table/Query To Excel
  on Jan 24, 2013 in Office Tips
  The previous days I had to update a large Access database. I had a large table – around 1.000.000 records/rows – that I had to export to an Excel workbook, perform some calculations/corrections and import the table back to the database. So, you m...
• Import & Export CSV Files
  on Jan 9, 2013 in Office Tips
  About 10 days ago a blog reader asked me to write a VBA code to manipulate a CSV file. His problem solved, but, unintentionally, he pushed me to complete an idea that I had some months ago: to write some VBA code for importing and exporting CSV files...
• Αιθαλομίχλη Και Καύση Ξύλων/Pellets Για Θέρμανση
  on Dec 29, 2012 in Ελληνικά Articles
  Πρόλογος Δύο ήταν οι λόγοι που με οδήγησαν να γράψω το παρόν άρθρο: α) οι παρατηρήσεις δύο φίλων μου που κατοικούν στην περιοχή της Άνω Πό...
• Measuring The Pipe Discharge In Laboratory
  on Dec 17, 2012 in Articles
  Introduction Some of the most common instruments for measuring the pipe discharge in laboratory conditions are Venturi, nozzle and orifice meters.  The Venturi meter is consisted of a rapidly converging section, which increases the flow veloci...
• Emissions Reduction In Conventional Gas Turbine Combustors
  on Dec 5, 2012 in Articles
  Introduction In general, the main parameters that control the pollutant emission concentrations in a conventional gas turbine combustor are the following: The temperature, the equivalence ratio and the residence time in the primary zone of the...

Post a Comment

Log in or Register to place a comment