• VBA Excel dates

    Why can I not make VBA Excel write me the date I put in the code, rather it shows always 00/01/1900 pls? See I wrote a short code that fills in the woorkbook (sheet), the date (any date) as a responce to a week number. The problem is that the code is only returning one single meaningless value of...

    Biggener5 pointsBadges:
  • Can ACCESS forms be used in EXCEL?

    Can forms created in ACCESS be used in EXCEL (via VBA)

    Jgenterprises10 pointsBadges:
  • Add functioning checkbox or radio button in PowerPoint 2007

    I have a "form" developed in PPT that different people will have to complete to then turn it into a full presentation. One part requires them to select Yes or No for impacting something. I would like a drop down for this but, I don't know how to do VBA code. Can I do a checkbox or radio button...

    Smitstwins5 pointsBadges:
  • Excel 2007 macros

    In Excel 2007: How to make current time/date (static) populate active cell when command button is clicked?

    Mcvla5 pointsBadges:
  • Printing File Dump Path in Visual basic

    How do i write a macro for a PDF print file to be printed to a folder path?

    Bogsy10 pointsBadges:
  • Combo Box Selection Locks Form

    I have a combo box that locks/corrupts all of the controls on a Access 2003 form.  The locking symptom only seems to occur when the list index is greater than 0. The problem control may not be the combo box.  It may be one of two list boxes that are affected by the combo box's 'after update'...

    McNitro255 pointsBadges:
  • 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:

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