Breaking News: Grepper is joining You.com. Read the official announcement!

can you mae the same but using javascript ?

DRE_ AXIS answered on October 12, 2023 Popularity 1/10 Helpfulness 1/10

answer can you mae the same but using javascript ?

related can you mae the same but using javascript ?

can you mae the same but using javascript ?

Comment

=CHAR(10) & "function RunJavaScript() {" & CHAR(10) &
"    var excelApp = new ActiveXObject('Excel.Application');" & CHAR(10) &
"    var excelWorkbook = excelApp.Workbooks.Open('" & ThisWorkbook.FullName & "');" & CHAR(10) &
"    var excelSheet = excelWorkbook.Sheets('Sheet1');" & CHAR(10) &
    
"    var condition = prompt('Enter the filtering condition (e.g., rate >= 90):');" & CHAR(10) &
"    if (condition) {" & CHAR(10) &
"        excelSheet.Cells(1, 1).CurrentRegion.AutoFilter(5, condition);" & CHAR(10) &
"    }" & CHAR(10) &
    
"    excelApp.Visible = true;" & CHAR(10) &
"}"

Popularity 1/10 Helpfulness 1/10 Language javascript

Source: chat.openai.com

Tags: javascript using

Link to this answer
Share Copy Link

Contributed on Oct 12 2023

DRE_ AXIS

0 Answers Avg Quality 2/10

Closely Related Answers

can you mae the same but using javascript ?

Comment

Sub CreateFilterButton()
    Dim btn As Button
    Set btn = ActiveSheet.Buttons.Add(Left:=100, Top:=10, Width:=100, Height:=30)
    
    ' Customize the button label and caption
    btn.Text = "Filter Data"
    btn.OnAction = "RunJavaScript"
End Sub

Popularity 1/10 Helpfulness 1/10 Language javascript

Source: chat.openai.com

Tags: javascript using

Link to this answer
Share Copy Link

Contributed on Oct 12 2023

DRE_ AXIS

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

can you mae the same but using javascript ?

Contents

More Related Answers

can you mae the same but using javascript ?

Closely Related Answers

can you mae the same but using javascript ?

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.