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

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