object

Hi All, I have been lurking around for an answer but haven't been able to find one for my issue. I am making a macro in Excel that will compile files into a larger file. These files to be compiled also have images in specific boxes that I haven't been able to get to come over. I would select...

I am new to VBA. I am trying to change the background color of a text box based on another cell value. I am getting a Runtime error 424 Object required error. Here is my code - what am I doing wrong? Public Sub TextBoxColor() If Worksheets("Sheet1").Range("E1").Value = "Name" Then...

I'm trying to write a macro that automatically uploads a chart to powerpoint but it currently makes a new presentation everytime I try to do it. I got the macro from the internet and tried to modify it but nothing I try seems to be working Here's the code(not my code) below Sub ChartX2P()...

Afternoon, I am trying to automate some IE navigation. I am running into an issue when trying to populate a field. The object will allow for text entry - but i cannot seem to find a way to fire/trigger an event to populate the dropdown list that will then allow me to select from their...

Is there a windows api function to check the data type of the last item focused on or clicked down on (this includes a dragged object) is of the outlook object type? For instance, if you clicked on your desktop icon to drag it highlights to show its been selected and when you select an email in...

Public Sub DATA_noibang()Dim cn As Object, rs As Object, i As Byte, lr As Long, fso As Object Set cn = CreateObject("adodb.connection") Set fso = CreateObject("Scripting.FileSystemObject") Sheets("noibang").AutoFilterMode = False...

Hi, I am tryig to dwnload at least one thng from SAP. The code I am using to connect you can see below. The target is to download something to excel workbook from MM03, for instance weight or base uint of measure for the materil number 1234567. I need support. Dim Logon As Object 'Logon...

I keep getting Run-time error '-2147467259 (80004005)': Method 'MailEnvelope' of object '_Worksheet' failed when trying to run the a batch file with this script wscript.exe "U:\Programming\Scripts\VBS Scripts\SendEmails.vbs" SendEmail.vbs Option Explicit Sub ExcelMacroExample() Dim xlApp...

Hi everyone, Can someone help me debug this code? Dim ws1 As worksheet Set ws1 = Sheets("assets") Dim add As string add = Selection.Address ws1.Range(add).Unmerge

Hi Team, Thanks for your support !! Need a help in macro. My requirement is “ I need to open a webpage à Click on submit button à Enter the Request ID à Press Enter à Need to copy the data from the text box (it may be Read only or editable option) I am able to do the function till entering the...

I need to change how some code looks up a certain directory, previously I had it static where it was just a set folder. However now I want to make it a cell reference on a workbook im just not sure how to do so. Below is what I have, I would like it so its refering to cell A2 on a tab called...

I have a code that running on INBOX and extracting , need to modify it then it will be running on all subfolders. Please.. Private Sub ExtractEmails() Dim objNS As Outlook.NameSpace: Set objNS = GetNamespace("MAPI") Dim olFolder As Outlook.MAPIFolder Set olFolder =...

im trying to add some code to a spreadsheet, but even a simple thing like range("a1") = date triggers the error "cant find project or library" also, because of this error, i can't even insert a signature to the vba e-mail macro depsite doing this per...

I have upgraded Excel to 2016 and now get an error when using an older file with a spreadsheet object embedded in a userform. I think Microsoft Office Web Components 11.0 may no longer be supported, but I wanted to find out if there is another solution for displaying data on a userform that...

Hi, I am having an issue whereby I wish to update a PPT template through Excel VBA on my Mac. I am able to open the template and save a copy of it no problem, however I am having a problem where I am unable to select objects on PPT slides to update without Excel crashing. Please see the below...

The below code allows me to select a folder from outlook and pull some information from it. I didn't create this code - someone way more intelligent did! What I'm having issues with is getting rid of the selector for folder; I want to specify a mail folder within the code that will never vary...

When the contents of a cell changes, some strings are highlighted. This part I got working already. Now I added a regex to highlight strings that contain a temperature as well (i.e. 13° or 10°-25°) This part however does not work (no error but just no output) This is what I have so far. This...

Introduction Take a look at the following picture. There are two Outlook data files, their root folders are named “_FMMB” and “_Middle”. Both files have and subfolders and subfolders in subfolders. A number of emails are moved from Inbox to folder “_Middle\000_Arrive” manually (I prefer...

Hi, I am in the process of automating a monthly report using VBA (Power Point Presentation). I can not seem to add a sub heading to my current code. Thus far, I am able to add create the power point presentation (not shown entirely) and I have a heading (Shown Below). But I can not add a sub...

I have a daily report I need to send to my manager. Right now, my report has code to copy A1:F30 so I can paste the data into an e-mail. How do I modify this code so that I only copy rows with data instead of A1:F30? Sub Send_Email() On Error Resume Next Dim OutApp As Object Dim...