object

Sub Bulk_Print_From_Folder() Dim k As Variant Dim n As Variant Dim oFile As Object Dim oFiles As Object Dim oFolder As Object Dim Path As Variant Dim vItem As Object Path = "C:\Testing Folder" With CreateObject("Shell.Application") Set oFolder =...

The title pretty much sums up what I am trying to accomplish but have had no luck whatsoever. I'm trying to copy a range from an excel worksheet to word but when I do, it changes the text formatting and the table extends beyond the first page (both to the right and onto the next page). So I'm...

Hi Could somebody please help me, The following code is should navigate to google and then pull all the urls from the link to a sheet. I keep having issues with the line of code shown in red. "Object doesn't support this property or method" Sub webpage() Dim internet As Object Dim...

Hi, I have Union Query in access named "Audit Query" and in this query has two parameters "Quarter" and "Last Name", I am using below code to pass the parameter to the query and then executing the query and holding the record in a recordset variable it is giving me an error message. "Parameter...

repeated I don't want to select or enable Power point reference ,and need to Merge Shapes but there is Error Public Sub MangePPTFromExcel() Dim PPT As Object Dim Pres As Object 'Dim Sld As Slide' have to go to: Tools --> select Microsoft PowerPoint ? object Library Dim Sld As Object 'not...

Hi, I have an excel sheet that has list of employees, and I need to send emails to each employee with specific file (depends on Employee ID), I named the files logically so that the macro attach the right file. I have below macro which works fine, and it create email and attach the required...

Hi Folks, I have a 2 small tables of string data (5 rows x 2 cols) wherein I need to use one or the other on a spreadsheet. I thought this would be a good candidate (and feet wetter, for me :) ) for a Range Object. So far—so good. The problem then came in trying to put the object into some...

I have a table (shown in image below) in A1:C21 on Sheet 2 that I want to be constantly visible when I'm working on Sheet 1. HOWEVER, I don't want it to actually use up any CELLS on Sheet 1 (since I don't really have cells to spare there.) Idea popped into my head today: can I instead create...

https://www.cms.gov/medicare-coverage-database/search/advanced-search.aspx Hello all, I'm trying to automate going to the above site for a simple search feature in Excel and the name of the search bar comes back with a really long name. Is the name truly as long as it states or am I missing...

I have hit a roadblock in the progress of my VBA project. I am reaching out to a second group of pros to see if perhaps they have a solution after having limited success where I had originally posted my question. I have two open userforms. userform1 (uf3_group_1) has a textbox (textbox1) in...

I'm trying to insert a formula and copy it down to the last row of the data it's working on. Sub InsertAndCopyFormula() Sheets("PasteData").Select Range("L2:L" & LastRow).Formula = "=MONTH(I2)" End Sub When I execute this code, I get the error "Run-time error '1004': Method 'Range'...

I seem to be stuck with a problem that likely has a very simple solution ... My Code ... 'update userform With uf1_main 'active With .lb_cntaba_dt .Caption = cnt_dt If cnt_dt = 0 Then .Enabled = False...

Hi I wanted to assign value to this line Workbooks(1).Worksheets(1).Cells(xrow, xcol).Borders.Weight = So I used Object Browser, and typed Borders then clicked on weight and I read the following: Property Weight As Variant Property Weight As Variant that is all! nothing else. I had...

Dear all, I am trying to write a macro to copy the open sheet into multiple worksheets inside the folder. However, I am not sure of exact syntax. Please help me to correct the syntax. Private Sub CommandButton10_Click() Dim oFSO Dim Folder As Object Dim Files As Object Dim file As Object...

I had a VBA debugging problem that i finally solved with difficulty. Along the way, i wanted to find out what workbook a Range object was referring to, but it seems that Range does not have a Workbook property. So, i wanted to verify that, and ask if there is any way i could have gotten at the...

While working on a spreadsheet at work, I was getting the error "method open of object workbooks failed", but when I got home, the same file was not giving me any errors. Any ideas why?

Hi, I use a Try-Catch block to catch errors in my code. This is not strictly VBA code, but VB.NET code which is very similar. I am not sure this is the appropriate forum. I use a general exception to trap my error: Try Catch ex As Exception End Try When the error I have in mind happens, I...

I have a report that I'm developing and want to email it automatically when it's ready. I know how to do most of it, but I'm having trouble with the Subject line within the email. I want the subject line to be the file name. Below is the code that I have right now, that works fine, that...

Hello everybody. Something unexpleinable (I mean, for me) is happening: run time error 1004 application defined or object on the following line: For Each Cell In Sheets(2).Range(Cells(2, 3), Cells(403, 3)) Why?