Search results for query: *

Was hoping someone could help. Have been using Excel vba which is linked to Fortran functions within a dll for some time now. However, I can't get it to work with subroutines which have more than 2 variables that are to be passed back. Any suggestions? A simple example would be much...

Don't worry - have sorted it. For some reason excel is happy when it's one dynamically ranged column, rather than a set of ranged cells. Bizarre.

Hi, Was wondering if anyone has any ideas. I've set up a spreadsheet with a load of monthly data, with the plan being that say, for example, in the month of January, a pie chart will show the breakdown of data for, you've guessed it - January. The ranging works fine, and I keep trying to set...

Geoff, have a small shiny thing for your first post, but Glenn, thanks to you as well for your speedy post. Have a shiny thing as well! Cheers, BFG

if possible, I really would appreciate some help with the following: I've got a shared computer (Win XP) that is connected to B/band, all on one login. When IE loads, it has started linking to a file called 'secure.html' in the windows directory. Have tried resetting the homepage (it gets set...

OK, one final question, Using that result e.g. H5, how could you then use that to form an array of the form B5:H5? I.e. use the result as part of the array reference? Cheers for this.

xlbo, Genius!! Thanks.

Oh, and I should have said..... no VBA!! ;-)

Here's a challenge (or maybe not) for you LOOKUP experts out there..... Say you've got a table of data of the form: Item 1 2 3 4 5 6 7 8 Data 1 2 12 7 6 3 4 9 4 Data 2 1 11 6 3 2 2 9 4 Data 3 2 3 9 7 1 6 9...

Hi matasapos, The way I understand it, once VF has compiled your functions into a dll, all aspects of Fortran & compiling disappear, and basically Excel/VBA just enters the dll via the entry point that you specified in the original Fortran code i.e.: !DEC$ ATTRIBUTES DLLEXPORT :: GetPI...

Matasapos, See the following thread, this gives you the information you need to call the *.dll from Excel, which is what I needed to do. thread214-465832 Good luck! Drop a reply if you continue to have trouble. That thread, plus setting the VF compiler to Release was all I needed to get it...

Everyone, Thanks for your replies. Tony apologies, I tried it again, after sending that post and it worked fine, however still quite slowly (but better than what I had first of all) :-) However, a star must go to Rob and Combo, as using Robs technique is mega fast and I then combined this...

Tony, Nice idea, but when selecting rows that are visible, it also selects the rows that have been 'hidden' by the filter, so you would in theory delete all the data present. Or have I got the wrong end of the stick? Cheers. BFG

Combo, Thanks for your quick reply - and looks like just what I need. Unfortunately not having much success, most probably due to my lack of understanding!! I've put it into a sub, and when run it comes up with 'Compile error, variable not defined' and points at "firstaddress =" on...

I have an Excel spreadsheet with over 2000 rows of data and need to delete any rows that contain a 'x' in a certain column (approximately 2 in every 7). At the moment am looping through from the end of the data but it is sooooo slooooooooooow :-( Anybody got any better methods? I've switched...

Cancel that - think I've sorted it. Thanks to anyone that took the time to read my post though

Hi everyone, Having a bit of a nightmare - any help would be much appreciated. I'm still learning VBA, and have hit a bit of a brick wall I've got 2 columns of data in column A and G for example. (Columns B-F are filled with other data) Column A is full of sequential dates & times and G is...

Hi to whoever reads this.... I've got an HD which has crashed (30Gb) losing a lot of useful stuff (although I did have most essential stuff backed-up). When I've experienced disk crashes in the past, the disks haven't spun up, but they still get detected in the computer BIOS. However, this...

Have found the issue - it was faily basic. The Fortran compiler needs to be set to 'Release' compilation rather than 'Debug'

Did think that, and yes you're right - there are a few dlls the fortran needs. I've copied those both at work and on my home computer into the required directory but without success. Sorry - should have said that in my post!! Thanks for the suggestion.