SEARCH YOUR SOLUTION HERE  

What works and what doesn't with RB 2005 on Mac?

Downloaded the demo today and copied my plugins to test out some of my projects with it: the application abrubtly quit (without a warning or error message). Removing the plugins got it working. Tried to run a project, and all ...

Posted On: Saturday 10th of November 2012 05:29:27 AM Total Views:  174
View Complete with Replies




Related Messages:

Matching data in 2 worksheets   (113 Views)
Hi I was wondering if there is a function that would allow me to match data in two different worksheets. To make it more clear I have a list of products with prices for the company in one worksheet. In ...
Display results on Excel form, swithc macros with worksheet and so on   (219 Views)
I am a new comer here and my problem may sound simple for many of you. I built a form to put 5 list boxes to get user inputs. I want to display the calculated result in the same ...
Source code to add a right-click item that works with both firefox and internet explorer   (297 Views)
Okay, maybe I'm just not looking hard enough, but I could really use some source code. I found some that works with IE, but I want to be able to do the same with firefox if possible. I know I ...
Accessing newly created worksheet in Excel   (284 Views)
Hi all, I've created a workbook to play a game with my friends. Each time I insert results a new worksheet should be created (which happens) and then this worksheet should be activated. I'm fairly new to VBA but have ...
open wordfile from vb works only once.   (212 Views)
Hi all, I use following code to open a wordfile from VB but it works only the first time. Second time I try to open word I get only an empty Word-screen.... Private Sub cmdRetrieveDoc_Click() Dim objWord As Object Dim ...
[VB2005] generate new worksheet for new text file   (367 Views)
I am having problem opening multiple textfiles to multiple worksheets in excel. so far, if i have multiple textfiles selected, it will onl open one worksheet in excel of last file. firstfile = ListBox1.Items(0).ToString firstpath = System.IO.Path.GetFullPath(firstfile & ".txt") WExcel = New Microsoft.Office.Interop.Excel.ApplicationClass WBook = WExcel.Workbooks.Open(firstpath) WBook = WExcel.ActiveWorkbook How do i add the code that can add new worksheet to accomodate new file open
Importing a workbook with multiple worksheets to access   (168 Views)
So I have an excel workbook with multiple worksheets. I am trying to open it and import to access. I'm not quite sure how to do this. Would I open the workbook as an object If so I don't really know where to go from there. Or is there another way I can do this I don't really have any code yet because I'm not quite sure where to start. I googled it but it came back with a lot of SQL stuff and that's not really the direction I want to take with this. If anyone has any good reading material, I would really appreciate it!
VB6 and access 2000. query works in access but gets error in VB   (201 Views)
I have created the query using one of the wizards in Access and it works. Formatted the query to use in a VB 6 project. However when I run it in VB I receive the following error run-time error '-2147467259' ...
Reading an Excel worksheet using ODBC from VB.NET   (136 Views)
How do I access an Excel Workbook from VB .NET using the ODBC driver I want to read Excel data into a DataGrid control on a web-page. Although ODBC says it can connect to Excel, it then asks me to ...
Program works in design mode but not after compilation, Any ideas?   (376 Views)
VB6 windows XP home I run a small app that has no forms in it, only a few BAS modules. It's function is to open a text file and load a few pieces of data into memory and then periodically ...
Access Autonumber works from VB with no code!   (132 Views)
I was informed by many-a-person that the Access autonumber is only going to work if you're adding records from within the Access environment. However, a test program I just made has disproved this. Using the ADO control, a DataGrid, and ...
How do I insert a specific worksheet using VB?   (248 Views)
, I need to insert specific Excel worksheets in one workbook into Word. I believe this should be straightforward, but I cannot find (or figure out on my own) how to reference the worksheet. Right now I have... Sub InsertSheet() ...
new web app development tool in the works   (329 Views)
I've found out something exciting, and I've been just dying to tell somebody... but I have to do it anonymously or I'd be in big troubel. I just found this Google group, I hope it's the right place for this ...
Re: Use of DLL in VB6 works fine, but I want to learn something and try to get the intellisense of the DLL   (280 Views)
thanks again for the answer. Also thanks for pointing me to the other newsgroup, in which I post this answer too, tranferring it to it's right place. I have tried your solution before, but because I was not such ...
ADO fails on ActiveX-EXE while works in ActiveX-DLL   (115 Views)
. I have a problem: A class returning an ADODB.Recordset in an ActiveX-DLL works fine. If I convert the DLL to an ActiveX-EXE server then the recordset behaves extrange.
Reading an Excel worksheet using ODBC from VB.NET   (192 Views)
How do I access an Excel Workbook from VB .NET using the ODBC driver I want to read Excel data into a DataGrid control on a web-page. Although ODBC says it can connect to Excel, it then asks me to ...
dbEncrypt doesn't works with DAO 3.51   (316 Views)
My app uses DAO 3.51 and I wanted to encrypt my database with CompactDatabase using the dbEncrypt option but it doesn't work. It didn't show any errors but the database is still readable in a text viewer. So I ...
Reference last worksheet in excel workbook in VB code   (438 Views)
I am tring to get the name of the last sheet in a workbook but have obviously got my syntax wrong somewhere - this is what I am using; If Worksheet.Name(Worksheets.Count) = "Jan" Then this gives an 'object required' error ...
Setting .ActiveConnection fails w/Com Services but works with REGSVR32   (295 Views)
Since Microsoft says they won't support my question since VB6 is no longer supported, I'm re-posting a digest version of what I posted there with a bit more clarity. I'm hoping someone can make suggestions which can bail me out here without requiring me to re-code the entire application which was not mine to start with. If you'd like to see my original post to Microsoft, please see my Microsoft post. -------------------------------------------------------------------------------- I'm currently in the process of migrating applications from a Windows 2000 server to a Server 2003 or 2008 system because of corporate mandate. Because of the number of changes between Server 2000 and Server 2008, I am opting to migrate only as far as 2003 at this point. General Setup Application uses a Classic ASP web-based front-end which instantiates VB6 DLL objects contained in an application-specific Component Services package which activates under the login context of a domain account. The DLLs connect to a SQL 2008 data source hosted on a Server 2008 system. Problem On our current Server 2000 system where the Classic ASP and Component Services is set up, all works fine. When attempting to set this up the same way on our Server 2003 system, a connection to the database will not work unless the DLL is activated outside of Component Services (i.e. Registered ONLY through REGSVR32). We cannot operate the data component outside of Component Services because some features need to use transactions and Component Service roles to function. Symptoms When the DLL is contained within a Component Services application, the following error occurs: Err.number = 3001 Err.Source = ADODB.Command Err.Description = Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. Err.HelpContext = 1240641 Err.helpfile = C:\Windows\HELP\ADO270.CHM When the DLL is registed by ONLY using REGSVR32 (and is not contained in Component Services), this works. Where Problems Occur Below are relevant code snippets for both my calling Classic ASP page and the DLL's method code which is being executed. Bear in mind, setting the .ActiveConnection works when I register this using REGSVR32, but if I include this in a Component Services package, it fails. Classic ASP code: Set Login = Server.CreateObject("MyLogin.NTLogin") ' Removed irrelevant Login object properties which are set Set cn = Server.CreateObject("ADODB.Connection") cn.ConnectionString = strMyConnectionString cn.Open If Err.number 0 Then Response.Write ("Error opening database") Response.End Else ' In this ASP page, this is where things fail: MyLogin.GetUserInfo cn End If Affected DLL Object code (Found within MyLogin project, NTLogin module): Public Sub GetUserInfo(ByVal cn As Variant) ' (Irrelevant code removed) Dim cmd As Command Set cmd = New Command With cmd ' The next line is where it blows up (when in Component Services) ' or works (when simply registered with REGSVR32): .ActiveConnection = cn Things I Have Tried Thinking there may have been references to MDAC 2.5 which needed updating to MDAC 2.8, I recompiled the DLLs.Component Services on my Server 2003 system have had COM Security set up to allow Access and Launch permissions for all accounts I'm using (both Classic ASP users, impersonated Component Service user) Things I Know When the DLL is in Component Services, no connection attempt is even made. When registed using REGSVR32, it does connect and retreive data. This was verified using SQL Server Profiler which I used to monitor all connection activity.Failure happens when we set the .ActiveConnection to the Variant "cn" which is passed from ASP code.Do you have any advice or suggestions Am I missing something here Thank you! -Chris
VBA/Excel - Looping through worksheets doesn't include last sheet   (441 Views)
EXCEL 2007/VBA: Good evening, all. I have a sub that loops through all the worksheets in a workbook that contains many sheets of data. The sub first creates a new, blank sheet, then it loops through all remaining sheets to copy the data and paste it into the new sheet. It works for all but the last sheet. No matter how many sheets I try, it always stops short of that last sheet. The code: Sub CopyPasta() Application.ScreenUpdating = False Worksheets.Add(Before:=Worksheets(1)).Name = "Data Sheet" Dim i As Integer For i = 1 To ActiveWorkbook.Worksheets.Count If Worksheets(i).Name "Data Sheet" Then Range("A2").Select Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select Selection.Copy Worksheets("Data Sheet").Activate Range("A1048576").End(xlUp).Offset(1, 0).PasteSpecial Application.CutCopyMode = False Worksheets(i).Activate End If Next i Worksheets("Data Sheet").Activate Rows("1").EntireRow.Delete Range("A1").Select Application.ScreenUpdating = True End Sub What am I missing