vba error

  1. K

    Need to integerate Telegram API with VBA Excel

    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?
  2. S

    vba Error: Converting Word Doc to PDF

    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...
  3. Small Paul

    VBA Fails When Only 1 Line of Data

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

    Run-time error 3343 - Is there a solution

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

    Change the values of a sheet based on negative and positive calculation of another sheet

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

    VBA Loop

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

    VBA Code Error - Reveal next line in multiple areas

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

    VBAProject properties prompting for password when protection is not enabled

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

    Error while running VBA

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

    Intermittent 400 and 1004 VBA errors with a macro to save the active worksheet as a PDF file

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

    Run Time Error 53 Code

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

    Copy Columns from one Workbook into another

    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 =...
  13. A

    Why will my loop not move through different worksheets (tabs)

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

    Nested macros not looping correctly.

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

    VBA Macro issue-excel spreadsheet to PDF with password encoding

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

    VBA run-time error '438':

    Limited VBA conceptual understanding. Using Excel 2010 Binary file type. Attempting to modify three simple graphs (on same worksheet) by overriding scale minimums and maximums with cell references in same worksheet. Unfortunately, I am getting a VBA error that I have done some limited...
  17. P

    Application-defined or Object-defined error

    Hi I'm getting this error in the following formula: If I remove everything from below displayAlerts = false to above Application.DisplayFullScreen = False vba works fine... Private Sub Button6_saveClose() stopsaveTimer DisplayAlerts = False Worksheets("work record").Range("bp13").AutoFill...
  18. E

    Application Defined / Object Defined Error

    Hi, I'm working on the code below and can't seem to figure out why I'm continually getting the application defined / object defined error. I had it working before and for some reason it's now giving me this error every time. The issue seems to surround the With Statement when the ".Pattern"...
  19. P

    cannot find library or project

    Hi, I've transferred a vba workbook to a new computer. Everything worked fine on the old machine however on the new one the error "cannot find library or project" shows. I have a form within this workbook with code assigned to it. The form has several combo boxes that initialize on load...
  20. A

    why does this not work comparing the 2 cell values?

    What is wrong with this? I want to compare my values from a range to a single cell. My Value for Cell 22,2 is 4 Dim Cell, Result As String, I As Long For I = 3 To 17 If Cells(I, 2).Value > Cell(22, 2).Value Then Call Step2(" Error") Exit Sub

Some videos you may like

This Week's Hot Topics

Top