Recent content by abitslow

SOLVED: thanks again IPGuru - you got me looking in the right place. I was changing the name but the .py which called the unzipper wasn't passing on a new name (if one was entered) from the downloader, just looking for the original from the url.

Thnaks for that IPGuru. To answer your question: The code does successfully change the name of the .zip file as I am testing it using a short .py with a "destfilename" intentionally there for that purpose and the result is a file with "that_new_name.zip" What happens is that it won't then unzip.

I scripted a download and unzip for .zip files. This works with no problem if the name of the .zip remains unchanged. If I try and change the name of the .zip on download then the zipfile.is_zipfile() won't recognise the file as a .zip file [though it still unzips in WinRAR]. I change the name...

Brill! Many thanks Skip! Works wonders for data mining.

Hi, I'm trying to use named arrays in Excel with the TREND function. I can do a SUM using named arrays to select data, such as {=SUM(IF((Array1="yes")*(Array2="Big"),Array3,""))} Note: {} achieved by Ctrl+Shift+Enter after typing in the formula I'm failing to do a TREND in the same way, such...

Excellent. Thanks Pink & Jerry. I'll take a look at both.

Many thanks PHV! Success.

Thanks Jerry but unfortunately it still errors: "User-defined type not defined" on the first line!

I can't seem to work out the code for launching Outlook from Excel. I want to assign a macro to a button which will open a mail message addressed to me. Excel doen't seem to recognise the commands. My attempt so far: Dim olApp As Outlook.Application Dim olMsg As Outlook.MailItem Dim eglAdd As...

That is good sense Skip. I'm afraid my VBA/Excel knowledge is incredibly basic - I'm pretty much at my limit with what I achieved already! I'll go away and have a think on how to do that though, so thanks for the tip.

PHV - Success! Both your suggestions work. Many thanks indeed. Roel - I found PlotBy when I recorded a macro of making the chart. I run Excel 2003. Interestingly, I pasted in your code and it produced a diagonal line across the chart! I'll try and get it to work when I have time. Many thanks...

PHV, the contents of O2 is a number (1742 currently) that is the result of a count of the number of rows in the columns I'm interested in plotting (G:H) and is put there when a previous macro runs. (Hope that makes sense). This doesn't work: Dim LastRow As Long LastRow =...

Thanks both. Still can't get it to work though! Bob, to define it as an integer I just added: Dim LastRow As Integer Jens, your code doen't cause it to go to the debug and highlight the code in yellow (like mine does) but the chart remains blank. I am using a work around by defining the...

Hi, having defined a term "LastRow" for the value of the last row of data in a column, I tried the following which doesn't seem to work. LastRow = Sheets("Grid_ML").Range("O2").Value Sheets("Print_Sheet").Activate ActiveSheet.ChartObjects("Chart 1").Activate ActiveChart.SeriesCollection.Add...

Brilliant - worked a treat. Thanks Skip