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

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