vbscript

  1. 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...
  2. 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...
  3. 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)...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. T

    Locating Duplicates

    I've created a resource allocation sheet tasking the several people working with me to certain jobs. What I want it to do, is ensure that nobody has the same job more then 3 times in a week. I'm new at this, so please ignore the repetitions and superfluities. It currently works, except for...
  10. D

    Data (text) to be copied and amended to another cell in a different worksheet

    Hello all: <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I have a single excel 2007 workbook with eight worksheets and I wanted to find out if there was a way that I could automate that if data (text) were entered in a cell that this data (text) would...
  11. schielrn

    vbScript to Save Excel file as PDF

    Ok this has something to do with Excel, so I thought it was applicable to post here. I am trying to create a vbScript that will take all Excel files in a folder and save them as a pdf as well. The commented line is not working in the script and I cannot for the life of me figure out the...
  12. N

    Run Macro from Windows Hotkey

    So I have a new job and a coworker that makes this really annoying teeth sucking sound like every 2 minutes, so the only I stay sane is by keeping track of every time he does it. I have made a spreadsheet to keep track, and it's keeping me sane like a charm. (link to file) I would like log each...

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