The answer to your current problem could be that you are using a reference to the currently active sheet. You came as far as declaring a parent sheet (sh) but never used it as such. You can overcome that with a simple With: Dim sh As Worksheet: Set sh = Sheets(“RAW DATA FILE”) Dim x … Read more
As others have pointed out this is not a code site, thus plain old English. First, You need a static variable to store the previous value, static because it should not vanish from memory after your ‘current’ event is over. Then, You need to set said variable after an input is checked in your event … Read more
Insert a button on the workbook and assign this code to the button, make sure to change the filename path to yours: Private Sub CommandButton1_Click() On Error Resume Next Dim sheetIndex As Integer sheetIndex = 1 Application.ScreenUpdating = False Workbooks.Open Filename:=”C:\YourPath\Completed Workorders.xlsm” Windows(“Workorders.xlsm”).Activate ActiveSheet.Select ActiveSheet.Copy Before:=Workbooks(“Completed Workorders.xlsm”).Sheets(sheetIndex) sheetIndex = sheetIndex + 1 ActiveWorkbook.Save Windows(“Completed Workorders.xlsm”).Close … Read more
It’s not the most elegant code, but it works out for you. I totally changed the logic that you used to make ColSumTraining3 sub. Assign the macro to a button, select the desired row and click the button. The value of CumWip will be automattically filled based on the Area. You can adapt this code … Read more
I finally used these lines of code Arg = “‘” & Path & “[” & File & “]” & Sheet & “‘!” & “R4C4” ‘Range(Ref.Range(“A1”).Address(, , xlR1C1))C ‘Execute XLM macro GetValue = ExecuteExcel4Macro(Arg) Way more simple with some loops. solved get value/charts in another workbooks without opening it
My suggestion is as follows: Session.FindById(“wnd[0]/usr/tblZVMGO_SO_RDD_FDF_UPDTETABCON/ctxtVBAK-VBELN[0,” & cstr(LoopNum) & “]”).Text = Fill(LoopNum) Regards, ScriptMan 2 solved SAP EXCEL TABLE [closed]
Option Explicit Sub wqewrty() With Worksheets(“sheet1″).Cells(1, 1).CurrentRegion .Cells.Sort Key1:=.Columns(1), Order1:=xlAscending, _ Key2:=.Columns(2), Order2:=xlAscending, _ Orientation:=xlTopToBottom, Header:=xlNo With .Columns(1).Offset(1, 0) .FormatConditions.Delete .FormatConditions.Add Type:=xlExpression, Formula1:=”=$A2=$A1” .FormatConditions(1).NumberFormat = “;;;” End With End With End Sub I’ve assumed that you wanted to use column B as a secondary sort key to the primary sort key on column A. If … Read more
You take some code to export to CSV, such as from this answer How to create a separate CSV file from VBA? and just change the order you write to the file. E.g. write the column before writing the row Sub WriteFile() Dim ColNum As Integer Dim Line As String Dim LineValues() As Variant Dim … Read more
Some examples of how to avoid select Use Dim‘d variables Dim rng as Range Set the variable to the required range. There are many ways to refer to a single-cell range: Set rng = Range(“A1”) Set rng = Cells(1, 1) Set rng = Range(“NamedRange”) Or a multi-cell range: Set rng = Range(“A1:B10”) Set rng = … Read more