• PDF save as TXT file (VBA)

    Hi experts, I want to save a text file from PDF file through VBA (XLS) coding. I want to get the data as text mode from a specific PDF file in Excel Spreadsheet. Thanks, Ananda Debnath

    AnandaDebnath280 pointsBadges:
  • Convert Excel file to AS400

    I have 'n' number of excel files . i need to convert them into AS400 and validate data . My problem is that all these files are in different formats (e.g. Excel 1 has Age, Name ,Salary fields; excel 2 has name , salary , company fields) to validate data I need these excel files to be converted into...

    SKapoor0 pointsBadges:
  • Web Scrapping in VBA

    How to use getelementsbyclassname and getelementsbyid in web scrapping by VBA?

    shivu639815 pointsBadges:
  • MySQL CrossTab Query

    MySQL does not have a crosstab query. Does anyone have some code that will return a datastructure on a crosstab query?

    Carbon0 pointsBadges:
  • How can I connect DB and input values in stored procedures using VBA

    Hi all, I'm using a automation tool, which is with VBA scripting. I want to execute the stored procedure by giving the values. guys help me.

    Jprpvk5 pointsBadges:
  • Link Outlook Calendar to Excel Spreadsheet

    Hello I am new here and this is my first post. I am wondering whether is possible to link Outlook 2003 Calendar to a spreadsheet in the same way as you would link 2 spreadsheets. For instance if a new entry is created in the Calendar the spreadsheet would be updated automatically. So far the way I...

    Yosiniro5 pointsBadges:
  • Deny delete permission in VBA

    How can I add a deny delete permission entry to acl of a folder for a user, using command line or VBA?

    Ladanzahir5 pointsBadges:
  • Access Reports to PDF file

    Greetings, I have an objective that's been driving me in circles.... Windows XP Office 2007 I need to figure out how to convert "multiple" Microsoft Access reports into one PDF file through VBA. Access 2007 has easy way to convert one report at a time to PDF, however, I cannot figure out how to...

    SeenFresh25 pointsBadges:
  • How to paste data directly from Excel to PowerPoint graphic as data using Excel VBA

    I've been trying to search for ways to copy data from a spreadsheet onto the datasheet of a graph in an open spreadsheet. I am unfamiliar with VBA code, but got it to copy and paste to the correct slide, but only as text. I have been unable to select the actual existing graph and paste the data in....

    Charm20 pointsBadges:
  • Excel 2003: Novice user wants to set up database for research

    Using Excel 2003. I want to set up a database that can be added to by using a form format with drop down boxes, tick boxes and boxes to enter data. Don't know what it's called. can I do something like this to then use it to make queries for certain data?

    Hocosteo5 pointsBadges:
  • Microsoft Excel subtraction using VBA

    I would like to have some coding in vb related to subtraction in Excel sheet.I have 2 sheets.I need to take data from 2 cells from the first sheet and perform subtraction and then placeresult in sheet2.I have huge amount of data in sheet1.I need to perform this operation with all the cells in...

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

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