Anyone can automate tasks in Excel if they know how to use Visual Basic for Applications. Excel has long been one of Microsoft's most popular software products, and for good reason: it allows everyday ...

I can't believe how difficult this seemingly simple task has turned out to be. I need to be able to get a date value stored in an Excel spreadsheet (say, C Temp\file.xls) in cell B28, and put that ...