vbscript

  1. S

    VB Script help needed

    Need help with vb script to do the following Copy & Paste special (values) from Sheet “A3”.Range(B6:E8) AND Copy & Paste special (values) from Sheet “Timeline”.Cell(F6) TO Sheet “Change Log” WHEN Sheet “A3”.Cell(M3=”YES”)
  2. K

    vbscript to move data to new worksheet

    Hi I want to transform some data into a table on a new sheet but to me it seems complicated so I am not sure if it is possible. Below is the source data format <colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="2"></colgroup><tbody> 01/01/2014...
  3. S

    How can I download attachment from lotus notes?

    I have a program which download lotus attachment to a path in computer. It does not download the file when the file is already downloaded. But if we delete the file from path, it downloads it again. I have a workaround, that we can mark the file as read when downloaded, but don't know how to...
  4. S

    vb script to go back to last sheet viewed

    I am looking for a script that will take users back to the last sheet viewed/edited after a "delete macro runs" (not the last sheet in the workbook - previous sheet viewed/edited) Below is script that I have that deletes the records on the "Returns" sheet Sub Macro2()...
  5. R

    Trouble automating a macro

    Hey everybody....first of all, even though this is my first post here, I have been using these forums as a tremendous resource to help develop some pretty awesome macros that have saved myself and my company an incredible amount of time, so thank you to those who contribute here. On to my...
  6. J

    Generate .VBS script with a .VBA code

    Good afternoon, My first post on the famous Mr.Excel.com. Hope I would post a question that has been answered thousands times. I need to create a .VBS document/script from an excel sheet. Is there any easy way to do a "save-as" and choose the .VBS extension ? Once the .VBS is created, I...
  7. M

    Need help to append data in existing cells(rows) of single column and suffix numbers in increasing order

    Hi All, Please help me to create a VB script(in excel 2010) for the below scenario: Consider column A and there are 100 rows in that column with some existing data in each cell. e.g. A1, A2, A3,... = apple, bat, cat,.. Now what I need is a script that would do this: TC1_apple, TC2_bat...
  8. L

    VBScipt ExecuteExcel4Macro PAGE.SETUP Font, Style not working

    Hello All, I am currently using Excel 2007 on Windows 7. It should be noted that I am developing this script to run on multiple versions of Excel (2003,2007,2010) as well as multiple versions of Windows (XP,7 and possibly 8) I really need someone's help with a "Working" example of an...
  9. M

    VBScript to Sort a range by row

    I have been searching Google and this forum but have not found a solution that works for me. Hopefully someone can help. I have very little scripting experience but I am really good at copying and pasting! ;) I have a spreadsheet listing servers with a series of columns listing their features...
  10. K

    How to find a text string in a PDF file and automatically print it. Please help

    I would love a <acronym title="vBulletin">VB</acronym> code or something or some sort to help me with this problem, its a very important task for me. How can I find a certain text string in a PDF file (located in a certain drive) and either pull the text from the .pdf and put it in a cell, or...
  11. T

    Simple If-Else-statement to chose one cell over the other - excel - marco

    Hiiii, I have the following code below and what it does it create another excel document from the information gathered from the initial document (source). So what i want to do now is create a statement that will do some checking for me: If column E and F has values, then i want to take F...
  12. C

    Creating custom path using excel cell values

    Extract the information from column A and Column B from one excel document and create another excel document and copy each row in the first 4 columns while placing the cell values from column A in the new document path structure. Source: Document 1 Column A Column B dog <tbody> Column A...
  13. C

    Read and write from excel sheet to another excel sheet using java or vb

    :confused:Hi All, I have an excel document that's a very long list and i want to automate my process with extract certain information for my new document, but using java. I am also open to vb. So I have 5 columns with information that i will need to use to create this new excel sheet. See...
  14. S

    Need help to copy excel data into outlook body using VBScript. Below is the all code that am using . but it is sending only blank email. excel data is

    dim aOutlook dim aEmail dim strRecipients dim automail_sub dim psg_level2 dim names_copy dim add_body_txt dim signature dim i dim rowcount dim path Set xlApp = CreateObject("Excel.Application") xlApp.Visible = False path = WScript.ScriptFullName path = Left(path, InstrRev(path, "\")) 'Open...
  15. L

    Group/Ungroup ONLY some columns/rows accross ALL sheets

    I have a workbook with 12 worksheets. The sheets already have a few grouped columns and rows I want to write a macro that will group/ungroup only certain columns (ex. columns T-V and rows 5-8) but not all of the rest of the grouped columsn/rows. Lastly, I want this macro to repeat this command...
  16. S

    Formula to change font color if condition is true

    Hello, How can I create a formula that changes the font color of a 3rd cell? For example, I have 2 cells where I am taking A1-B1 and displaying the result in C1. How can I make it so that if A1 is grater than B1 then C1 is in red font? I am using time values so I my negative values are...
  17. M

    VBScript and Frames using contentWindow

    Hello Guys, I have this issue, I'm creating a Macro that is automating a process in a Web Page, but this page have a lot of frames. So when I get the value of the object it only have the values of the frame Set IE = CreateObject("InternetExplorer.Application") IE.Visible = False...
  18. V

    Bring Focus to Input Box

    Hey guys, My friend wanted a program for his employees that would allow them to input some data. The program would then just search an excel file for matches. If a match was found, then a message would be displayed that said "go ahead and do it." If a match wasn't found, then it would say...
  19. P

    How to automatically delete rows in Excel based in day of week and date?

    Consider the following (partial) Excel worksheet: A | B | C | D ---+-------------+-------+------- id | date | var_a | var_b 1 | 2011-03-12 | 200 | 34.22 1 | 2011-03-13 | 203 | 35.13 1 | 2011-03-14 | 205 | 34.14 1 | 2011-03-15 |...
  20. K

    vbscript excel constant values

    Hi There Excel 2007. i am creating an excel document with vbscript from another application. Q: Does anyone know if there is a list somewhere of all the vbscript value constants e.g. HorizontalAlignment = -4108 many thanks

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top