macros

  1. K

    How can I do to assign the value to my cell according to the "SUM" function (present in another Workbook)

    How can I do to assign the value to my cell according to the "SUM" function (present in another Workbook) Set sh = Workbooks("EEC QEC.xlsm").Worksheets(counter2) k = Workbooks("EEC QEC.xlsm").Sheets("QEC 1.2 - montagem").Cells(Rows.Count, "H").End(xlUp).Offset(1).Row Workbooks("EEC...
  2. K

    Object Required at Long Variable (???)

    I created a code to pass data from one excel file to another (it is a little confusing project because I am in a company), I believe that the code is correct in general but when I run the program it gives an error called "Object Required" in the variable " k ", can someone help me? Module...
  3. K

    "object doesn't support this property or method"

    "object doesn't support this property or method" can anyone help me? If sh.Name = "QEC 1.2 - montagem" Or sh.Name = "QEC 2.2 -SALA LIMPA" Or sh.Name = "QEC 2.4 Logística" Or sh.Name = "QEC 4.1 - MONTAGEM MANUAL(past)" Or sh.Name = "QEC 4.2 - Desmoldagem" Or sh.Name = "QEC 4,3 - RTM" Or...
  4. K

    How to use "range" with a text value of an integer value

    I need to use the "range" parameter to select a specific cell, it happens that when I "run" the program it gives an error and says "The specified dimension is not valid for the current graph" Error -------------------------------------------- If Range("H(CStr(k))").Value = "" Then...
  5. K

    I can't copy the files to another Excel spreadsheet

    I am trying to create a macro that passes values between 2 different excel files, I tried to create a counter whenever the values are inserted in the spreadsheets, the program does the same for all the spreadsheets available in these files, in case the cell where the value will be inserted the...
  6. K

    The program does not write the value on the sheet

    I created a code to open the most recent file in a specific folder and copy the value if a specific cell to another in a different excel file, the program executes everything, including I receive the value "msgbox" but the values are not written on the second sheet " EEC QEC.xlsx ", could...
  7. K

    Macro for writing to specific Excel spreadsheets

    I want to make a macro that just inserts values in cells where the name of the worksheets is different from "Potable C1", "Potable C2", "Potable C3.1", "Potable C3.2", the code is not working because it is writing in all spreadsheets, can someone help me? Dim sh As Worksheet Dim counter As...
  8. K

    Macro help for inserting data in spreadsheets!

    I want to create a macro to insert a value in cell "U37", but that value can only be inserted in spreadsheets with the name other than "Potável C1", "Potável C2", "Potável C3.1", and "Potável C3.2" I know my code is not right but I currently have the following: Dim ws, counter As Integer...
  9. K

    Cell with incorrect value

    I created a procedure that writes a specific text in the cell is empty, but when this occurs the value entered is always "TRUE" can someone help? Public Sub WriteValues() Ws = ActiveWorkbook.Sheets.Count For counter = 1 To Ws Worksheets(counter).Select...
  10. K

    Automatic executable creation

    Is it possible to create a vbs file similar to the same one but that is automatically executed when a new file is inserted in the folder?
  11. K

    Write a value on all worksheets in the workbook

    Good afternoon friends, is there any way to write a value in a specific cell on each sheet of the excel workbook using "Foreach" or in some other way? Example: Write the number 3 in cell A3 of each sheet of the current workbook
  12. K

    Can anyone tell me why is this appening?

    Private Sub UserForm_Initialize() Call CallTime_Msg lb_hello.Caption = msg lb_tec.Caption = Tec End Sub Sub CallTime_Msg() Dim mHour As Integer Dim msg As String mHour = hour(Now) If mHour < 12 Then msg = "Good Morning" ElseIf mHour < 18 Then msg = "Good Afternoon" Else msg =...
  13. K

    Can anyone tell me why my file isn´t save with this code?

    Since I added the time format the code stopped working, is there any way to include the time in the file name? Code: Sub SaveAsPDF() Dim FilePath As String Select Case MachineName Case "A4", "A8.1", "A8.2", "A8.3", "A12.1", "A12.2", "A12.3", "A20.1", "A20.2" FilePath...
  14. K

    Convert file to pdf regardless of user

    I tried to create a procedure whose objective is to convert the excel spreadsheet to pdf and save it in the folder "D:\Users\(UserName)\Documents\Project\(MachineName)", this program will be used by several users on different computers , how can I make the PDF be saved in the documents...
  15. H

    Update PowerPoint Slide from Excel Sheet with Macros

    Goodmorning, I need to create a Macro in my Excel Sheet, which automatically updates a graph on a PowerPoint Slide. Both Files already exist and I just need to tell two kinds of things: "copy this from excel and paste it here on the slide" and "copy this from excel, open this graph inputs and...
  16. S

    The code doesn't Run when saved in Personal.Xlsb for creating folders.

    Dear Team, I have the following codes as mentioned below which works fine when Running in Macro Enabled Work book but my Objective is to run these subroutine as mentioned below with Personal.xlsb and Saving it as Macro free workbook . The code are as follows The code creates folder and...
  17. U

    VLOOKUP on AUTOFILTERED VISIBLE CELLS

    I am trying to vlookup for visible cells. Have 2 sheets Data (that has the required data) and Result(where i need the desired result). On the Data sheet I want to Autofilter on "sourceid" column and all that has "xtrader", i want to do a vlookup based on "entity id" and get my "source entity id"...
  18. G

    Facing problem in finding Syntax for Advanced auto filter with wildcards using Macros

    I have created an event like when something changes in a cell, then an advanced filter should happen. The values to be filtered will be in C2:E3 with C2,D2,E2 as headers. the values will be filtered in B6:D67 with B6,C6,D6 as headers. Now the issue is: the values which I filter with...
  19. E

    Import Specific Rows from Large Text File using VBA

    Hey Everyone, I am looking to import specific rows of data from a very large text file (2.8GB+) into a new worksheet based upon unique text found within each row. Example Row of Data: 1234656|AV65712|ALBHM000|Blah|Blah|Blah... so on for roughly 90 columns. (The unique txt would be...
  20. P

    VBA - copy values based on month from one set of cells to another and then auto sort chronologically

    Hello all. I am looking for a formula for a button that will take the date values that are in column K and reference whether they are the current month, then copy the ones that are for the current month into cells B17:B33, and if they are the next month into cells B36:B65. These dates also have...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top