Search results for query: *

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?

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 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...

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...

I have recently upgraded from Win98 to Windows 2000 & the system seems to want US date formats (i.e. "mm/dd/yyy")even though my regional settings are set for UK (i.e. "dd/mm/yyy"). In other systems this can be fixed by editing the win.ini International settings but these...

Is there a way to change an ODBC link in excel without having to recreate the entire query?

I am trying to automate a page number reference in Word whereby I have a footer on each page along the lines of "Continued.......xx" where [/u]xx is the number of the next page. I think I need to use a formula such as 1+ "Page" number field but Word won't accept any...

Does anyone know how to create a running total in the data area of a pivot table? The table is taken from data in another sheet in the same workbook & using the summary field option I can only get #N/A errors