Search results for query: *

SkipVought, thanks for your input. After inserting your code to test out, my script still cannot find the file..? Sub read() 'read Macro 'Keyboard Shortcut: Ctrl+Shift+R ' Dim sPath As String, sDB As String, sConn As String sPath = ThisWorkbook.Path sDB = "yearly_stats.txt" sConn = "TEXT;" &...

What my VBA script does is get external text data and store it in the first few columns. Then this data is used to create several graphs which are exported as .png images. The problem is that I need to be able to pass my Perl, Fortran, and VBA scripts to another machine within a folder, have...

macropod, thank you for your input. I will move this post on to the VBA forum. In response to your answer, I'm confused by what you mean exactly, so I want to explain my problem a bit better. What my VBA script does is get external text data and store it in the first few columns. Then this...

A text file is created in the same directory as my .mxls file, which I want to be automatically read-in upon opening. How do I specify the location of the file without using an absolute path (I want to be able to send a folder with the excel file and the text file to another machine)? Thanks...

Hey Gerrit, Maybe fail was the wrong word.. Both scripts run without crashing. However, once the 'ifinal.f95' script is finished, the results are all zero (incorrect). Strange, since I've only altered the data file name. Thanks, Dave

Hello, The two attached .f95 scripts are identical, except for the data file which is read-in. I would really love it if someone could tell me why the 'ifinal.f95' scripts fails to produce results..? Thanks, Dave

Hello, I need to automatically export three charts as .png files and save them somewhere on my machine. I found a user-made add-in here that can save excel charts as images to any location, but I can't seem to code a module that automatically does this for 3 charts... What I did was install...

Can you recommend a debugger for g95 in Windows?

Hello, The code outlined below is a section I put into a subroutine to clear up my flow a little bit. The problem is, the prgram stalls once it calls the subroutine and never prints out the output I need (after about 20 minutes at least). The block worked fine when I had it within another...

mikrom, Thanks for the input. I was getting an error at line 100, back by where I allocate rlens, so that's why I wasn't able to find the problem.

Hi mikrom, It's within the "high_norm_runs" subroutine: do j = 0, 1 do p = 1926, 2009 rcount = 0 do i = 1, 185 rlens(i) = 0 end do do m = 1, k if(allruns(m,1) == p .AND. allruns(m,3) == j) then rcount = rcount + 1 rlens(rcount) =...

Sorry... The first link, unbroken: http://www.personal.psu.edu/dac5039/496/sorting/

The attached .f95 code does a range of statistical manipulations to a large data set. The program had successfully deduced all instances of x > threshold and x < threshold for each of the 42,000+ instances and written them to file. The specific application is daily high temperatures exceeding or...

I'm pained by my oversight haha. Thank you for the help.

Here ya gohttps://explorer.pass.psu.edu/PASSViewFile.cgi?file=rescraped_trend_space.txt&start=/pass/users/d/a/dac5039/www

Sorry, the comma messed up the link to my code. intact link is attached below.http://www.personal.psu.edu/dac5039/allruns.f95

Hello, The subroutine below receives an array of derived type data and uses the data within to run logical tests. I've been successful in writing the results to a text file, but am unable to store them in an array within the subroutine and print it to the terminal. ***Derived Type...

mikrom, This was extremely clear and helpful, thank you!

yes

I was looking for some advice on the best method for the following problem: I have three arrays of equal length... One of dates, of of high temperatures and one of normal temperatures. The goal is to find the longest stretch of days in which high temp > normal temp, and also the longest stretch...