• How to paste data directly from Excel to PowerPoint graphic as data

    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 graph and paste the data in. Any help...

    Charm20 pointsBadges:
  • How to paste data directly from Excel to PowerPoint graphic as data

    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 graph and paste the data in. Any help...

    Charm20 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:
  • How can I read a text file for use with Microsoft Word mail merge?

    Hi I have a text file that the first row is the filed name that separated with comma and from second row there are data fields that separated by comma too. I want to read this file record by record and make a report by it's data in microsoft word!! I have read just the first row of data by using of...

    Aliyani265 pointsBadges:
  • Not allowed to edit Microsoft Access forms

    A previous employee built a very usable db, and has gone on to greener pastures. It isn't password protected. When we try to edit the db with new fields or change wording in fields, it asks if we want to exit the app. if Yes is clicked, it exits the app and Access. We use Office Pro 2003. Any help...

    Donnerblue5 pointsBadges:
  • To connect to Excel 2007 using free version API Java

    Presently we are using JavaExcel(JXL) API to read/write from the Excel 2003. Now we have to update to Excel 2007. The problem was JXL is not supporting for the Excel 2007. The other API's are in the Beta version. Guys any API's are there to support Excel 2007 ......

    Ansipar288315 pointsBadges:
  • How to capture the height,width of the latest picture inserted in word using macros,VBA?

    Hi, My task involves capturing the height , width of the latest picture inserted in word using macros,VBA.

    Iamfromhyd20 pointsBadges:
  • Conditional formatting

    How do I get conditional formatting in a form to continue to work as a sub form

    Dbarrett5 pointsBadges:
  • Trying to copy a value created within a subroutine to another cell in the same worksheet

    I have a string of cells that are populated by my macro. what i need to do is: each time the value populates, i need to copy just the value to another cell so i can record the results of the macro for a long string of numbers. heres what i have, this is not working for the last step - Sub Count()...

    Irish44455 pointsBadges:
  • Switching Excel Custom Views Based on Selection

    I have two saved Custom Views for a protected worksheet that I use as an input and summer page for an estimating spreadsheet. I want to include a validated cell on the front page which would select one of these two custom views based on which answer the user selects. Unfortunately I am very limited...

    Brgbldr5 pointsBadges:
  • VBA question for a beginner

    I am very new to VBA and my boss is having work on a spreadsheet that dynamically updates the comment box with a value from a designated cell. Here is what I am using for the first target address of C39 to be displayed in a text box in C5. Problem is I have to do it for 140 cells. I don’t know...

    Gburns1235 pointsBadges:
  • Deleting all formulas in a worksheet when unprotected in VBA code

    I would like to know the vba code for deleting all formulas within a worksheet if the worksheet is unprotected by any one, obviously I would have to have an administrators code in case I need to unprotect the worksheet myself. My workbook contains many worksheets and with many formulas I have...

    Barnoldswick5 pointsBadges:
  • email query recordset

    "I have a query (emailnotifytest) based on 2 tables . One table (shipmentdata) filters on new records. the other table (contact) filters which contains the email address filters whether the address is not null. The tables are joined by the companyname. the code below works as far as sending the...

    Roundy5 pointsBadges:
  • How can i connect DB and input values in stored procedures using VBA

    hi all, i am 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:
  • How can we insert space between text and a table in MSword using macros

    My task is like this. SampleText Table1 with some columns and rows. I need to insert text between "SampleText" and "Table1". When I am inserting text it is inserted into the first cell of "Table1",however I have to insert it in between "SampleText" and "Table1" by inserting line break/space between...

    Iamfromhyd20 pointsBadges:
  • Excel Form Macro

    Hello Excel Gurus, I am in great need for an Excel Froms Macro that Switches a Spin Control (asignes integer value) to a cell and is mux'ed betwen different cell references that are activated by a radio button. I created a model code fragment well over a year ago and got the functionality to work...

    Dinosaur995 pointsBadges:
  • Copy and paste in Excel using Visual Basic scripting?

    First of all - Thank you.... I receive info in Excel worksheet "A" with columns of variable length which I want to cut and paste into Excel worksheet "B". Worksheet "A" info starts at B:13 and can range in length from 1 to 200 rows or more. I would like to copy this variable length information then...

    Bmac5 pointsBadges:
  • Can you help with the following DAO code explaining a step-by-step process?

    I’ve had some exposure to VBA and know the Access Interface very well (Microsoft Certified). I purchased MS Access 2007 Programming By Example by Julitta Korol a couple of months ago and all of the hands-on examples display the results in the Immediate window or a msgBox. Although I was able to...

    Doc3310 pointsBadges:
  • EXCEL find-copy-paste

    Hello! Using VBA for first time, so everything is toughed for me.. The problem is: we need to find on the first sheet named SD in second column all cells contianing word 'drilling', then for each cell copy row which contains that cell and paste it in other sheet or book (doesn't matter). Please...

    Snursmursik5 pointsBadges:
  • Add module to remote access database

    I have 100+ access 2000 .mdb's that I need to add a specific module to. What I want to do is loop through all mdb files in a specific directory and add a standard module to each one. Any ideas as to how to accomplish this from within access vba would be appreciated. I intend to do this from within...

    Ttstudio45 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