Recent content by msnook

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