vba error

Hello helpful peeps! I have a massive macro that is run every month on files that are received from an outside source. It worked last month, but this month I received an error. The file received has not changed, nor has the code. I don't get it. Any help is appreciated! The line where the...

I'm trying to evaluate the formulas in a table object to check for any errors, and I'm using the Evaluate function to evaluate the formulas and check for any errors. Is there a better or different way of doing this? Thanks! programErrors = Application.Evaluate("COUNTIF(" & progRng.Address &...

Hello, I have many macros built into a workbook that I send copies of to my sales team. Over the weekend, everyone's began corrupting unexpectedly. Now, even my old versions of this workbook don't work and we know they did previously. The error when trying to initialize any macro is "Cannot...

Hi everyone. I asked part one of this question and it was answered quickly. HOW CAN I FIND THAT THREAD SO I DON'T DUPLICATE IN THE FUTURE?? (uggh....sorry) Goal: I have a 365 macro to save the file as a XLS file, then a PDF. Someone (thank you to that person!!) answered the question, but now...

Hello everybody, I am currently running an excel file in which I have created an order form that people can fill out with their information and the products that they would like to order. I am using a VBA code (please let me know in the comments if you want me to attach the entire code)...

I having some issue to integrate my programs to Telegram official API. I'm not a pro guy at it. can anyone help to solve it?

I generate a Word Document populating the bookmarks within it from excel and then tried exporting to PDF. Constantly getting error even after adding Microsoft Word Library 16.0. What am I doing wrong here? The code points to wdExportFormatPDF as Variable not Defined. <code style="margin: 0px...

Hi I have a vba which starts with the following: ActiveSheet.Name = "Salesforce Download" Dim lastrow As Long Application.ScreenUpdating = False Application.DisplayAlerts = False Setmyrange = range("A2", "A" & Cells(Rows.Count, 1).End(xlUp).row) Application.ScreenUpdating = False...

I have the following code but have not found a solution online. Has anyone figured out a solution? or would this relate to an authentication issue from my company's server? how do I get around that? I have the following references: Microsoft Access 16.0 Object Library Microsoft DAO 3.6...

I have 4 sheets, Sheet1, Sheet2, Temp, Base Price in sheet1 I have 2 columns Product code and Values, In sheet2 also I have 2 columns Product code and Values, In sheet1 A column a same product may be there for more than one time with different values but in sheet2 the product code is there only...

Hi All, I am having issues with loops in VBA, I am convinced it should work but doesn't & I have no clue why! Sub SiteReports() Dim T As Integer Dim fldr As FileDialog Dim sItem As String Application.ScreenUpdating = False Set fldr = Application.FileDialog(msoFileDialogFolderPicker)...

Hi there, I use the below code to automatically reveal a row as the user enters details. It's been working fine but in this case, there are many ranges to take into account and when I tried to put it all under one, it came back with a syntax error (it's too long). Therefore, I am trying to...

Recently, I had a project password go corrupt (still not sure how, literally a case of one day the password worked, the next day it didn't) and I had to use a macro-based workaround to re-establish access in VBA. During this process, I disabled the protection as the excel tool I created wasn't...

Hi all, while running the below VB i am facing with the Error " Compile error: Sub or Function not defined" and when i click on okay it highlights the line marked in yellow below. Please assist, thanks in advance. Regards Debraj Patra Sub MergeAllWorkbooks() Dim MyPath As String...

Earlier this month I was trying to figure out how to add a print button to a worksheet to print selected cells as a PDF document - https://www.mrexcel.com/forum/excel-questions/1037201-add-print-button-worksheet-print-selected-cells-pdf-document.html - which as you can see from that thread, I...

Can someone please help with this code. I have a file "AA" that I am looking to take data from my larger file, have it pasted into this file in a certain format and save the data in a certain naming convention as an XLSX and a PDF. However, I am having lots of trouble with this. I have the code...

Copy Columns from one Workbook into another, looping through sheets 6 to the last in the worksheet. Error message Compile Error: Duplicate declaration in current scope Sub CopyaColumnToWorkbook() Dim SourceWkb As Excel.Workbook Dim TargetWkb As Excel.Workbook Set SourceWkb =...

I have two different workbooks that I am utilizing for this macro. 1.) "zAward Template - Test - Copy" 2.) Appendix A I have written a macro that essentially takes the data I need in the template file from a tab and paste what is necessary to populate the appendix, does lookups to data, saves...

Hi, I have a super macro that is giving fits and I'm not seeing why. It is made of macros that call other macros (all of which work correctly on their own). The SuperMacro needs to run from one workbook that opens other workbooks and activate their macros. SuperMacro and one of its nested...

Good afternoon. I am hoping someone can help me out. I have a new job that requires me to run a VBA Macro. The macro is supposed to create a PDF document from an Excel Spreadsheet and encode it with a password. When I run the macro I get an "Run time error "429": ActiveX component can't create...