Search results for query: *

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

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

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

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

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

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

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

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

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

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

I really appreciate everyone's 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...

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

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

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

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

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

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

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

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

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