<dd id="yld2g"><track id="yld2g"></track></dd>

    1. <th id="yld2g"></th>

      Questions tagged [vba]

      Visual Basic for Applications (VBA) is an event-driven, object-oriented programming language for writing macros, used for the entire Office suite as well as other applications. VBA is not equivalent to VB.NET, or VBS; if you're working in Visual Studio use [vb.net]. If your question is specifically about programming any MS Office application, also use the appropriate tag: [excel], [ms-access], [ms-word], [outlook], or [ms-project].

      Filter by
      Sorted by
      Tagged with
      0
      votes
      0answers
      4 views

      Pulling Quarterly Stock Data from Yahoo using VBA - 2020 Updated

      So I've been able to write a script that is able to pull stock fundamental data from Excel. Yay. I know the update has stumped many. Here is my current code. I am looking to interact with the webpage ...
      0
      votes
      0answers
      6 views

      Make GUI with HTA (HTML Application) for running the BAT file in Specific directory

      I have many BAT files for different function. And i would like execute the batch file from specific work directory. Working directory will change each time. So I need make GUI for choose batch files ...
      0
      votes
      0answers
      12 views

      Microsoft Jet database engine cannot find the range object in a newly added worksheet

      I am developing an application that draws a query from multiple consolidation ranges in a single Excel workbook. The ranges are from a user-selected array of worksheet names. The code creates a pivot ...
      -1
      votes
      0answers
      11 views

      Corrigir Macro VBA envio de mensagem de texto/SMS

      Olá! Estou montando uma macro que faz envio de mensagem de texto usando o Messages.Google. Mas ele quando chega na parte Digite a Mensagem, ela n?o prossegue, e tambem n?o ponta nenhum erro. Alguém ...
      0
      votes
      0answers
      12 views

      How to access the Web using VBA? Please check my code

      In order to improve the repeatitive work, I tried to access the Web site which is using in company using VBA. So, I made code using VBA. And I checked it could be access the normal site such as google,...
      0
      votes
      0answers
      18 views

      Worksheet copying dynamic cells

      I'm hoping to get some idea on automating copying some data in-between columns and worksheets. I have to clear column C, then copy B over, clear B then repeat for A. Where it gets tricky for me is ...
      0
      votes
      0answers
      12 views

      How to assign different data types to 2 dimension vba array

      this is a vba related question: I have created a 2 dimension array (option base 0) in which I have loaded dates into column zero (row 0 to 8), and percentages in column one (row 0 to 8). I have Dim-ed ...
      0
      votes
      0answers
      9 views

      Excel VBA - Downloaded csv file with url but it just displays html code instead of actual contents of csv file

      There is an online spreadsheet that has the option to "Download Spreadsheet". When you select it, it downloads the file as a .csv to the downloads folder. I want to download this spreadsheet ...
      1
      vote
      4answers
      34 views

      Counting value based on 2 other column in excel

      How to count the value as shows in the below example in vba or excel formula, Count column should have a value of the combination of column1 and column2.
      0
      votes
      1answer
      11 views

      Check a style of a class html via VBA Webdriver

      Using VBA, webdriver, Chrome as navigator, I would like to check the style of a class in html page. This is the class : here is the full xpath : /html/body/div[1]/div[3]/div[2]/div[1]/div[1] To be ...
      0
      votes
      2answers
      21 views

      VBA - Copy last Row Formula to New row (Table)

      looking for a code that will copy formula from Last Row to a new row in a table or some code that make the new row with formulas :) example: Last row number C25= A25+B25 so the new row Number 26 will ...
      1
      vote
      2answers
      27 views

      Copy just the value to new sheet in VBA

      I'm so close on this, but keep getting errors if I try to use .Value or .PasteSpecial xlPasteValue. I'm not sure where to put it, but I've tried multiple options. I want this to work as is, but just ...
      0
      votes
      0answers
      13 views

      Get network traffic logs from Selenium Basic in VBA

      I am trying to retrieve the network traffic from when a page loads in Chrome via Selenium. Specifically I am trying to retrieve the API headers that were used in the last API request. I have managed ...
      0
      votes
      0answers
      31 views

      Index Match using VBA Function in Microsoft Excel

      I'm new to Excel VBA and am trying to write a function that lets me use INDEX, MATCH and COUNTIFS functions to find value for a given column by matching criteria in other columns (multiple). I have a ...
      -4
      votes
      0answers
      22 views

      Need to download Excel file from a website running JavaScript, download link has void(0) [closed]

      Using VBA, I need to download the Excel file from https://www.iexindia.com/marketdata/areaprice.aspx [][1]as shown in the attached image. The href of download link has JavaScript:void(0). Kindly help. ...

      15 30 50 per page
      1
      2 3 4 5
      12185
      欧美日韩国产在线一区二区_午夜短视频在线观看_亚洲国产欧美日本视频_亚洲精品高清视频在线观看