[vba] Forum Topics

I've got a funky situation here that I think a script could solve, but I'm no good at scripting Excel, so there! It's Excel 2007 btw. My online store exports a CSV of orders along with the line items of the order. To accomplish this, it outputs one row as …

Hi everyone, I am new to this board. I am trying to figure out how to set up an SQL statement to grab a record from a database when I'm not sure what column/field the string I am looking for will be in. for instance: I am looking for "ABCDEFG", …

I think the title says most of it. How do I, in MS Access using VBA, get information from a workbook which I can then put in as a recordset in a table? I know that excel has an easy workaround for other excel workbooks, and I've read somewhere how …

What is the fasted way to delete rows based on a condition in Column A using VBA? Anybody have an example? Thanks.

I'm using VBA to query and modify an Excel database. The database contains information about servers and their locations. Most of the rack mount servers have the location column as something like "G-05". Those are easy. When it comes to the blade servers, the locations are listed as "G-05E2S09" or …

I have a small company Database that tracks our repair orders. I have a query that I would like to execute based on criteria that the user inputs. I am new to VBA so most of my code is based on google research. I took a technique of wrapping my …

Hi all, I have designed an application in MS Access 2007 that will be used in some schools (over 60 schools). Each time I start the application, it shows an alert in the message bar that the VBA macros are disabled, and gives me the option to enable it for …

I am programing VBA for excel and was wondering if anyone knows where I can fidn the documentation for the selection object. Also do you know how I can get the VB editor to recognize thet object so when I type Selection and put the period after it, it pops …

Hello I have a problem with my vba collection object. When I run the code below I get the "out of stack space (error 28)" message. It seems to me that my collection shouldnt take up so much memory as the each object in it is just a set of …

Hi there, I am a Microsoft Word developer and I sell Microsoft Office solutions, to companies. I am beginning to be concerned that my solutions are being copied - which is fairly easy. I am hoping someone can give me some advice about the best way to do this. I …

I am trying to develop a subroutine that will send an IM to a user. The idea being if the user is online, the code sends an IM to the user via communicator. If the user is offline, it sends an email. The code does work, in that it does …

Greetings, I have been cracking my skull all weekend trying to find a solution to this, and I have no idea how to search as I'm not sure what to search for (I have performed a search, but it didn't show what I was looking for, hence, the post). I …

Hi, Im new to VB, but and pretty famliar with python. I have some code I need to change from python to VB, to run in an access database. Problem I am running into is I can't slice up my string as I need to. [code=vba] someString = '12ABC1234512345' numberString …

I do hope this is the right section (since VBA is so close to VB 6.0). Well here is my dilemma: I am trying to have Access return a customized report. The format I have been asked for it to be output as it the following: Machine type // where …

First of all I know this has been asked several times before but I cannot get mine to work. Anyway, on the developer computer I have created a Class Library that contains COM classes. I have also created an Excel 2003 Addin that references the .tlb file that is created …

Hello, I have been trying to migrate some code I have written so I can use the advantages of Collection items in several forms I programmed in Access 2002. I was using an array list to collect information from a machine part and its resulting defect, then display a small …

I am updating an Access 97 DB w/ VBA code to Access 2007. The VBA code uses DAO objects that Access 2007 references when I converted the db files (first from 97 to 2002, then to 2007). My problem specifically is with the two references: "Microsoft DAO 3.6 Object Library" …

I am working on updating a database where some measurements are stored as text. The updates I'm making are to let the engineers that use it convert their measurements into different units. Long story short, the numbers must be kept as text for a couple reasons that I won't go …

Can someone explain to me how to write the VBA Code that will close another Access Application/Database? I have two Access Programs running. The first Access Program, called Main Program. It is the primary program which contains numerous tables, records, et cetera. I have created a second database, called Employees …

Hi, I have a little problem with a macro I'm working at. I need to pull data from a database and then show it in an excel sheet. Everything work fine till the moment when I want to close the recordset . Then my application freezes and I have to …

I hope this goes here. Alright, so I'm trying to write a simple program that takes the contents of a query's results and pastes them to a text file. Although I could do this manually, I'm trying to create a "user friendly" method for when I'm out of the office …

Hi, i am using VB6 and in my project using List View Control. The checkboxes property is setted true. Now i want to implement a functionality so that to remove only those entries/items cheked by user from the list. Can anybody tell me how to implement this. ANY CODE

Hello Friends, I am trying to automate PowerPoint using VB6. I want to dynamically create an organizational chart in Powepoint, from a VB6 application. I have Office 2003. I am getting error on the following line, when i try to add a node in the Organizational Chart. ppSlide3.Shapes.AddOLEObject 100, 150, …

I have a table in Access with multiple foreign key fields. I would like to populate this table from Excel with SQL. Hardcoding values works fine: [CODE]INSERT INTO Table ( Field1, Field2,...) VALUES (x,y,...)[/CODE] Nesting SELECT statements like this fails: [CODE]INSERT INTO Table ( Field1, Field2,...) VALUES ( (SELECT f_key_x …

Hi, I'm trying to connect to a web service using excel. I have currently no issues logging into the web service and also fetching data using one of the methods. But the two other methods, I get the error that states that it had run into an error restoring data. …

I have perceived that I can get a significant performance boost when reviewing all items of an Outlook contacts list by using "Restrict". (I am looking at over 13,000 contacts). In spite of a lot of digging and reading I am having difficultly in getting my mind around what this …

Can I set the value that MS word will use in the 'Save' dialog ? Usually when a word document is saved, Word will select the first few words of the document in an attempt to auto-create a document name. But I have a textbox near the top of the …

I have an Excel workbook containing named variables across several worksheets. In one of these worksheets I have a "run solver" button, which kicks off a VBA routine. The first thing this routine does is allocate values of variables picked up from the workbook to local variables inside the VBA …

The select case construct is moving to the Case Else line every time the programme loops, even though there are "Longvue" & "Roseleigh" entries in the worksheet.[code]Option Explicit Option Compare Text Sub Complete() Dim HOComplete As Range Dim Client As String Dim JobNumber As Range Dim workrange1 As Range Dim …

Hey guys, im new here and i was wondering if some people could help me out? ive recently been employed in an IT company, and although i am quite familiar with c++, i have been asked to work on making a custom Ribbon in Excel (creating a new tab for …