I have a series of scorecards type sheets that I want to chart the data from.
While I could do each one in turn, I can have up to 20 seperate sheets, with 20 measures on each sheet.
I have half found an answer to this but wondered if someone can help with the rest
I want to select a row using...
Does anyone have any code that will set up a simple logfile of persons entering an inital page on a intranet site, i just need to write the network id, Time and date into a text file.
I only want to do this for a short time to enable me to find an rouge network user...
I want to connect Mappoint to an odbc that already exists on my machine, it is a sybase server not SQL so i can't use the Map Point SQL free add in.
Has anyone managed to do this??
I know i can link my database via Access into mappoint, but i do'nt really want to do this if i can help it...
I can't seem to find a piece of VBA code that will give me the last saved date of the workbook so that i can show this in a cell of a sheet, anyone know of anything that would work??
--------------------------------
Luke: But tell me why I can't...
Yoda: No, no, there is no why. Nothing more...
I have a number of spreadsheets that are linked to a series of data sheets. Every so often for no reason these sheets lose the links, although the sheets do not move, just get updated with data.
Despite clicking on 'Don't display the error and update links' on the edit links box, and also...
I have a number of spreadsheets that are linked to a series of data sheets. Every so often for no reason these sheets lose the links, although the sheets do not move, just get updated with data.
Despite clicking on 'Don't display the error and update links' on the edit links box, and also...
In a table i have a list of names and address's, each of these has a unique client ID, and each of these clients is allocated a caseload advisor.
In order to do a caseload audit, i have been asked to create a report with 6 random client no for each of the advisors.
I can't seem to get the...
I am sure that it is listed here somewhere but I cannot find it.
I would like to have a program running in the background that will be checking the contents of a folder, once a file exists with a certain name, the following will happen.
A) Create text file with names and update dates of all...
I have the below spreadsheet:
Advisor Type Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
A Barrett NEET 25 25 25 25 25 25 25 25 25 25 25 25
A Barrett In Learning 15 15 15 15 15 15 15 15 15 15 15 15
A Barrett Not Known 26 26 26 26 26 26 26 26 26 26 26 26
A Barrett YP JWT 29 29 29 29 29 29 29...
I have used VBA in Excel, but not for a while, so excuse the rather long winded question.
I have a crystal report that quite happly will export out the data I need into excel, this data contains a single entry for a number of users, each with a unique number.
I want to add the data into...
I have used VBScript in Excel, but not for a while, so excuse the rather long winded question.
I have a crystal report that quite happly will export out the data I need into excel, this data contains a single entry for a number of users, each with a unique number.
I want to add the data into...
I have some code that runs ok in a demo version of my database, but always seems to go wrong when i try to recreate it on the live server.
It always gives me an error of 'error at line 22 syntax error near '='
Below is part of the code with the 'error' line noted, anybody got any ideas...
I may have missed it, or i am just being stupid.
I have a crystal report that I want to add some data to via SQL, everytime I run some code I get more than one result per person, this is correct as that is the way the data is layered, poor db design, but as i didn't build it i cant be to blame...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.