• Combining data from two Excel sheets into a new sheet

    Hi, I Have few leave detail excels wherein the leave details of each resource are present.I need help to create a macro wherein all months leave details will be clubbed together into a new excel for each resource.Kindly help me with the code or give me some ideas to do this since am very new in...

    Vaibhav1235 pointsBadges:
  • Open Internet Explorer using Visual Basic and resize the IE window

    Hey, I have been stuck on this bug for a long time I hope someone can help. So in my VBA program, when you press a button a timer starts which opens up multiple Internet Explorer windows but the problem is that I won't each window opened to be a different size which can be done by adding randomness...

    shiv4655 pointsBadges:
  • MYOB open macro causes ‘macro disable’ messages when Office documents opened

    On a system that has MYOB installed every time a Office file is opened a message box appears saying that macros are disabled. I understand that the problem is due to the location that MYOB has used to store their macros. Can I move them and avoid this issue ?

    David995 pointsBadges:
  • Comparing 2 Large Excel Files

    I have 2 large Excel files, one containing yesterday's data, and another containing yesterday's data + today's updates/changes. For registration purposes, I need to find all the differences (ie new rows/entries, a value changed within the row in the new file vs the old file, etc). These excel files...

    Drawde5 pointsBadges:
  • Copy/paste a record with VBA in Microsoft Access

    How can I copy number of records from a form and paste them in another form with VBA, not with the right click, in MS Access? Thanks!

    Toli70 pointsBadges:
  • Comparing Quoation Marks in an If Statment

    firstchar = Left(Selection.Text, 1) If firstchar = """" Then This Code never seems to pass even if the first character is " please help

    ikestir15 pointsBadges:
  • Setting a slicer in a pivot table

    I need to set a slicer in a pivot table by using VBA so that I can limit a number of filters the user choose. I mean if the user choose, for example, more than tree options in a slicer a warning message box pop up on the screen. This slicer I am talking about is based only in one field on the table.

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

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