Edit In Excel - Part 4 (out of 4)

re: Edit In Excel - Part 4 (out of 4)

waldo1001 — Mon, 10 Nov 2008 19:01:59 GMT

Hi Freddy. Thanks for your effort in explaining this. The functionality looks simple, but it really isn't when diving into it. Or may be it's just me ;-).

Anyway, one thing I came accross. I changed the language settings on my VPC to Dutch(Belgium). This causes an issue when using the excel template solution from within the RTC. You can either install the language packs for office (in my case Dutch (Belgium)) or switch back to the original language (English (US)) to solve it... .

The way to see the error is to remove the try..catch in the NAVEditInExcel class.

re: Edit In Excel - Part 4 (out of 4)

waldo1001 — Mon, 10 Nov 2008 19:53:56 GMT

I added one extra line in the OnPush of the Action to make it like this:

CREATE(NAVEditInExcel, TRUE, TRUE);

NAVEditInExcel.EditInExcel(TABLENAME, GETVIEW(TRUE));

CLEAR(NAVEditInExcel);

This way, you're able to push "Edit in Excel" more than one without leaving the customer list.

re: Edit In Excel - Part 4 (out of 4)

Tronholm — Mon, 15 Dec 2008 18:07:52 GMT

Hi, I've been trying some alternative ways w/o web services, using standard table 370 Excel Buffer. It works fine in 2009 Classic Client, but I get an error "Excel not found" (when running CREATE(XlApp,TRUE,TRUE). ¿Any hint?

re: Edit In Excel - Part 4 (out of 4)

freddyk — Mon, 15 Dec 2008 22:14:36 GMT

I haven't tried playing around with that - you probably should post a question like this on Mibuso

re: Edit In Excel - Part 4 (out of 4)

Tronholm — Thu, 18 Dec 2008 11:28:02 GMT

Actually I was troubled and mibuso was the answer. This might be useful for other people:

http://www.mibuso.com/forum/viewtopic.php?f=32&t=30539&p=148549#p148549

Thanks.

re: Edit In Excel - Part 4 (out of 4)

rtaranti — Thu, 19 Mar 2009 20:57:16 GMT

Greetings Freddie. I know deployment is not part of your dicussison, but I was wondering if anyone ws having problems using VS 2008 on a Vista machine to package the solution up and deploy it to other PC's? I am getting the message, "WARNING: Unable to create registration information for file named 'NAVEditInExcel.tlb'" when building the deplyment project. It seems to complete without any issue, and it deploys fine, but the com is not visible in NAV globals on the deployed to machine (PC). I suspect the message might be the reason? If anyone knows the reason why the com is not visible please let me know.

Best Regards,

Robert

re: Edit In Excel - Part 4 (out of 4)

freddyk — Thu, 19 Mar 2009 21:30:28 GMT

You need to run the regasm command on any machine wanting to use the COM automation object.

You can see the command as post build event on the NAVEditInExcel project.

This is always required to make a COM object visible on a machine.

re: Edit In Excel - Part 4 (out of 4)

rtaranti — Thu, 19 Mar 2009 21:48:53 GMT

Interesting, and yes thats works :). I never had to this problem when compiling my projects on an XP box with VS 2005 or 2008...strange.

Do recommend we create a deployment action to make this call in our msi? Would that work since the VS command prompt which intalls regasm, I believe, would not be on my client machines?

I have scene quite a few posts out there on this, but know has a clean solution. Bummer. Well, thank you once again.

Best Regards,

Robert

re: Edit In Excel - Part 4 (out of 4)

freddyk — Thu, 19 Mar 2009 21:56:25 GMT

regasm is part of .net - not VS - run

C:\Windows\Microsoft.NET\Framework\v2.0.50727\regasm <dll> /codebase /tlb

in your msi.

re: Edit In Excel - Part 4 (out of 4)

rtaranti — Thu, 19 Mar 2009 22:42:03 GMT

Lets just say I am feeling sheepish from my last post. Thanks for taking it easy one me, I should have known that. :)

Regards,

Robert