Jump to content
TUFLOW Forum
nickbartho

Trouble plotting longsections running Vista and Excel 2007

Recommended Posts

Has anyone else had problems getting the longsection tool to work running Vista and Excel 2007?

No trouble at all getting this to work on our XP machines but the script bombs on Vista on an "unexpected error 641". This is after it has created and completed the Long_Section_Plot and Long_Section_Plot_Pnts files and after getting past the prompt re Excel and needing to enable macros.

Thinking it was an issue with Vista's security settings (along with pretty much every other piece of software we have), we have tried quite a few combinations running Excel as an administrator, with full rights, in XP compatibility mode, different macro security settings etc but to no avail...any ideas would be much appreciated!

Share this post


Link to post
Share on other sites

Has anyone else had problems getting the longsection tool to work running Vista and Excel 2007?

No trouble at all getting this to work on our XP machines but the script bombs on Vista on an "unexpected error 641". This is after it has created and completed the Long_Section_Plot and Long_Section_Plot_Pnts files and after getting past the prompt re Excel and needing to enable macros.

Thinking it was an issue with Vista's security settings (along with pretty much every other piece of software we have), we have tried quite a few combinations running Excel as an administrator, with full rights, in XP compatibility mode, different macro security settings etc but to no avail...any ideas would be much appreciated!

Share this post


Link to post
Share on other sites

Hi Nick,

Unfortunately you may be the first to experience the problem. I wrote the code, so if you can help me, I'll try to resolve the problem.

It's probably one of two things. It's most likely an issue with the 'DDE' style communication that occurs between MapInfo (MapBaic) and Excel. If this is the issue, Excel will open but no data will be written to the spreadsheet. Is this where it crashes?

The other (less likely cause) is that the macros in the spreadsheet use an object that is no longer supported in Excel 2007. If possible, please test it using Excel2003 on Vista. This will help resolve whether it's an Excel 2007 or Vista issue.

Try doing this, and let me know.

Cheers,

Mick

Share this post


Link to post
Share on other sites

Sorry Nick, one last thing to try. There are a number of 'hotfixes' available from Microsoft, including one for Excel2007. While the Excel hotfix solves one specific issue (completely unrelated to the problem you've experienced), installing it seems to have fixed a whole lot of stability issues on other peoples machines.

Cheers,

Mick

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...