• SAP Macro

    I have a bunch of data that i need to get out of SAP and put it into a Excel spreadsheet daily. i need to look up the hours on several different parts and operations. is it possible for me to writed a VBA program that will call a SAP macro give that macro data and export run the report and...

    Jtgibson215 pointsBadges:
  • VBA Code for adding a day 14 days after a template is opened in Word 2003

    Hi, I have been asked to create a Word template (2003)that is held ona network drive and will be accessed by numerous employees as a .DOC file. The template has three date fields in the text. The three fields need to have a date that is 14 days after the template is opened as a .DOC. I have a VBA...

    Ianmax4975 pointsBadges:
  • tutorials

    hi all. i wanted to ask if anyone knows any sites where i can download free ebooks or free tutorials. thx.

    Mmm5550 pointsBadges:
  • 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:
  • Web services for windows 7

    Currently I have excel .xla addin with a macro that was created by the Microsoft Office 2003 Web Services Toolkit.  Works fine with XP and Excel 2003.  Now some users in office have Windows 7 and Excel 2003 and I have to remove the references to the mssoap30.dll and msxml6.dll in order to have...

    Smf170 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:

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.

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

Following