object

Hi, I have an Access Macro. In this macro, Microsoft Access 14.0 Object Library is ticked in Reference. I want to un-tick this reference. However while doing so I get pop-up as ‘Can’t remove control or reference; in use’. How do I find out what objects in my macro are related to this reference...

Hi everyone, Is there a chance somebody can please help with a formula which will basically remove all the text from this text block (example) pasted in excel: In literary theory, a text is any object that can be "read", whether this object is a work of literature, TK8881122 a street sign, an...

Hello, Using stream.WhiteLine in a VBA script is giving me the Object variable or With block variable not set error msgbox. Clicking on the Debug button brings me to the line that is written stream.WriteLine " " This is happening at the end of the script. But, I've used the stream.WriteLine...

Hi I am reading about macro settings and found this link about the option [] trust access to the vba project Mine is not check and I ran many small macros without problem so far. I read what is explained below but did not understand it well. Could you please explain to me why I need this...

The following code successfully downloads the image from the URL and saves it to the location specified. Is there any way I could adapt it to insert it straight into the sheet? Thanks in advance. Sub SavingImagesfinal() Dim http As New XMLHTTP60, htmldoc As New HTMLDocument Dim htmlas As...

Why do codes A & B below give me an Object Required (424) error (A is assigned to a button, B obviously fires on WB open) but C works without any issues?: A: ComboBox1.Value = "" ComboBox2.Value = "" B: Private Sub Workbook_Open() Dim ROWC As Integer ROWC = Worksheets("JOB...

Hi, I have found some code that allows the user to add a macro to an excel workbook at runtime. Is this possible to do for an outlook object? This method works for dynamically adding a macro to an excel object but I cannot find an equivalent for outlook. <code class="" style="box-sizing...

I am running a macro that saves a certain cell data to a property in sharepoint metadata. It works great. But, there's always a but, there are times that the string has a comma, then an intentional space at the end. When that is the case, I receive the following error: "method value of object...

I'm using the following macro to scrape a DropBox web page for a string and compare it to a stored value within a worksheet to determine if an update for the workbook is available. This all works on Windows but I get an error when I try and dim a HtmlDocument object or use...

Hi All, I am trying to doing web scrapping through VBA. Login website is working perfect but m stuck in next step where i need help to choose a right property to navigate. Below is the HTML codes extract via inspect element. and below is my VBA code: Sub xyz() Dim butt As Object Dim objcoll...

What code can I use to find the serial number of my computer? Below is what I have been using but I have discovered it is not the serial number that is on the computer. I now do not know what the number I do get represents. Public Function GetSerialNumber() As String Dim objs As Object Dim Obj...

URL in E1 is: https://www.tesco.com/groceries/en-GB/shop/fresh-food/all?include-children=true&page=1&count=48 I am trying to get the outertext, which should for example return: Tesco British Salted Block Butter 250G↵Write a review↵↵Sorry, this product is currently unavailable↵↵Rest of ↵Block...

Hello, If the VBA below cannot find anything for the particular pull I'd like it to Goto 1: and put a blank/1, can anyone help? Thanks. Public Sub Data_Pull_Products_and_Prices_2() Dim http As Object, html As New HTMLDocument, topics As Object, topics2 As Object, titleElem As Object, topic...

Hello, I am trying to pull data xml from the web into 2 columns, A and B. With the 2 topics below; topics and topics2, I need to try and pull it one - i.e. column A then B, rather than all of A's and then B. I cannot quite get the code to loop correctly below, any ideas? Thanks. Public Sub...

Hello following code works fine for 1 URL, I am trying to adapt so it runs for all the numerical pages it can find from the baseURL, so for instance the 1 up to the max until there is an error, is this possible? Thanks. baseUrl =...

Hello, Trying to pull all the names of the items and then the price on this page, https://www.tesco.com/groceries/en-GB/shop/fresh-food/all?include-children=true&page=1 e.g. Tesco British Salted Block Butter 250G £1.50 Tesco Gala Apple Minimum 5 Pack £1.60 But the code fails on this line...

Hi all, I was able to create a macro that allows me, with the push of a button, to send he Excel file to a certain address. Sub Mod_SendWorkbook() Dim OutlookApp As Object Dim OutlookMail As Object Set OutlookApp = CreateObject("Outlook.Application") Set OutlookMail = OutlookApp.CreateItem(0)...

How would I adapt the following code please so I could get it into a XMLHTTP web pull instead? e.g. Private Function getprices(ByVal URL As String) As Variant Dim source As Object Dim Http As New XMLHTTP60, Html As New HTMLDocument Dim ret(1 To 1) As String Dim elem As Object With Http...

Hi, I currently have the below code to pull a list from a file path every time the worksheet is activated. Sub worksheet_Activate() Dim objFSO As Object Dim objFolder As Object Dim objFile As Object Dim i As Integer Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFolder =...

tl;dr - Converted from early to late binding to email a report using Outlook, now getting "Error in Loading DLL" Good morning! I developed a tool for our production operations that automatically generates an email when a report is run. It was working fine for me using early binding, but then I...