• Edit a text file with VBA

    Cheers, I have large text file that needs to be edited to run a job but I would like to automate the process.  How do I open a file and replace line 132 of (which is about mid of the file) that file? Thanks, Bob

    Rjwilcox45 pointsBadges:
  • Create SQL statement in VBA Access 2007

    How can I create a select Group BY SQL statement inside a VBA module? I've ran actions queries and they seem to take an effect in my tables but I'm having a difficult time creating a Select statement. Please display a couple of samples

    Bostic8620 pointsBadges:
  • ID_NO INCREASE VBA ACCESS 2007

    PLEASE TELL ME HOW TO INCREASE ID_NO THROUGH VBA CODE IN ACCESS 2007

    AnandaDebnath280 pointsBadges:
  • Access VBA Code stops at Midnight

    Why do all my Access VBA scipts stop at Midnight?

    Robert19735 pointsBadges:
  • VBA Excel – paste not working

    I have the following piece of code attached to my Excel worksheet:         ActiveSheet.Shapes("Object 407").Select         Selection.Copy         Range("BP106").Select         ActiveSheet.Paste The code is activated by making a choice in a drop down in the worksheet. ...

    Paustin5 pointsBadges:
  • Calculate Business Hours

    I found a VBA code that fits the program I'm trying to create but I'm having a difficult time locating the 12-1 lunch break so I can make it straight time. Listed below is the code. Function CalculateDownTime(StartTime As Date, EndTime As Date) As Double Dim Result As Double, EndDay As Date Result...

    Bostic8620 pointsBadges:
  • Subtraction using Excel VBA

    Hi, I'm creating a sheet for the employees in my retail store. The spreadsheet has a column for the different items that I'm selling, and another column for the number of these items that I have in stock. Next to each of the item, I'd like to create a button. So here is my question: How do I assign...

    Curioussam25 pointsBadges:
  • ADO Connection to MaxDb

    Using VBA (Excel 2007) I am trying to connect to MaxDb using the following connection string sapconn.Open "DRIVER={MaxDB};" _ & "SERVER=sapdevsrv_DEV_00;" _ & "DATABASE=200;" _ & "UID=AMJAD_PBL;" _ & "PWD= ;" But it's generating an error saying [Microsoft][ODBC Driver Manager] Data source name not...

    AmjadM50 pointsBadges:
  • Creation of array for input of data

    Hi, I am using access 07. I have created an input form (forms.Base) with an input field of source_code. Below this there are options for other fields to be updated in a record set. There would be multiple entries in the source_code field, seperated by ';'. There would be a maximum number of 10...

    Rponsford15 pointsBadges:
  • format cell based on contents using VB

    i need to change the color of a cell in a specified column based on the value e,g if A1 value is between 1 and 10 then the colo will be red, if the value is between 11-20 then the color will be green etc. i used conditional formats but they only allow for 3 variables i need a script or other that...

    Voicetec15 pointsBadges:
  • VBA Copying rows where a range has the same value as another

    I have a problem where there is a large list of names in excel and a large number of other columns with data about them. One of the columns contains the section name they come under. There are 60+ different section names and these names change name a lot. I have been tasked with writing a piece of...

    Johnthepirate15 pointsBadges:
  • VBA – Mail Merge Automation via Access

    Hi, I'm not sure why my code is not working.. I have code in vba in Access 03 which opens a word document which runs a mail merge process. When the code runs, it asks me what the Header Delimiters are.  I specified those in the export file as a comma for a field delimiter and <enter> as the...

    JK012450 pointsBadges:
  • Need loop to cut rows that meet criteria and paste to another sheet.

    I want a loop that will look at the first four words in column A and if they match then the entire row should be cut and pasted to another sheet.

    Mdsc25 pointsBadges:
  • String Comparison VBA

    I have two columns of string values in excel. They are part numbers so they are typically 6 - 10 characters and a mix of letters and numbers. The columns contain many like strings. That is, the part number is listed in both columns. I need a quick way to compare each string in one column with every...

    RoyAdler5 pointsBadges:
  • Can any one correct this Microsoft Excel VBA code?

    ANY ONE CORRECT THIS Sub fill_series() Dim myrange As Range Set myrange = ActiveCell.Offset(0, 5) Range("N9").FormulaR1C1 = "Apr-2008" Range("N9").Select Selection.AutoFill Destination:=myrange, Type:=xlFillDefault End Sub

    Sa2915340 pointsBadges:
  • vba loop help

    i am trying to run a simple loop, paste code. i am new to excel vba and am trying to teach myself. here is what i want to do, take the numbers one through ten and paste them one at a time into x. it looks like this. 1       x 2 3 4 5 6 7 8 9 0 once i can do that then all of the other math is...

    Opie9715 pointsBadges:
  • Initiate Lotus Notes agent from VB/VBA

    We have a Lotus Notes database with a button to create a new document. The button runs some LotusScript and sets fields in the document. I would like to be able to "press the button" from VB/VBA

    Pprajapati5 pointsBadges:
  • Accessing an Access DB from Outlook via VBA

    Hi The situation: In Outlook I get a message from a server. The content of the message needs to be put into an Access db. But, there may not exist another message with the same date. So, I need to look into a db if there is already a message with the same date and time. If there exists one, then it...

    Camastanta50 pointsBadges:
  • Calculating OD from weight and/or metres in VBA

    Hi there, Have a problem trying to convert weight and/or metres to OD, I work in the flexible packaging industry coordinating all the trials for the UK & Europe. I can calculate from an exsisting OD to weight & Metres using the following VBA statement; RNEW = (PI * ((((NEWI(1) / 1000) / 2) ^ 2) -...

    Fugazi5 pointsBadges:
  • Issue with a sub procedure and its arguments.

    I'm trying to build a sub procedure to create a list for a combobox.  Basically, the db has sererate fields in the client table for first and last names and I want to create a combobox that lists each in one line. The real point of the question is whether or not I can build a sub procedure so I...

    McNitro255 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following