// Excel Archives - Handheld.ie



Creating Word Clouds

We were working on a dashboard for one of our customer and had investigated the use of http://www.wordle.net/ to generate word clouds for use in a dashboard. The site take a document and gives greater prominence to words that appear more often. In this sample we have used the last 4475 comment threads on our support forum to generate the above picture.

For a sales graphic it could be used to…

Excel / IE links not working

If you received this error after uninstalling Chrome (or Firefox) browser you may also need to change the HTM/HTML association in the registry.

1. Start, click Run, type Regedit in the Open box, and then click OK.
2. Browse to HKEY_CURRENT_USERSoftwareClasses.html
3. Right click the value for the .html key and select Modify…
4. Change the value from “ChromeHTML” to “htmlfile” (or from…

Date Difference in Excel

I have used datediff in access and vba but didnt not know that excel had the function DateDif which is very useful function in pay budgeting models.

See the link here for…

Creating Excel files from MS Access

This routine is used to create an inventory forecast, which displays a 52 week forecast based on Sales orders MRP forecast and scheduled PO’s.

Function OpenWritetoXLS_QCS(tmpFiletoOpen, tmpFirstWeek, tmpLastWeek)
Dim objXL As Object
Dim strWhat As String, boolXL As Boolean
Dim objWkb As Object
Dim objSht As Object
Dim rst As Recordset, tmpRange, tmpRangeCount, tmpGonePast, tmpPosition,…

Excel Limiting the number of characters

Following from the link on Access this one is for…

Repeating a cell value in Excel

This is a request I have had a number of times.. In excel you want to copy the value of the cell above your current position if your current position is blank

To start this macro click on a row 2 or lower with a value in the cell above, change the value of x in the macro to the number of lines you want ot repeat

Sub Macro1()

‘ change the value of x to the number of lines to fill
Dim I,…

Adding Data from an excel file to Access

I wrote this macro to populate an access database with the contents from a protected spreadsheet that was distributed to users in different countries. The Excel file was used for Sales Order Entry. I have removed sections for security purposes, however this should serve as a good starting point for you to start your own version.

The idea is to ensure that the data integrity before loading t…

Using Vlookup in Excel files

When using the Vlookup or HLookup functions in Excel you will sometimes have #N/A in the cell display as the value cannot be found.

The normal syntax a user would enter in B9 would be VLOOKUP(A9,$A$2:$C$4,2,FALSE) to lookup the value of A9 in the list A2:C4, because the item exists the function returns the value.

In cell B10 the part BD12 does not exist and you get the error #N/A, replace t…

Contact Information

Drop us a line or call and we'll discuss how we can help with your projects.

Waterford City Enterprise Centre
Waterford Business Park

  • 051 391338
  • info@handheld.ie

Posts Categories

Copyright Handheld.ie ©2014 . All Rights Reserved.