Dang Hypens

jaustin

I'm attempting to write a visual basic script that will export certain NAV data onto an MS Excel Worksheet. My issue is with the Item Cross Reference field "Cross-Reference Type No.". When try to write the code in VB it thinks the hypen is a minus sign and automatically changes the code to include spaces before and after they hypen.

I know this really isn't a NAV issue but I'm not finding any help on the web in the Microsoft areana. Any Idea's?

XrefTypeNo = RTrim(IIf(IsNull(rsXref!Cross - Reference_Type_No_), "", rsXref!Cross - Reference_Type_No_))

Thanks,

Savatage

jaustin wrote:

I'm attempting to write a visual basic script that will export certain NAV data onto an MS Excel Worksheet.

Why not use the excel buffer to export info from Nav to excel?

Savatage

Like This..
http://savatage99.googlepages.com/50092 ... oExcel.fob

Even add Item.GET("Item No.");
to pull info off the item table what's relevent (if needed)

It's not as fast as a dataport but it's done in one step.