Search results for query: *

Re: Python 3.6.0 and Notepad++ From the Notepad++ run menu I run: "C:\Program Files (x86)\Python36-32\Lib\idlelib\idle.bat" -r "$(FULL_CURRENT_PATH)" Which opens the Python 3.6.0 Shell and runs the Python code. However, it does not close any open Python Shell windows. Neither does it save...

Wmbb, The problem is, as SkipVought wrote, you are trying to kill an open file. Your code: target = workdir & "\" & "temp_" & Adocname has the same effect as target = workdir & "\" & "subfolder\" & Adocname Both are saving the active file to a new one. The kill command is not really doing...

This works: Sub delete_row_if_one_of_the_cells_in_the_row_is_blank() Dim a, i, num_of_rows, num_of_cols, num_of_cells_with_data As Integer 'number of rows and columns num_of_rows = 10 num_of_cols = 26 a = 1 For i = 1 To num_of_rows 'count the number of cells...

http://files.engineering.com/getfile.aspx?folder=baf9f8f2-2268-401b-85ef-2ce3ba79d14e&file=pivot_table.JPG Create a pivot tablehttp://files.engineering.com/getfile.aspx?folder=baf9f8f2-2268-401b-85ef-2ce3ba79d14e&file=pivot_table.JPG

In the pivot table, select the change data source option and extend the table. No macro necessary.

Easy, 1. Select a cell outside of the tables 2. from consolidate, add each table as its own reference 3. Select option use labels in top row and left column But it is better that you use a pivot table.

So I tried Dim TempUnits As Variant and Dim TempUnits As Object Both worked! Thanks!

CMP, Dim TempUnits As DispHTMLElementCollection MsgBox "TempUnits is " & TypeName(TempUnits) MsgBox "webbookForm('TUnit') is " & TypeName(webbookForm("TUnit")) Set TempUnits = webbookForm("TUnit") TypeName shows TempUnits as "Nothing" and webbookForm("TUnit") as...

If I understand correctly, this should work: Public Sub Sendemails() Dim mailItem As Long Dim myOutlook As Outlook.Application Dim myNameSpace As Outlook.NameSpace Dim myFolders As Outlook.Folders Dim myFolder As Outlook.MAPIFolder 'Send all items in the "Grade 1" folder that have a "To"...

Ok, so is: Dim TempUnits as DispHTMLElementCollection or Dim TempUnits as HTMLInputElement And Dim item as DispHTMLElementCollection or Dim item as HTMLInputElement ?

PHV, I just tried that and it does not work. For a variant, the error is Run-time error '438': Object does not support this property or method.

So I want to use Excel VBA to open and manipulate websites. I have selected Microsoft HTML Object Library and Microsoft Internet Controls in VBA references. I want to select a radio button from a group using excel VBA. I keep getting a Run-time error '13': Type mismatch. on the radio button...