Tekito

This is an issue that I've discusses many times before, but never with a conclusive solution. I am trying to programmatically change the data range for an existing chart in Excel. My code goes something like this: [CODE] With WS.CharObjects(SelChart).Chart With .SeriesCollection(1) .XValues =DataWS.Range("A1:A101") '<-----ERROR! .Values = DataWS.Range("B1:B101") End With …

I am new to Visual Basic 6 Class Modules and am having difficulty constructing a certain class. First off, I created a simple class, which is basically an array with some basic properties (Sum, etc). Next off, I want to create another class, which has these arrays as properties. As …

I'm about to write a new program in Visual Basic. I have Visual Studio 6.0, but it's limitations are starting to become a problem and I'm wondering about trying Visual Studio 2008 Express (unfortunately purchasing the full version is not an option). I would hate to get halfway through and …

I want to show some information to the user in a nonmodal form. Basically just like a message box (doesn't even need buttons) except nonmodal (and doesn't beep). I could probably create a form from scratch, but I would think this type of form already exists somewhere in .net??

I'm new to datasets, and trying to update a SQL Server database with one. I'm having trouble understanding how to correctly write the dataset info to the server db and preserve the relationship keys. When I write to the main table in the server database, it will assign the new …

I need to display a DAG (directed acyclic graph), which is basically a Treeview, except children can have multiple parents. Any clue on a control or method to implement this in Visual Basic 2008?

I'm not quite sure how to tackle this problem. I have a form that displays the properties of a class. I have events for all the properties so the form gets updated automatically when the properties change. However, upon initializing a class, these events do not get called, and so …

I'm trying to write a program in VB2008 that uses a 2003 Excel spreadsheet as the interface. To help with this I am trying to pass data to and from macros inside the spreadsheet. I call a macro from VB with this line: [CODE] Call gXLApp.Run(gwbTB.Name & "!ArrGather", gArr) [/CODE] …

There a lot of times in my program where I have large arrays of data and I would like to use the power of SQL commands (SUM, GROUP BY, INNER JOIN, ORDER BY) on this information. It is a great tool when you are doing anything beyond the most basic …

(I'm using VBA with Excel 2003, have references to OLE Automation and Microsoft Common Controls 6.0). The Hittest with my Treeview control does not seem to be working. I'm using it in a MouseDown event. The X and Y coordinates are being passed properly and are the correct values, but …

Most of my Visual Basic 6 experience comes from VBA with Excel. With VBExcel, you can run any procedure (if it does not require input parameters) by simply putting your cursor in the sub and clicking the "play button" (F5) . With full VB6, the same action will not just …

I have a routine that, at one step, calls a form and shows it modal. When the user closes the form the routine continues. However, upon closing the form I want to know if it performed its assigned function- if it failed then I need to stop the routine. However, …

I have created a class module, and my program creates many instances of the class. Each object has a lot of data, and I want to be able to create a new instance that is a copy of an existing instance. I can't figure out a automatic way to do …

As I learn class modules, one issue that seems to come up repeatedly involves class modules inside class modules - how the "child" class module can never see anything inside the "parent". Say, for example, I'm writing a program involving a card game, and so I have a class module …

This involves an Excel file that is being controlled by another program. I have written my own excel file with vba that works with this Excel file. So basically, the program opens up an excel file, then the user opens up my excel file in the same instance of the …

I'm actually having this problem with the Deactivate and QueryUnload events as well. From my reading I think the Unload event is supposed to fire when you close a form with the close button or with the unload command. So far neither has happened. With the statement: [QUOTE]Unload UserForm1[/QUOTE] the …

I'm new to class modules, and the compiler seems to be enforcing a correlation of the number of input vars for a Get and Let procedure of the same property. The Let property must always have exactly one more variable (the NewValue) than the Get procedure. So the code I've …

I want an embedded listbox (with headers) on my excel spreadsheet, that references a range on the worksheet. So using the ControlBox Toolbar I created a listbox. First thing I noticed is that there is no RowSource property appearing for this listbox. So I tried to enter the range using …

Is there a quick way to pass numerical arrays between two VB6 programs? Currently I am dumping the data from one program into an Access Db, then the other one reads it. However, speed is very critical and this is a little slower than I would like. The arrays are …

I have an app in VB w/ Excel that uses the Microsoft Solver feature. In order to ensure functionality of the Solver I run the line: Application.Run ("Solver.xla!Auto_Open") when starting up the program. I have now discovered that for some reason, after running this line, a listbox (that is totally …

I'm writing an app in VB with an excel worksheet. At one point I need to solve a set of equations that are not explicit, so I need a numerical solver program. Excel's Solver is supposedly designed for this purpose; however my past experience is that it is very fickle …

At one point in my program, if there is an error I need to show a customized form that allows the user to make necessary changes to some data. The code needs to be paused until the user is finished and closes the form. In Access, it is very easy …

I'm trying get a form to pop-up in an excel sheet that awaits the user's input before resuming execution (basically like a message box, only more customized). I've done it before with Access but am having difficulty finding a similar option in VBExcel. If you just show a form the …

Recently I was trying to execute a "SELECT...INTO" query (for an Access db) w/ VB in an Excel macro. Kept getting an error message, so I changed it to just a SELECT query and got "Cannot execute a select query." So is it impossible to execute select queries in VB-excel? …