vb6

NOTE: Originally posed elsewhere. I do not believe I will get an answer. I hope I can post it here. I have written some code in Sub Workbook_Open. It works fine. However, I am trying to do two more things. 1. I don't know if I should use Workbook_BeforeClose, Workbook_Deactivate, or...

I need some help with a project at work. I need to translate A BUNCH (about 10,000 lines) of old VB6 code into something that will run on modern computers, and I think excel's VBA is the best choice (for IT/security reasons, they won't let me go around installing any sort of VB6 runtimes on our...

I develop an application in VB6 and my data source is Excel 2007. Now, I try to create DataReport. I could connect the excel file to VB. When I click the “Test connection” button in the Data Link Properties I receive the message “Test Connection Succeeded”. To fetch and put the data in the...

<article>Hi Everyone, It's been a long time since I visited this forum. anyway greetings to all. I come across the idea of adding security to excel vba code particularly the addins in which we all know that it can still be easily cracked. Anyhow I don't know the codes and how to make it...

Hey hey Pretty sure I've got all the right references etc, but the following works in Access VBA: Sub TestDump() Dim db as Database Dim LPT as QueryDef, tblDef as TableDef Dim DStmp as string, connstr as String DStmp = Cstr(Format(Now(), "yyyymmdd")) Set db =...

I have a worksheet with a button that links to a form. When i click this i get the 'runtime error 9 - subscript out of range' When i debug it highlights: frmdaily.show in the connected module. This has all worked fine for a number of weeks so I am stumped as to why it would stop now. Even...

Hello, I am currently writing a section of a code that will display the results of a search function from an array. However, I keep encountering an 'invalid qualifier' error. Can someone please let me know why it keeps doing this? Dim Results1() as Variant Dim i1 as Integer Dim NextRow as...

Ok i have a program that goes to a different workbook and copies information. When i try to go back to the original workbook to paste the information, it says that it is out of range... can someone help me fix this? Code: Application.Goto Workbooks(Page).Sheets(Page).Range(CurrentCell) Goes...

After working with VS 2008 and other text/code editors I've found I really enjoy the auto-outline feature (i.e. expand/collapse code). Does such an add-on exist for VB6 IDE?

i have a listbox in my vb6 program with file paths of all employees i made all enployee files with my xl template that's why cell names are same like empname, ampdesg(employee designation), tcustomer, tvisit, and tarea etc. Then i make a master xl sheet in which i named some cells like emp1name...