vba

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

VBA code to run command line and retrieve exit code

Hi.The code below is for run an command line proggramm from vba but the exit code is not the correct.The intention of the code is to execute command line in minimized windows.here is the code:'modulo version 2007 09 13 4:45PM'FuncionRunCommandLineAndReturnExitCode'Private Type STARTUPINFO cb As Long ...

Tags: VBA, asihuay@..., proc.hProcess, FuncionRunCommandLineAndReturnExitCode

Discussion threads 2007-09-13

VBA code that links Outlook tasks to journal

Background: I am trying to semi-automate the following manual processes:1) Click/drag email into Tasks to create a task. Assign it a category.2) Click/drag above tasks by category into a journal item.I have successfully modified some vba code that will copy an individual email to an Outlook task (I...

Tags: E-mail, Groupware, andrew.mitcham@..., VBA, Microsoft Outlook

Discussion threads 2007-09-03

Using Outlook VBA with MS Access 2007 Database

HiI have an application in MS Outlook 2007 that used to store data in an MS Access 2003 database. I have converted the database to MS Access 2007 and now my Outlook VBA app fails on the OpenDatabase method with "Run-time error '3343': Unrecognizewd database format"I have changed the References...

Tags: Databases, Microsoft Office, VBA, quell.development@..., Microsoft Access, database, MS Access 2007, Microsoft Corp.

Discussion threads 2007-08-31

How do I... Export e-mail messages to Access using VBA?

Manual Export doesn't work in my OL2003I wanted to try this method, but when I first selected "Export to a file" and clicked next nothing happened.Any ideas on what can it be wrong?ThanksRE: How do I... Export e-mail messages to Access using VBA?Good stuff, but a couple of steps are...

Tags: Microsoft Outlook, Scripting languages, Microsoft Office, martipe1@..., Export e-mail message, VBA, Microsoft Access

Discussion threads 2007-08-29

VBA code for looping through fill in field boxes from a .doc

I made a fill in pop up box form, saved it as a template and protected it. when I double click it opens and nicely runs through all the pop up boxes. Then I save it as a .doc. When I open the doc and want to...

Tags: VBA, mlgcarroll@..., pop-up box

Discussion threads 2007-08-29

How to pause vba execution without stopping downloading of csv file

I am downloading a csv file using FollowHyperlink. Since it downloads the file to a separate workbook then the one I am working on, I need to copy and paste it. Unfortunately, the VBA code continues to execute even though the csv data has not loaded in the...

Tags: Scripting languages, aa3533@..., VBA, CSV file

Discussion threads 2007-08-26

VBA module to download CSV Data to Excel

Forgive my newness but what would be the best way to automate or write a module so that every time I download CSV from a web site it will automatically save to an Excel file? Is this possible in scripting? New to the tech stuff so don't know how this...

Tags: Microsoft Office, Web site development, mccalli.kitti@..., Microsoft Excel, CSV, VBA

Discussion threads 2007-08-22

VBA Macro

Hi,I am using vba macro for mail merge. I have created htm file as a template and trying to do mail merge, but if fields are more than 62 then it gives error. i have taken then html file but it asks for the table prompt as template contains embedded...

Tags: Scripting languages, pritivinay@..., VBA

Discussion threads 2007-08-13

VBA automating procedures.

Heya! I’m new to programming and the forum; after buying a book on VBA for excel I’d like to try and put my knowledge to the test and eventually build a program for my Dad's electrician firm to link cost of job, an invoice and stock check.My initial thoughts are...

Tags: Investment, VBA, a.d.rowlinson@..., msgBox, stock, stock list

Discussion threads 2007-08-09

Use VBA to hide some columns

I in fact want to filter columns like filtering rows with Auto Filter. However, I know Excel cannot filter columns. Then, I thought of using VBA to do it.I intend to set values in A3:Z3. If the values in any of these 26 cells = 1, then...

Tags: Scripting languages, HeHeMan, VBA

Discussion threads 2007-08-08

VBA Program

I am doing a program in VBA and running it in Microsoft excel.For example,when typing the input, the user is supposed to type "234-L1-23-23". Instead, if the user typed "234 - L1 - 23 - 23"The error is the spacing the whole program hangs. my question is this, is there...

Tags: Scripting languages, sujathasureshkumar@..., VBA

Discussion threads 2007-07-21

VBA Web Query with Username/Password

I'm looking for detailed information on how to use VBA to grab data from a website requiring a username/password login. Mike posted a similar question some time ago and he was told that it is tricky and it depends on the website. How about these two websites? Is there a...

Tags: Scripting languages, Web site development, kahll@..., VBA, Web site

Discussion threads 2007-07-19

Opening Multiple Copies of Excel in VBA

This probably sounds an incredibly stupid question, but I have been asked to develop an app for a client that uses Excel but is not to behave like Excel. I've gone through the process of removing the menu and toolbars etc, but I want to be able to open...

Tags: Microsoft Office, VBA, dean.crawley@..., Microsoft Excel

Discussion threads 2007-07-18

VBA - How can I add a line of text to the last line of a text file?

Using VBA MS Access module, I want to open an existing text file and add a row of text to the end of the file. I cannot seem to accomplish this with a simple Open/Write command... Do I need to use the FileSystemObject? If so, any quick...

Tags: Scripting languages, polinimz@..., text-file, VBA

Discussion threads 2007-07-17

Copy and pasting related fields in a new table (Acess VBA)

I am very new to Access VBA. I am creating a form with a textbox and when the user enters the information then it will search it in table XYZ within access and once it finds the results then it will copy five related fields for couple of records...

Tags: Scripting languages, msayeed@..., VBA

Discussion threads 2007-07-16

Access and VBA

I am picking up from where another person has left off in creating a GUI in Access using VBA. I have no background in this so it's taking a while. I have created a "Browse" button that allows a user to pick a directory where they want to save a...

Tags: Scripting languages, cloh@..., textbox, VBA, Microsoft Access

Discussion threads 2007-07-11

VBA Macro to transfer data fro excel to Powerpoint

Hi, I need to present a chart with the data in Excel dynamically using VBA Macro

Tags: Scripting languages, Microsoft Office, breeze_rathna@..., VBA Macro, VBA, Microsoft PowerPoint

Discussion threads 2007-07-05

autofill word doc with data from .txt using VBA

Hi Guys, I have managed to use examples of code from here to help me setup a document template, but my understanding of VBA is still limited. I now want to extract a particular set of data, in this case a row of address details from a .txt file...

Tags: Scripting languages, birling@..., VBA

Discussion threads 2007-06-07

Restart Access using VBA

Hi,I have an access database that connects to remote mySQL tables through ODBC connections. This db has a form that tries to access these remote tables every 3 minutes, and runs 24/7. If the ODBC connection call fails as it sometimes does, an error message pops up (ODBC--call...

Tags: Databases, Scripting languages, Scarlet Christiaans, ODBC, VBA, database

Discussion threads 2007-05-31

How to use one Access form for multiple tasks

Occasionally, users want to enter new records without wading through existing records. You might think you need two forms, but you might not. If the form's structure is the same, you can use just one form. For instance, let's suppose users want to enter new customer records and view existing...

Tags: VBA, Access

Blog posts 2007-05-17