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: *

  1. msnook

    PasteSpecial method error

    I am using the following code: Windows("Extracts " & MyDate & " " & ampm & ".xlsx").Activate Sheets("H4").Select Range("A1").Select Range_Select Selection.Copy Windows("IRIS Backlog.xlsm").Activate Sheets("H4").Select Range("U20").PasteSpecial Paste:=xlPasteValues...
  2. msnook

    VBA excel sheet as PDF to SharePoint

    I am using multiple macros within a spreadsheet to compile reports. When one of these reports are done the macro takes the current sheet and loads it to our SharePoint site as a PDF. I have issues with this, it locks my excel with a blank screen and stalls out my macro. The code I am using is...
  3. msnook

    variable columns

    I did, it worked beautifully. Thank you for the assistance. For r = a To b MySup = Cells(a, rSup.Column) For y = a To b If Cells(y, rSup.Column) <> MySup Then c = y - 1 y = b End If Next y
  4. msnook

    variable columns

    I see how that sets the MySup value but can I use the same language in the "y" loop. for y=a to b if Cells(a, rFoundColumn) <> MySup then c=y-1 y=b End if next y
  5. msnook

    variable columns

    I have written a macro that loops through a column of data finding matching entries. Where a = the starting value I want to match and c becomes the end of the matching entries. MySup = Range("B" & a) For y = a To b If Range("B" & y) <> MySup Then c = y - 1 y = b End If Next y This...
  6. msnook

    Column Search Error

    I need to create a page so that I can load the data into an Access database.
  7. msnook

    Column Search Error

    I am using VBA to look through a set of data that is 17 columns by 12000 rows. It finds a specific column header copies the column and places it onto a secondary sheet. I do this because the data report I recieve isn't always in same order and often has more data than I need. I have included...
  8. msnook

    IP 03 - OL 07 email error

    I am having an error trying to send an InfoPath 2003 form through Outlook 2007. I have read on various other sites both that it is possible to do and that it isn't. Those who say it can be done suggested creating a button with coding in it to accomplish it. I have done this (code below) and...
  9. msnook

    Infopath VB to fill textbox

    The code I have so far is: XDocument.DOM.setProperty "SelectionNamespaces", "xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"" xmlns:my=""http://schemas.microsoft.com/office/infopath/2003/myXSD/2011-05-17T18:22:26"" xmlns:xd=""http://schemas.microsoft.com/office/infopath/2003"""...
  10. msnook

    Infopath VB to fill textbox

    I am using VB to submit info from an Infopath form to my Outlook calendar but I am hung up on the coding needed to enter a value into a textbox located on the form itself. Any assistance in this area would be greatly appreciated. Mike
  11. msnook

    countif with multiple criteria

    ...insight and assistance with this. Please let me know if the code I am using has problems or could be simplified. =SUMPRODUCT((Sheet2!D2:D5000=M9)*(Sheet2!N2:N5000=L2)) My spreadsheet is on Sheet2 D2:D5000 is 'Requester Code' M9 is requester I am counting N2:N5000...
  12. msnook

    countif with multiple criteria

    mscallisto - I know pivot tables, my employer who doesn't needs the info to use so I was trying to make it as easy as I could for him to manipulate the data outside of using a pivot table. Skip - The Jan, 10 date is a text file that I set up based on a submission date so that I could group...
  13. msnook

    countif with multiple criteria

    I can not seem to figure out my dilema so I thought I would ask for assistance. I have a large spreadsheet in multiple columns and rows. I need to be able to count the number of 1 item as it depends on another item. for example Error code Date 1 Jan, 10 1...
  14. msnook

    Autorun every 30 minutes

    I have a macro that I needs to run every 30 minutes. I was hoping this might be accomplished with a macro so that I don't have to stop what I am doing and press a button every time it needs to run. I have another script in AVAYA that produces results every 30 minutes (1:02, 1:32, 2:02, 2:32...
  15. msnook

    AVAYA to excel

    We currently are using CMS Supervisor 14.0 at my place of employment. I am trying to automate a manual step. We currently run a report in AVAYA and load the data into a spreadsheet. I am looking to write a macro or script that will accomplish the same thing automatically. My plan was to...
  16. msnook

    matching same/similar records

    The errors are when the numbers match so #1 (which doesn't match)is a correct entry and the other two were entered in error (and therefore match). Thanks for the input. I thought of many partial remedies but nothing that would catch the majority of the varialbles (Other than what I outlined in...
  17. msnook

    matching same/similar records

    I have a challenging problem of finding entries that are similar and may not be exact matches. Any assistance will be greatly appreciated. I am working on a list that has two columns of information like the ones below. Item Number Serial Number 1 193955601 3091669457 2...
  18. msnook

    Write Permission problem

    I am using AVAYA CMS Supervisor to monitor agents phones. I need to change the queues that they are assigned to. I go to Agent Administration --> Change Agent Skills and select an agent. I can see all of the skills assigned to that particular agent and can add and delete some of them but on...
  19. msnook

    Need help with list search please.

    I am dealing with a list of 500 rows and 32 columns. I am trying to find one of 45 different items in any one of 4 columns. I wrote a macro that works and I have included it below. If there is a better or faster way to do this the input would be greatly appreciated. The 'List' page contains...
  20. msnook

    Excel AVAYA cross

    The coding that I included works with AVAYA to run a report called the Group AUX Daily for a specific person (Michael Snook) and a date of my selection. I am using that data in a daily EXCEL report. My thought was that I could automate the process to run the reports and only open EXCEL to do...

Part and Inventory Search

Back
Top