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

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

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

I have a script set up for AVAYA and I want to run this script using EXCEL. I can set it up as a link in excel with a Macro to run the link but that presents a problem as the tool will be used by multipeople at multiple sites and would have to be adjusted on everyones computer for the link to...

I know that Excel has a built in Sorting function but I was trying to set up a button that I could push and a box would pop up asking which column I wanted to sort by. I then click on that column heading and it would auto sort for me. I can set it up with a button for each column but not one...

I believe this will be an easy question. We are using AVAYA CMS Supervisor and I have a person who needs to be able to view real time reports and run historical ones. I am not for sure how to set this person up with those abilities so if someone could provide insight that would be excellent...

I believe this will be an easy question. We are using AVAYA CMS Supervisor and I have a person who needs to be able to view real time reports and run historical ones. I am not for sure how to set this person up with those abilities so if someone could provide insight that would be excellent...

I know there must be an easier way to outline a specific cell but I am not for sure what it is. The coding I have is: Range("B15").Select With Selection.Borders(xlEdgeLeft) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With...

I have almost exactly the same coding in two different spreadsheets. In one workbook it works without a hitch on the other I get an error message (which I think I should get but dont want). Can anyone tell me why there is a difference between the two sheets and what I could do to get rid of...

I am using the following coding to copy data from one sheet and place it on a differents sheet stating with row 7 and then going down qith each successive row of data. At the end of this I need to total up a column. In a normal sheet I would put =sum(D7:D14) but the problem is that there is no...

In my Excel Spreadsheet I have a list of names. George Washington Abraham Lincoln Albert Einstien I am using an input box so that I can choose a name and then search for data associated to that particular name. MySearch = Application.InputBox("Which person do you want to run records for?")...