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 Chriss Miller 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
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;" &...- dac5039
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
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
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...- dac5039
- Post #3
- Forum: Microsoft: Office
-
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
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 -
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
-
Access Violation while attempting to Sort Allocatable Array...
Can you recommend a debugger for g95 in Windows? -
Program Runtime Problem after Modulizing
...= runs(midpoint) yrstats(updown,year,1) = totalcount yrstats(updown,year,2) = totalrun yrstats(updown,year,3) = mean yrstats(updown,year,4) = median end do end do write(*,fmt='(1XI4,1XI1,1XF3.0,1Xf4.0,1XF6.4,1XF2.0)') yrstats(:,:,1:4) end subroutine... -
Access Violation while attempting to Sort Allocatable Array...
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. -
Access Violation while attempting to Sort Allocatable Array...
...do i = 1, k-1 imin = rlens(i) iminp = i do q = i+1, k if(rlens(q) < imin) then imin = rlens(q) iminp = q end if end do t = rlens(i) rlens(i) = rlens(iminp) rlens(iminp) = t end do write(*,*) rlens end do... -
Access Violation while attempting to Sort Allocatable Array...
Sorry... The first link, unbroken: http://www.personal.psu.edu/dac5039/496/sorting/ -
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
I'm pained by my oversight haha. Thank you for the help. -
Problems storing variable values within nested if loop
Here ya gohttps://explorer.pass.psu.edu/PASSViewFile.cgi?file=rescraped_trend_space.txt&start=/pass/users/d/a/dac5039/www -
Problems storing variable values within nested if loop
Sorry, the comma messed up the link to my code. intact link is attached below.http://www.personal.psu.edu/dac5039/allruns.f95 -
Problems storing variable values within nested if loop
...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 Definition*** module my_temps type temps integer :: dates, hi, lo, av real :: hinorms, lonorms end type temps contains... -
Declaring a DT Array of Variable Length
mikrom, This was extremely clear and helpful, thank you! -
-
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...
