Recent content by searlerm

You may have alreday solved this but I had the same problem with imported data. I deleted the offending column & inserted a newone; format it as "general" & then re-created the formulae - worked fine.

Hi I have the same problem but have not figured it out - pls can you shed some light for me? Thanks

Hi all I wonder whether anyone can help me with this one please... I am trying to call an external application from within Excel VB but am getting a "Compile error - Expected list separator or )" message. The command line is as below and I have simply prefixed it with "shell(". The command...

HI I am using an extended desktop/screen with my laptop & am running Crystal reports. When I go to open a dialogue box, it doesn't appear but is obviously open as I can't do anything else in Crystal unless I press the Esc. Button Can anyone help please?

Thanks guys I have actually now done a combination of month/date fields added to the query for one pivot table & grouping using Skip's formula for the others Thanks again for your help Richard

Hi Skip - yes it is as this appeared to get around the problem of having to set the source data range to exclude blanks. I have now set the query to return the data to a pivot table & to generate a pivot from there but it comes up with the same problems (plus the need to reset the source data...

Hi Guys - thanks for your replies. Unfortunately, neither of this seems to work for me. I have tried formatting the column, Field Settings/Number & even the cells but it keeps it as dd-mmm. However, when sorting on this field, it looks like it's treating this as text - e.g. 01-Dec, 01-Feb...

Hi I have a pivot table with invoices by date & product quantities on each invoice. The raw data comes from Access using date/time a fields. I have grouped the invoices into days, months & then years using the group facility but this now prevents me from formatting the invoices dates as...

Hi Geoff Thanks for the reply. The combo box I have used is created by the forms toolbar in Excel rather than through VB. I have tried to put a Private Sub as a Declaration in the worksheet in which the combo box appears as follows: selectedDate =...

Hi I am trying to setup an ODBC query where one of my source fields is "Date" and I want to be able to select a date range on which to filter the information at runtime - i.e. each time I run the query. How can I set this up so that I can enter the start & end dates of the range each time I...

I have a pivottable with "Date" as the page field and this feeds into a drop-down combo box on another sheet via a macro. I want to be able to change the currentpage value in the pivot table by selecting a different date from the combo box but can't seem to think of the macro required. Can...

Try these links. The first link works a treat on excel passwords themselves but I suspect you might need the second for the VB code. Don't leave it around the office though as it could be a bit dangerous!! http://www.lostpassword.com/excel.htm http://www.lostpassword.com/vba.htm

I am using a pivot table with Page items being dates of transactions and want to be able to use a Combo-Box on another sheet to select the required date. I have looked at Getpivotdata etc and various basic VB codes but am a bit lost. Can anyone advise please?

I am using fill-in fields in basic Word documents to allow the user to enter information in a dialogue box when a template is opened, so that Word places the entered text in the correct place. This is to create standard forms. When I open such documents, Word pops up the field entry boxes...

I have drafted a macro to create new sheets in a workbook which are named as per the user entry into a text box on a user form. This works fine but I also want to create a hyperlink "Contents" type table pointing to each sheet as part of the macro. I can do this using a line as...