Search found 3 matches

by jaybro
14 Feb 2019, 10:10
Forum: Ask For Help
Topic: How pass argument or clipboard to this ComObjCreate( "Shell.Application" ).Windows.FindWindowSW( 0 , 0 , 8 , 0 , 1 ).Doc Topic is solved
Replies: 4
Views: 304

Re: How pass argument or clipboard to this ComObjCreate( "Shell.Application" ).Windows.FindWindowSW( 0 , 0 , 8 , 0 , 1 ) Topic is solved

Can someone help me sort out what the meaning of these properties (methods?) are: "( 0 , 0 , 8 , 0 , 1 )" ComObjCreate( "Shell.Application" ).Windows.FindWindowSW( 0 , 0 , 8 , 0 , 1 ).Document.Application.ShellExecute() My main script requires "Run as Administrator" UAC access -- but it needs to cal...
by jaybro
09 Feb 2018, 16:36
Forum: Ask For Help
Topic: Reference Excel Totals Rows by Column Name?
Replies: 2
Views: 149

Re: Reference Excel Totals Rows by Column Name?

Thanks, FG! I didn't know about TotalsCalculation object. Here's what I came up for a cleaner range reference (which I'm happy with) to manage the Totals row: ListColumns("Column1").Total.Address xl := Excel_Get() t := xl.ActiveSheet.ListObjects(1) t.ShowTotals := 1 xl.Range(t.ListColumns(""Avg Wrap...
by jaybro
08 Feb 2018, 15:27
Forum: Ask For Help
Topic: Reference Excel Totals Rows by Column Name?
Replies: 2
Views: 149

Reference Excel Totals Rows by Column Name?

Suppose your have a table in Excel with the totals row showing. You know the column headings and would like to apply a formula to a specific total cell using nothing more than the column heading text and table objects. The "Get_Excel" function (found on the forums) gives me a solid handle on the wor...

Go to advanced search