• 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:
  • Import MS Word document to Window’s Journal .jnt file from within Word VBA

    Windows Journal can import a MS Word file. It imports as an image that can then be written on top of with ink. Does anyone know if I can import the Word document into Windows Journal automatically from VBA code in the Word document? Or is there a way to create the .jnt file in MS Word that can then...

    thenelson5 pointsBadges:
  • Claculate slope & Intercept from line drawn in chart (Excel)

    Is there a way to compute the slope & intercept of a line (object) drawn on a chart in Excel using VBA? I have an X-Y chart with data and I want to have the flexibility of drawing my own "best-fit" line through the data. Thanks, Frank

    falfra10 pointsBadges:
  • Drop down menu’s in PDFs saved from Excel files

    Is there any straightforward way to save an Excel file as a PDF while retaining the functionality of the drop down menus? I have a few drop downs that I've added to an excel file and I want to save this file as a PDF to the point that I can open the PDF and change the drop down menus. Can this be...

    Duester5 pointsBadges:
  • EmbeddedPivotChart: Drilldown-Class

    Hi Everyone Let me start off by saying I'm a complete Noob when it comes to this, so I hope my explanation makes sense... I've been trying to implement the Embedded Pivot Chart Drilldown Class as explained by Craig Hatmaker on the YouTube video :http://www.youtube.com/watch?v=-Uu2WqDxLdk Firstly,...

    BigJoe2350 pointsBadges:
  • VBA – same time stamp, different cell

    I have a macro that runs in the background to apply time stamp to the left of where I modify the cell. So column 2, 5, 8, 11, etc is where I have a dropdown for users to pick, I want the column to the left in the same row to input time stamp. Private Sub Worksheet_Change(ByVal Target As Range) On...

    SGTUjvari25 pointsBadges:
  • Macro using Visual Basic

    Using Visual Basic, I need to choose XYZ information in a cell, in Excel, and another cell must give me ABC predetermined information. How should I do that?

    JoyStrassacapa25 pointsBadges:
  • VBA to copy sent email subject and to fields

    We use a Corel X5 macro along with Outlook 2007&2010 here to send or "export" drawings from our art dept to the sales dept. The macro creates an email with the attached sketch and subject line filled in. I need to modify it to save the current sent email, subject and "TO" fields to a text file....

    swinehart68031,050 pointsBadges:
  • Showing progress bar form during QueryTables

    Hi, I'd like to add a form on my VBA Excel showing a progress bar during data downloading or during other DB process. I'm using VBA QueryTables to download from an Oracle db, PivotTableWizard to download it on a pivot table and ADODB Execute to execute stored procedures. Thanks for your help.

    webluca60 pointsBadges:
  • Adding from two tables in VBA

    Does anyone know how I can use VBA to take one value from one table and add to it a value from another table and then put that total into one field of the original table. I've been fighting with this for a couple of days so now i am looking for some help.

    Silverhawk10 pointsBadges:
  • VBA Array Loop

    Hello, Can anyone help me with VBA code that creates an array from a range of cells (A1:E1), loops through the array and performs a function. I already have the function now I need to create the array and loop. Thank you...

    ClaireJosie40 pointsBadges:
  • Selecting data to delete from column & rows

    I have a sheet that shows me supplier codes - example - these are four digit numbers like 1501 , 1524 , 1701 My problem is I only want to see data from certain suppliers. I have thousands on the sheet that runs daily, but I want to extract data from selected suppliers in column B and delete all...

    Mcgrath6910 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