vbscript

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...

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...

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...

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...

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

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...

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...

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...

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...

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...

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 |...

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

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...

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...

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)...

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...

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...

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...

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...

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...