Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jeffwest1

    VBA to create a chart from selected data

    Thanks for all the help I have now sorted this issue. I created a template chart and have added a series of buttons on each page withthe following code behind the button. Not pretty but it works. Sub CreateNEETChart() Sheets("Neet 16 - 18").Visible = True Dim SelectChart As Chart Set...
  2. jeffwest1

    VBA to create a chart from selected data

    SkipVought I am no novice at excel thank you, unfortunatly the make up of the sheets has been dictated by the needs and requirements of the business and what the scorecards have been designed to do, which is to allow for a scorercard/dashboard system of data, allowing users to only access their...
  3. jeffwest1

    VBA to create a chart from selected data

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

    Java Script Logfile

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

    Map Point 2010 ODBC

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

    2007 Linked spreadsheets

    I know i said this held, but it doesn't seem to, i still get spasmodioc link errors, anyone have a piece of code that i can run when the workbook is first open to check the links and update them. The files it links to are static, so it isn't as if they move. --------------------------------...
  7. jeffwest1

    Get Saved date from spreadsheet

    Brilliant, cheers. -------------------------------- Luke: But tell me why I can't... Yoda: No, no, there is no why. Nothing more will I teach you today. Clear your mind of questions.
  8. jeffwest1

    Get Saved date from spreadsheet

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

    2007 Linked spreadsheets

    Converting the seets to either xlsx or xlsm dependant on the content worrked a treat, cheers -------------------------------- Luke: But tell me why I can't... Yoda: No, no, there is no why. Nothing more will I teach you today. Clear your mind of questions.
  10. jeffwest1

    Excel Linked sheets

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

    2007 Linked spreadsheets

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

    Create a Random list

    The only problem with that is that it always just gives me the same 6. I have solved this now anyway using Crystal reports out of the database. -------------------------------- Luke: But tell me why I can't... Yoda: No, no, there is no why. Nothing more will I teach you today. Clear your mind...
  13. jeffwest1

    Create a Random list

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

    Check for file in folder then execute code

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

    Only Choose desired Rows and Columns

    Ok, adapting the code you sent to this Sub Findid() Dim wbNEET As Workbook Dim r As Range Dim Var1 As String Var1 = 0 Var1 = Cells(4, 2) 'Find Advisor Name Set wbNEET = Workbooks.Open(Filename:="c:\Scorecardtest\Neet.xls") 'Open Consolidated workbook...
  16. jeffwest1

    Only Choose desired Rows and Columns

    The source data is coming from a program written by our software supplier to aggregate data every month. From this I am pulling out data for all advisors from 5 offices in the 8 soon 9 target areas for reporting, I cannot simply extract the data that i need at advisor level without doing it...
  17. jeffwest1

    Only Choose desired Rows and Columns

    First, i am using a report to export my data into a usable format, as detailed above, so hardly shooting myself in the foot, more getting the data in the least unweildy format possible, if it wasn't a pain in the backside i would prefer to be using BCP or similar from the database, unfortunatly...
  18. jeffwest1

    Only Choose desired Rows and Columns

    This needs to be an automated process. The data will be coming out of a database via a crystal report overnight. The VB code will hopefully run each time the speadsheet is opned to update the data, as i said, this will be approx 200 speadsheets needing to be updated with data everymonth. Can...
  19. jeffwest1

    Only Choose desired Rows and Columns

    Sorry, just to clarify this, this is the code i am currently using Sub FindId() Dim Var1 As String Dim CopyRange As Range Var1 = 0 Var1 = Cells(4, 2) 'Find Advisor Name Workbooks.Open Filename:="c:\Scorecardtest\Neet.xls" 'Open Consolidated workbook Range("A1:G16").find(What:=Var1...
  20. jeffwest1

    Only Choose desired Rows and Columns

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

Part and Inventory Search

Back
Top