• VB script for MS Word 2013

    I'd like to build a VB script within my training documents that would launch an email acknowledgment with a predefined subject and message body. Is this even possible?User clicks a button at bottom of document, script generates email to my address, with predefined subject (Training acknowledgment)...

    jhoward12025 pointsBadges:
  • How do I get a macro to move between workbooks?

    I have a template (workbook #1) that I would like to copy data out of and paste into the workbook that I run the macro from (workbooks 2, 3, 4, 5...). The problem is that when I record the macro from workbook, excel codes the name of that workbook, making the macro unusable in workbooks 3, 4, 5.......

    Bondsmith5 pointsBadges:
  • How to change colors in Excel VBA

    I need to be able to change the fill color of a range of cells in the active cell’s row. When I pick another cell in another row the previous active row, it should revert to its original color.

    GrayBear5 pointsBadges:
  • Math test in VBA – Thank you

    Hello :-) I want to create a maths test for my 6 year old daughter. I wish to create a list of questions and she would need to key her answers. If she is gets its correct she gets the "Well done" msgbox otherwise "wrong answer". I've done the following, how can I create a list, whether or not she...

    VBAlearner15 pointsBadges:
  • .DAT file of unknown structure

    I have been given a series of .dat files of which I do not have the file structure. They are produced by a system that tracks elctrical consumption. All I know is the brand "iPT", and that the owner connects to it via HyperTerminal in order to get the data. I work mostly with VB/VBA, but any and...

    NimBiotics50 pointsBadges:
  • Macro to breakout data into separate tabs

    I have a weekly report that holds line item detail for seven different account numbers. The data is going to vary from week to week and I need vba code that will separate the data by account number into different tabs. Any tips on how to write the code? RWC

    HNAvigator20095 pointsBadges:
  • Ping SQL server in VB6.

    I need to use VB6 to detect if an SQL server is running. Looking for the easiest way whether it is pinging or something else or even detecting the database itself. Preferably by network device name.

    Jstropp5 pointsBadges:
  • Comments in Excel using VBA with archived info included

    To whom it may concern,I am currently trying to get very specific cells in a spreadsheet to pull up the previous weeks worth of information (date from the past 5 days at least) and to show up in a comment on very specific cells so that the people in my department do not have to look up the...

    jgarces5 pointsBadges:
  • PDF SAVE AS TXT FILE

    How I Can A Pdf File Save As Text file through VBA coding (Xls) Acctualy I want to Insert data into Xls sheet at text mode from Pdf File through VBA Coding, So, I wish the following Steps Step-1 Pdf SaveAs Txt file (Through VBA Code by Specific Path) Step-2 Impot Data from Txt file into Xls Sheet...

    AnandaDebnath280 pointsBadges:
  • MS Access 2013

    Does anyone have VB code for add a new value to a lookup table during execution of application?

    Robertar15 pointsBadges:
  • How to query a SQL Server 2008 database from Outlook

    The purpose of this module is to monitor the activity of Outlook and grab the attachment (. Zip file) for a specific email address and subject line and place it on the server (and create the Server Folder(s) Structure: CompanyName->weekNo.->zip file(s)) I have to mention that we are going to...

    SoftwareQuestions5 pointsBadges:
  • Run VBA code as admin

    I am currently working on an ms access application for a large insurance company which generates reports for the user after the user inputs/select some data.... Unfortunately the application has already been built - and till now we used to run the application/reports by logging in as admin.....

    Gangac5 pointsBadges:
  • Export or Import data Excel to Excel (VBA coding)

    Hi experts, could someone please tell me if it's possible to export or import Excel data to Excel (VBA coding)? Ananda Debnath

    AnandaDebnath280 pointsBadges:
  • Filename error in VBA

    I created a macro to run with my daily reports in Excel. The only issue is the names of the report change every day respectively as Mat1 mm-dd-yy. I have tried to maneuver with the code but it always leads to a dead end. How can I change the code to be able to run with any date? Mat1Macro Macro ' '...

    ambershantae5 pointsBadges:
  • VBA code

    Can you teach me how to write VBA code in access to export access data to other applications extensions: XLS, PDF, and HTML

    securityzero10 pointsBadges:
  • IF and then statement in query

    I'm having issues with an if statement in a query. Basically I need to know how to get the following: If field 1 is > 0% then field 2 = 25. I don't know VBA

    tphester5 pointsBadges:
  • Trouble creating SQL statement from MS Access Form

    I'm creating an INSERT statement from the text fields in a form. This is a snippet: mySQL = mySQL & Combo0 & "','" & Text3 & "','" & Text5 & "','" & Text7 I am alternating the double and single quotation marks to enclose the entire statement as a single STRING while...

    MarcC5 pointsBadges:
  • Find and replace text in text file using MS Access VBA

    Hi I need to modify some tags of an XML file that I receive. How can I search the file for specific text and replace it? Here is the code I have right now. It runs without errors but does not replace the text.Function ReplaceTextInFile() Dim sSearchText As String Dim sReplaceText As String Dim...

    Vgnadeau15 pointsBadges:
  • While Loop in Excel VBA

    I have the basic loop and can not figure out what to write in the middle. I need to have row 9 column D populate a value from another sheet depending on the value in cell A9. Here is what I have so far: Private Sub Loop1() Dim myLoopCtr As Integer myLoopCtr = 0 While myLoopCtr <= 15 myLoopCtr =...

    Castaway19585 pointsBadges:
  • Find and replace text in PPT

    I have a project to find and replace words in PowerPoint from Excel and then save the PowerPoint. My code is working fine. But when PPT has mp3 then it giving errors. Please see the code and tell me what change I should do. Sub pptopen()Dim a AsIntegerFor a =2To4Dim pptApp As PowerPoint.Application...

    fattahaabdul5 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