Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
VBA Script Needs to Locate File in CWD
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...- dac5039
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Local Text File Reading in Excel
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...- dac5039
- Thread
- Replies: 3
- Forum: Microsoft: Office
-
Program Fails after Changing Input File
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 -
Automatic Export of Excel Charts using User Add-In
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...- dac5039
- Thread
- Replies: 1
- Forum: Microsoft: Office
-
Program Runtime Problem after Modulizing
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... -
Access Violation while attempting to Sort Allocatable Array...
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... -
Problems storing variable values within nested if loop
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... -
Determining Longest Stretch of Occurances
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... -
Declaring a DT Array of Variable Length
I have a data file containing over 100 years of high, low, and average temperature data which I want to read-in and assign to variables of ddt "temps." type temps integer :: dates, hi, lo, av end type temps So each date will have the three temperature values assigned to it for...
