Search results for query: *

Please can someone help using Excel or Access I have a list of data ie; Name StartDate EndDate Type Program 1 14/12/2003 10:00:00 14/12/2003 11:15:00 A Program 2 14/12/2003 13:15:00 14/12/2003 13:30:00 B Then I have a list of transactions ie; Trans...

Probably really easy this one. I'm working on budgets.....(great).....I would like a User Form that floats above the sheet and displays key data eg Profit - but it is always visible while I'm off on an assumptions sheet making changes. Also it would need to be dynamic and constantly updated...

I have a table with a list of names in it. I then have a query that links by name and is used for a report. How do I write codes to link the query to the 1st person then output the report, then link to the second person and output the report...and so on.eg Table 1 ------- Mr X Mrs Y Mr Z I...

What code do I need to put around this to say if the file is already open then skip this command... Workbooks.Open Filename:="C:\Documents s\Desktop\Financial_Model.xls" Thanks. Thanks Jamie

Yes I can do it myself but just can't be bothered changing it each day..... Thanks Jamie

Is there a way that I can have program or code or something in my Startup folder so that when windows starts up it will change the background(and/or)screensaver to one of my choice... The thing is the IT department have nothing better to do than make it so everytime you log-on the wallpaper and...

Just to complicate things more..... I have a sheet with thousands of formulas on it that I would now like to add this indirect to each of them. For instance I have a formula ='[c:\windows\desktop\workbook1.xls]sheet1'!a1 if I try to use find & replace in two parts as follows; Find: '[c...

Say I have sheets 1,2 & 3. Then on Sheet 4 I have a formula that says; ='[c:\windows\desktop\Workbook1.xls]Sheet1'!a1 * '[c:\windows\desktop\Workbook1.xls]Sheet1'!a2 Could I have a cell where I type in Sheet1 or Sheet2 etc and this will in turn alter the formula ? I have tried...

How would I even start to write code that would open a file update links and calculate cells and then close the file? I am looking to do this in turn for 10 files but all from one set of code. Due to system memory all the files won't open at once, max of about 3 and that's with 383mb memory...

How would I even start to write code that would open a file update links and calculate cells and then close the file? I am looking to do this in turn for 10 files but all from one macro. What it is I had a 65mb Excel file (a business model) obviously this was causing problems in itself so I...

In Excel how do you stop the screen flickering as it runs long macros......? Thanks Jamie

I'm currently using a countif formula which has the condition as eg ">50" This returns a count of anything in a list greater than 50. What I need though is to have this 50 as a variable. I have tried a cell reference but Excel is then looking for the cell ref in the list ie...

Using SQL 6.5 how do I find which table a field is in if I have the field name ?? Also how do I list all tables and fields in the database, security levels is not an issue as we have no security or administrators set-up what-so-ever. Thanks Thanks Jamie

That worked perfect, you've no idea how many times I've wanted to do that and got fed up trying. Thank you. Out of interest what exactly does the text function do ? and what can it be used for ? Thanks Jamie

How do I write code in a cell to format a number in a particular way? What I'm doing is writing a formula which pulls in text and then inserts numbers into the text, ie ="Sales this period were -" & A50 However the number is formatted in the original cell it comes through as eg...

I need help urgently, this morning I was playing around trying to get a spreadsheet to change scenarios by way of a command button and kept getting a 1004 run-time error. Now I've come to do my real work and macros that do data sorts and format and back-up my spreadsheets are all failing with...

I have made Excel record a macro of me changing a scenario.....then looking at the code it produced the following; ActiveSheet.Scenarios("Scenario1").Show When I try and run this pre-recorded Macro though I get the following error; Run-Time Error '1004'; Show Method of Scenario...

I'm looking at putting boxes over a graph with further information about the graph. I have created a textbox off the Control Toolbox and thought the easiest way would be to use the linkedcell option. If for instance I want to link to a cell in a sheet called "Graph Data" and it's Cell...

I've been writing some databases lately with a bit of code in, nothing amazing, simple changes to list boxes sources, changing row sources based on selections in list boxes, etc. Everytime I compact the database though half way through I get an error to say the database needs repairing, then...

Single quotes it is......Thanks. Thanks Jamie