history

Thanks for being part of the MrExcel community. The site was launched on the Saturday before US Thanksgiving in 1998 - 15 years ago. Since then, MrExcel.com has published 42 books, 1800 videos, 700K message board threads and more. To thank the message board community for generating 700K+...

Good afternoon, I'm working on a project now that involves setting up a service desk that will be responsible for tracking and guiding individuals through a certain process. It is going to be a specialized desk that only deals with a few dozen items a year, so it doesn't make sense to use a...

Hello, Basically I have a list of zipcodes and I would like to create a webquery which will pull back the average temperature, rainfall, snowfall for a week (last week or other historical weeks). I found a website which has this info: http://www.wunderground.com/history/ and I can put in a...

Hi everyone I need to remove a a faulty drop down validation from a Excel 2003 sheet which has track changes activated (i.e. is shared). The usual way, turning off the shared workbook settings, doesn't work, because I need to keep my change history. Is there another way I can do this, maybe...

I'm not really sure where to post this because it's more of a powerpoint question than excel... but hopefully someone can help! I have this code for a web browser style back button in excel: Option Explicit Dim History As New Collection Private Sub Workbook_SheetActivate(ByVal Sh As Object)...

Hi, I am working on a spreadsheet where I wish to have a column B where each cell shows the date on which the cell in the corresponding row of column A is manually updated by me. In other words, <table style="border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="484"...

I've been working on a shared file where I occasionally need to turn off sharing, but I don't want to lose the history log (produced by "Track Changes." I thought I had a "SaveHistoryLog" macro working fine, but then it seems to work sometimes and other times give different run-time errors...

Hi, I want to write a macro which will open a file open dialogue box, with the default address of the last previously opened file which is not an excel file. Does anyone have any idea if this is even possible using vba in excel? :confused: I assume I'd need to be able to read in the Windows...