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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: hrm1220
  • Order by date
  1. hrm1220

    conditional formatting in 2007 excel

    Is there a way to ONLY copy the formula and not the conditional format? Each time I copy a cell it brings the conditional format with it regardless if I paste special formula or a regular paste. I have 300 rows and over 256 columns with conditional formatting. Any help would be greatly...
  2. hrm1220

    Store List of ChildItems from OLAP pivot table in an Array

    I have several worksheets with a pivot table on each worksheet from OLAP source in Excel 2007. The goal is to get the group1 (Parent), group2 (Parent child),and group3 (child). example: Group1 (the variant VarField (1,x)) Mammal Group2 (the variant VarField (2,x)) Dog Group3 (the variant...
  3. hrm1220

    search through an array of 40K rows

    I'm hoping someone can point me in the right direction. I have 2 tables that are 30K+ rows. I've put them in arrays. 1. need to find unique ID from myarray in the 2ndarray 2. if finds unique ID in 2ndarray a)need to check to see if certain criteria match b) if doesn't match criteria find...
  4. hrm1220

    refresh QueryTablesand add delay

    I appreciate the inputs, but it seems that vb script doesn't like "With objWorkbook.Connections("Connection1").ODBCConnection" or "objWorkbook.Connections("Connection1").ODBCConnection.Refresh" So, I'm not sure what to do. All I would like to do is have it open a workbook in excel 2007 and...
  5. hrm1220

    refresh QueryTablesand add delay

    thank you for that. when it's running it shows that it's completed, but when I open the file the MSQuery tables are not refreshed. This script is run in the middle of the night. My next question is how do I enable the data connection through code? here's what I have so far: strInput =...
  6. hrm1220

    refresh QueryTablesand add delay

    I'm very new to vb script. I've looked on the internet and haven't quite found what I need. I have a script that works for the most part, but it doesn't give excel time to refresh all the QueryTables (takes about 3min to refresh). So, I'm wondering if there is code to put in for delay before it...
  7. hrm1220

    find closest date/time value

    ok. thx for pointing me in the right direction Skip... I just needed to declare my datevalue. Cells.Find(varList(3, x)).Activate chCol = ActiveCell.Column timesplit = Split(varList(4, x), "/") timestart = Mid(timesplit(2), 8, 6) datesplit = Split(varList(4, x), ":") timematch =...
  8. hrm1220

    find closest date/time value

    I still get error 2042
  9. hrm1220

    find closest date/time value

    I've tried that and it gives me a type mismatch. It maybe that the source data has the date/time and the PM/AM after it. Could this be the reason why? So I used the split to take out the AM/PM but it still gives me a type mismatch error.
  10. hrm1220

    find closest date/time value

    I collect information from "Start" sheet that has the date and time, which is stored in the varList (but is seems to store it as text). In my "Report" sheet I have the minimum time (I get this from the "Start" sheet) as the starting point. Then add 30 seconds to each row. What I'm trying to...
  11. hrm1220

    Move and Size comments through VBA

    ok. well sorry for once again bother you guys. It actually does work. Again thx for looking for me
  12. hrm1220

    Move and Size comments through VBA

    thx I've added the Err.Clear, but I'm still having problems with the .Placement=xlMoveAndSize The code is not selecting this for the comments properties. Can you point me in the direction on where I messed up the code?
  13. hrm1220

    Move and Size comments through VBA

    I'm trying to fix the "Cannot Shift Objects off sheet" by looping through all the cells in a workbook. If the cell has a comment I want to change the properties of the comment to "Move and Size" (xlMoveAndSize) with the cell instead of the "Dont move or Size with cells" (xlFreeFloating). I...
  14. hrm1220

    excel 2003 can Max function be in sumproduct?

    my apologies for not being clear. I was looking for the max value based on the 2 criteria given in the 1st section of the sumproduct, so I was trying something like...
  15. hrm1220

    excel 2003 can Max function be in sumproduct?

    I have the following formula which works. But now I'm being asked to only provide the max value and not the sum, based on the 2 criteria. SUMPRODUCT(--(('[test.xls]Sheet1'!$AA$1:$AA$10000=$C13)*('[test.xls]Sheet1'!$W$1:$W$10000=K$1)),'[test.xls]Sheet1'!$V$1:$V$10000) So is there a way to add...
  16. hrm1220

    loop through pst folders on the c:\ using VBA

    I'm not sure if this is the right forum. 1. I'm trying to loop through all the pst files in my c:\ looking for specific date/time of email as well as to/from on the email. 2. Once I find these I would like to copy the emails to a new pst file. I've found some code, but not sure if it's what...
  17. hrm1220

    loop through pst files in c:\

    I'm not sure if this is the right forum. 1. I'm trying to loop through all the pst files in my c:\ looking for specific date/time of email as well as to/from on the email. 2. Once I find these I would like to copy the emails to a new pst file. I've found some code, but not sure if it's what...
  18. hrm1220

    Change Start and/or Due date in outlook to update project web access

    I'm trying to find out if you can modify the start date and/or finish/due date of a task through outlook (2003) then be able to upload into Office Project web access (2007). Does any one know if this is possible? Thx
  19. hrm1220

    compare rows in a text file

    Is there a way to compare rows in a text file usning VBA (Excel 2003)? I need to compare the rows before I import that text file data into excel. So, row 1 is the headers, and rows 2 to 70,000 is the data that I need to compare. I need to see if row 3 and row 2 have the certain data, etc. the...
  20. hrm1220

    Advice on MS Query

    I have an MS Query that I'm hoping I can get advice on for Excel 2003. What happens in excel is that the user puts in the criteria in certain cells, then the VBA opens up Business Objects, runs the query then saves the file as a text tab delimiter. After this it pulls that data into the MS...

Part and Inventory Search

Back
Top