vbscript

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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 |...
  12. 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
  13. T

    Automatically format recurring sheet

    I work with a sheet that is recreated on our server on an ongoing basis. I want to format it (row/column/cell coloring) based on the data in that sheet. What is the best way to accomplish this? I am a seasoned excel used and also a programmer. I have done limited macro's and vbscripts, but am...
  14. P

    VB Script Start

    Good Afternoon, I have been getting back into VB Script for the first time in a loong while and could use some help with the logic and/or code for a custom solution I need to create. Basically I have an email alert that is sorted into a folder in my outlook. From there, I have an Access file...
  15. C

    Excel to PDF using vbscript

    I have been able to convert an Excel worksheet to PDF, however it only does the active worksheet. How can I get it to put all the worksheets in an Excel file to one PDF? Here is what I have: function excel_app(filename) strExt = objFSO.GetExtensionName(filename)...
  16. H

    Referencing a cell within code - VBScript

    Using Excel 2007- So I have a code written to execute a data table (pulling from an external database, which is an add in to excel). The below code works fine and pulls the data but here's the adjustment I need to make. In the 2nd "break", that starts with result=, this is where it chooses...
  17. E

    Dos Batch File to VBscript

    I have written a Dos Batch file that asks the user some informtion then renames a directory with that info. such as "Job No." "Company" In the batch file I use the Set command to get the info Set /p number=Job No. I would like the Batch file to then go onto open a excel file and input...
  18. T

    VBA to Sum Contiguous Cells

    I'm trying to sum the contents of contiguous cells that have values resulting from a formula. Before Macro Cell: Value M2: 4 M3: 6 M4:"" M5:"" M6: 8 M7: 9 M8: "" M9:"" Cells M4, M5, M8 and M9 are not empty. These cells have formulas that return "". All cells in this column have the same...
  19. solitude

    Name errors with excel addin loaded through VBScript

    I'm trying to run some excel macros through VBScript. The code also uses Bloomberg addin. Now, I know that VBScript by default switches addins off so in the script I have lines that add Bloomberg addin. Problem is - while debugging, I get 'NAME' errors in cells that use Bloomberg functions...
  20. R

    vbscript and .QueryTables.Add

    I am writing a generic vbscript that takes delimited files and makes Excel files out of them. Using With objWorksheet1.QueryTables.Add("TEXT;C:\Sample.TXT", objWorksheet1.Range("$A$1")) .Name = "Sample" .FieldNames = True .RowNumbers = False...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top