Hello VB Folks, and friends,
I'd like to try to open an Excel spreadsheet which is a matrix table of fares.
I need to perform a VLOOKUP on 2 parameters passed from 2 textboxes, or two lists. (one is coming from, and one is going to)...
Then I need to close the file, and show the answer(result) in another textbox.
Is this something that can be done without buying Visual Tools For Office
Thanks...I hope this is enough description for all of you. If not, say the word...any word!
OPen Excel file to perform a VLOOKUP and close
Sniper167
Omogha
Thanks...If you look above you'll see it was Renee who moved this message here. I too did not know where to post it...But she is sweet for trying to do the right thing.
Thanks to both of you. I will attempt to do this a little later.
By the way Renee, I crashed your app by trying to rename the main cat...here's the error:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.ArgumentException: TableName is required when it is part of a DataSet.
at System.Data.DataTable.set_TableName(String value)
at KyraSoft.Common.CloseDatabase()
at KyraSoft.IOSUBS.RenameSubCategory(String table, Int32 level, String SubCategory, String NewSubCategory)
at KyraSoft.IOSUBS.ControlsRename(LvElementDesc LVDesc, String NewName)
at KyraSoft.Form1.Tvc_AfterLabelEdit(Object sender, NodeLabelEditEventArgs e)
at System.Windows.Forms.TreeView.OnAfterLabelEdit(NodeLabelEditEventArgs e)
at System.Windows.Forms.TreeView.TvnEndLabelEdit(NMTVDISPINFO nmtvdi)
at System.Windows.Forms.TreeView.WmNotify(Message& m)
at System.Windows.Forms.TreeView.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
KnowledgeNavigator
Assembly Version: 1.0.5.0
Win32 Version: 1.0.5.0
CodeBase: file:///C:/Program%20Files/KyraSoft/KnowledgeNavigator/KnowledgeNavigator.exe
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 2.0.0.1
Win32 Version: 8.0.50926.00 built by: (TLIANG05-tliang)
CodeBase: file:///C:/Program%20Files/KyraSoft/KnowledgeNavigator/Microsoft.VisualBasic.DLL
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Runtime.Remoting
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
Interop.Scripting
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/KyraSoft/KnowledgeNavigator/Interop.Scripting.DLL
----------------------------------------
Microsoft.mshtml
Assembly Version: 7.0.3300.0
Win32 Version: 7.0.3300.0
CodeBase: file:///C:/WINNT/assembly/GAC/Microsoft.mshtml/7.0.3300.0__b03f5f7f11d50a3a/Microsoft.mshtml.dll
----------------------------------------
Interop.ADODB
Assembly Version: 2.8.0.0
Win32 Version: 2.8.0.0
CodeBase: file:///C:/Program%20Files/KyraSoft/KnowledgeNavigator/Interop.ADODB.DLL
----------------------------------------
Interop.ADOX
Assembly Version: 2.8.0.0
Win32 Version: 2.8.0.0
CodeBase: file:///C:/Program%20Files/KyraSoft/KnowledgeNavigator/Interop.ADOX.DLL
----------------------------------------
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
Thanks...see ya later
Elgee
halosome
Elgee,
In a few minutes, I'm going to move this to the VSTO Forum.
(Visual Studio Tools for Office)
MaggieC
The Answer is yes, this can be done without buying Visual Studio Tools for Office.
It can also be done with buying
You would use the Excel Object Model to do this so you there is no specific need to use VSTO for that.
It is helpful to remember that this forum is mainly for issues that directly pertain to the Visual Studio Tools for Office tools per se. So you will be best served by posing this question to the forum or newsgroup wholly dedicated to Excel issues such as this one. Here you will find resources you should consult for best results.
Excel newsgroups:
microsoft.public.excel.programming
microsoft.public.excel.worksheet.functions
-= Maarten =-