>> Hmmm...that may be my problem...maybe I'm not waiting >long enough...will give it another go and see what happens. >Manual entry is pretty straigtforward haven't had a problem. Yes, it takes a while....it has to search a database of over 36,000 waypoints so it takes a few seconds.>P.S. How is the Lat.Lon. format interpreted ie: >N4800.0W5000.0 or 4850N or N48W50...anyone??? >Neither format....this is what I saw earlier....LAT LONG45.191200 -92.59400045.263700 -91.09180044.555100 -88.19480044.555100 -88.194800

Still a no go. Tried every conceivable combination....even tried one of Eric's original routings that came with PIC. ( KJFKKBOS ) Still can't get it to work. All the other features are working well though. Let's see what Jonesy has to say on the subject. Thanks for the assistance Stiffy. Regards, Nate S..

Ilan,Your pictures were a big help. I have a cable modem and it is constantly on but will not seem to download wx for ABQ which can be found manually at the two provided links.Next, the reason I am having problems importing the flight plans is because I have "NO" import button on my Flight Plan page. (see picture) Are there several versions of this program out there and if so which is the one we are to use? I downloaded it from the links given in this forum.Terry

Good Morning everybody,Thanks for helping while I'm away workingstiff!First of all Nate: Your problem seems to be one of two possible, if I read your post correctly: First one, You do use the "Import FlightPlan" button do you? there is no need to use "copy to flightplan" button when importing, just finalize afterwards.Second possible problem is the RTE format. I made it in brief, so it is still quite primitive. For the import to work correctly the rte file should have limited spaces for example.However You may do the following:press alt+F8, and select "import_fp" from the list.Then press edit button. Now scroll down and find this line:If rowin > 9 Then If .Value = "" Then GoTo stopimreplace the 9 with a 20 to get:If rowin > 20 Then If .Value = "" Then GoTo stopimand close this editor with the X in the window corner.save the excel file (preferably in another name) and go ahead again. it should work now.Now for Terry: I updated this import feature yesterday morning, so you might have downloaded another version. see above links and download excel 2000/xp version (I assume you have one of those don't you?).I am quite busy today, so I'll address more issues later on...Thanks all,Ilan

hey Ilani only got a problem with the import of the flightplanwhen i import a plan, the lat/lon values are 'millions'so to speak, in my setting the "." is NOT alike a ","If i change the "." in the route file(.rte) to ","(lat/lon entries)it works fine.Perhaps you'd need to build in a function that does this automatically?Cheers

Hi Elan-I am sure now that the problem is with some part of visual basic which was loaded when I loaded some other program at home. I tested both versions of the spreadsheet (97 and 2000) On another computer which has the exact same version of office 97 installed. They worked fine. Therefore I'm guessing that the problem is with a single dll that was updated by another program.I even completely uninstalled and reinstalled office 97 on my (flight sim) computer and that did not help. I will attempt to go through all the visualbasic components one at a time and see if I can pin it down. (who knows what else I can break)HarryWWA5513

I can't get the 97 version to load either. Maybe this will help, the missing file in question is VEenLR3.hlp. This file should reside in the c:Program FilesCommon FilesMicrosoft SharedVBA directory. So apparently it is a visual basic problem.I hope someone has a clue. I am using Office 97 Pro on WIN98SE.

To the guys experiencing problems; did you install both the Analysis ToolPak and the Analysis ToolPak - VBA?

Hey Stiffy,How ya doing? I checked and I didn't have the VBA checked so I checked it but no luck, still get the same error. I have VB6 installed on my system so I'm going to check if there is an update for it that will give me the missing file. Btw, I'm assuming at this time that's the only file missing. Thanks for trying.

Thanks Ilan ...that did the trick...all is working well! And may I say this is one handy utility to have hanging around. Will be looking forward to the finished product. Many thanks again to you and the others for all the time and effort you've out into this spreadsheet. Regards, Nate S.

Hi everybody,Having a hard day at work (end of the year ans stuff), so a bit short on time. gimme a day or two...However, to solve the problem Lenny told us about, I think you should do the following:open tools menu and select "macro commands". then highlight the macro called "import_fp", and press edit.find this sequence:.TextFileCommaDelimiter = True.TextFileSpaceDelimiter = False.TextFileColumnDataTypes = Array(1, 1, 1, 1, 1)and add those lines after those:.TextFileDecimalSeparator = ".".TextFileThousandsSeparator = ","to get:.TextFileCommaDelimiter = True.TextFileSpaceDelimiter = False.TextFileColumnDataTypes = Array(1, 1, 1, 1, 1).TextFileDecimalSeparator = ".".TextFileThousandsSeparator = ","This should solve the international settings problem.Will work on the rest later... dead tired now.Bye,Ilan

take it easy Ilan, you can take the time you need... it's a holiday :-)BTW: i added those lines, now the import functions better yet the problem is that i get integer values for lat/lon(eg insted of 39,385494 => 39,00000Cheers

Correct Lenny, I made two mistakes :-)You need to change the followin (again go to the macro and edit it as described above):find these lines:Worksheets("flight plan").Cells(rowin + row1, 2) = Worksheets("flight plan").Cells(rowin, 52).TextWorksheets("flight plan").Cells(rowin + row1, 3) = Worksheets("flight plan").Cells(rowin, 55).TextWorksheets("flight plan").Cells(rowin + row1, 4) = Worksheets("flight plan").Cells(rowin, 56).TextWorksheets("flight plan").Cells(rowin + row1, 25) = Worksheets("flight plan").Cells(rowin, 53).Textand change them to:Worksheets("flight plan").Cells(rowin + row1, 2) = Worksheets("flight plan").Cells(rowin, 52).TextWorksheets("flight plan").Cells(rowin + row1, 3) = Worksheets("flight plan").Cells(rowin, 55).ValueWorksheets("flight plan").Cells(rowin + row1, 4) = Worksheets("flight plan").Cells(rowin, 56).ValueWorksheets("flight plan").Cells(rowin + row1, 25) = Worksheets("flight plan").Cells(rowin, 53).Text(i.e. there are four lines: replace the last word of lines 2 and 3 from "text" to "value" - without the quotes of course).That should do it...Ilan

Hi Lamont I checked my system and have all required checkboxes checked and also have the VEenLR3.hlp file in the right place. Still no-go. I believe the problem is not a missing file but a file that was overwritten by another program which uses VB. It is a common issue the problem is finding the culpritI'll keep lookingHarryWWA5513

Harry i sure hope you can track the prob down as i am not very good with these sorts of issues and its really frustrating not being able to access this program which sounds great. Funny thing is the last version of dispatcher v3.0 works just fine. Please can you keep us informed on your progress.CheersRottnest