logo
Tags down

shadow

How to run IW29 with a specific variation and layout and copy its outcome to excel?


By : user008
Date : October 18 2020, 08:10 PM
With these it helps I'm trying to copy the result I get from running IW29 with a specific variation and layout to excel. I recorded a script within SAP to run IW29 with the variation and layout I wanted and it goes like this: , You could try the following:
code :
...
'session.findById("wnd[0]/usr/cntlGRID1/shellcont/shell").setCurrentCell -1,""
'session.findById("wnd[0]/usr/cntlGRID1/shellcont/shell").selectAll
set myGrid = session.findById("wnd[0]/usr/cntlGRID1/shellcont/shell")
myGrid.selectedRows = "0"
myGrid.contextMenu
myGrid.selectContextMenuItem "&XXL"
session.findById("wnd[1]/usr/cmbG_LISTBOX").setFocus
session.findById("wnd[1]/usr/cmbG_LISTBOX").key = "08"
session.findById("wnd[1]/tbar[0]/btn[0]").press
session.findById("wnd[1]/tbar[0]/btn[0]").press
session.findById("wnd[1]/usr/subSUBSCREEN_STEPLOOP:SAPLSPO5:0150/sub:SAPLSPO5:0150/radSPOPLI-SELFLAG[0,0]").select
session.findById("wnd[1]/usr/subSUBSCREEN_STEPLOOP:SAPLSPO5:0150/sub:SAPLSPO5:0150/radSPOPLI-SELFLAG[0,0]").setFocus
session.findById("wnd[1]/tbar[0]/btn[0]").press
session.findById("wnd[1]/tbar[0]/btn[0]").press


Share : facebook icon twitter icon

get minimum price variation and maximum price variation according to specific category woocommerce


By : new member
Date : March 29 2020, 07:55 AM
I hope this helps you . I want to get minimum price and maximum price based on categories. The woocommerce query which gives me minimum and maximum product price range but i want it on the bases of category. , SQL Query:
code :
//SQL Query to get max price : 
SELECT max(meta_value + 0) FROM wp_posts LEFT JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE meta_key = '_price' AND (wp_term_relationships.term_taxonomy_id IN (46,47));  

//SQL Query to get min price : 
SELECT min(meta_value + 0) FROM wp_posts LEFT JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE (meta_key = '_price' OR meta_key='_min_variation_price') AND (wp_term_relationships.term_taxonomy_id IN (46,47));
//46, 47 is the term id of category. So you need to have id of music and clothing
<?php 
    $category = array('t-shirt');

    $args = array(
        'posts_per_page' => -1,
        'post_type' => 'product',
        'orderby' => 'meta_value_num',
        'order' => 'DESC',
        'tax_query' => array(
            array(
                'taxonomy' => 'product_cat',
                'field' => 'slug',
                'terms' => $category,
                'operator' => 'IN'
            )
        ),
        'meta_query' => array(
            array(
                'key' => '_price',
            )
        )       
    );


    $loop = new WP_Query($args);

    echo "Max :" get_post_meta($loop->posts[0]->ID, '_price', true);
?>

How to copy a specific portion of text file to a specific cell in excel worksheet with python openpyxl?


By : Jimbooh
Date : March 29 2020, 07:55 AM
I hope this helps you .
code :
file_path  = '/Users/bekir/Documents/deneme.xlsx'
xfile = openpyxl.load_workbook(file_path)
ws = xfile['sayfa3']

# have to start range from 1 since excel cell offset starts at 1
for i in range(1,100):
    cell = 'D' + str(i)

    if ws[cell].value == run_number:
        ws['D' + str(i)] = THT
        break

xfile.save(file_path)

specific columns copy from one excel to another excel based on column header name


By : Gregory Kinelap
Date : March 29 2020, 07:55 AM
Hope that helps I want to copy the columns from one excel to another excel based on the column header name. i have two excel file called "Source" and "Destination" as shown below in the image: , Please try this.
code :
Option Explicit

Public Sub SpecificColCopy()
    Dim Wbs As Workbook
    Dim Wbd As Workbook
    Dim Wbm As Workbook
    Dim RealLastRow As Long
    Dim SourceCol As Long
    Dim Cell As Range
    Dim sourceWS As Worksheet, targetWS As Worksheet
    Dim MacroWS As Worksheet
    Dim SourceHeaderRow As Long: SourceHeaderRow = 1
    Dim SourceCell As Range
    Dim TargetHeader As Range
    Application.DisplayAlerts = False
    On Error Resume Next
    Set Wbm = ThisWorkbook
    Set MacroWS = Wbm.Worksheets("Sheet1")

    Set Wbs = Workbooks.Open("C:\mydirb\Source.xlsx") 'workbook needs to be closed state
    Set sourceWS = Wbs.Worksheets("Sheet1")

    Set Wbd = Workbooks.Open("C:\mydirb\Destination.xlsx") ''workbook needs to be closed state
    Set targetWS = Wbd.Worksheets("Sheet1")
    Set TargetHeader = targetWS.Range("A1:N1")
    On Error GoTo 0

    sourceWS.Activate
    For Each Cell In TargetHeader
        If Cell.Value <> "" Then
            Set SourceCell = Rows(SourceHeaderRow).Find _
                (Cell.Value, LookIn:=xlValues, LookAt:=xlWhole)
            If Not SourceCell Is Nothing Then
                SourceCol = SourceCell.Column
                RealLastRow = Columns(SourceCol).Find("*", LookIn:=xlValues, _
                SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
                If RealLastRow > SourceHeaderRow Then
                    Range(Cells(SourceHeaderRow + 1, SourceCol), Cells(RealLastRow, _
                        SourceCol)).Copy
                    targetWS.Cells(2, Cell.Column).PasteSpecial xlPasteValues
                End If
            End If
        End If
    Next


  MacroWS.Activate
  Wbs.Save
  Wbd.Save
  Wbs.Close
  Wbd.Close
  Application.DisplayAlerts = True
End Sub

 [![Souce_destination][1]][1]

Paste a chart from Excel to a specific placeholder in a specific layout. Powepoint 2010


By : Bob Withers
Date : March 29 2020, 07:55 AM
help you fix your problem If I understood your problem then I think this is what you want.
You are currently pasting the chart "On" Slide 1. You have to paste it "In" relevant Place Holder in Slide 1.

How to copy a line in excel using a specific word and pasting to another excel sheet?


By : surya
Date : March 29 2020, 07:55 AM
This might help you I have checked a bunch of different posts and can't seem to find the exact code I am looking for. Also I have never used VBA before so I'm trying to take codes from other posts and input my info for it to work. No luck yet. At work we have a payroll system in Excel. I am trying to search for my name "Clarke, Matthew" and then copy that row and paste it to the workbook I have saved on my desktop "Total hours". , TRIED AND TESTED
Related Posts Related Posts :
  • VBA search for values and delete from list (for loop is too slow)
  • Value of nLarge and it's item data
  • How to take text from a cell and input it into VBA?
  • VBA is not assigning a certain value
  • Run-time error; Automation Error; Unspecified Error in VBA using UIAutomation
  • Extract span text by next element using CSS Selector
  • What is Proper DAX GROUPBY Syntax In Calculated Column in Power Pivot in Excel in Office 365
  • Extract data from column of selected row in excel vba userform combobox
  • Save as PDF Macro, with dropdown
  • Why empty excel file is 5.5mb large?
  • How do I filter a dataset to matching information in Excel?
  • cell.Value not retrieving the carriage returns in the cell
  • Add in another For Loop in order to have another worksheets data added before the file is saved
  • Recursive Search Through Subfolders BACK to Root Directory
  • Update Chart to include last row data using defined range
  • Color cells right to left in vba loop
  • Please advise to make code more efficient to execute
  • How to process SQL results into a CSV/Excel attachment using JCL?
  • Excel VBA Prompt Message After Sending Outlook Mail
  • VBA "Expected end of statement"
  • Is There a way to recover a severely corrupted EXCEL FILE?
  • VBA: Split sheet on certain rule
  • Excel VBA set default to not split images in two when printing
  • Cannot get the text of nth span element using vba
  • Excel Conditional Formatting For Multiple Matches
  • Cut/paste range of cells into another sheet and send an email
  • VBA runtime error 1004 - vlookup works sometimes
  • Create Column as below
  • Which tool can be used to extract and group rows and do the summation?
  • Find Function in VBA (Excel) won't find the minimum value
  • shadow
    Privacy Policy - Terms - Contact Us © voile276.org