Programming

VBA to open a PDF, print, then close - Stumped
Hi all, I have the following code that opens a PDF and prints (as well as a cuople of excel files). That part works perfectly, but how would I go about closing the PDF after it prints? Sub RunLoop() Dim Folder As String Dim FName As String Dim bk As Workbook Dim strPath As String strPath = ThisWorkbo... 29 Apr 2010 05:41

A macro for converting formulas to formula results only
I need a macro that will convert a cell's formula to reflect its formula result only based on the following: Range is A10:C200 Only when formula's result > 0 Execute upon closing the file Thanks for any help you can provide. Michael ... 28 Apr 2010 14:02

Macro to save a workbook
I have the following code and it doesn't save as it is supposed to. Am I missing something? I can't seem to figure it out. Thanks. Sub Upload() Application.EnableCancelKey = xlDisabled Sheets("Upload").Select lastRow = Range("M10000").End(xlUp).Row Range("M" & lastRow).Offset(1, 0).Select ActiveCell.... 28 Apr 2010 11:44

Checkbox values
I'm setting up a series questions that are answered yes/no by ticking a checkbox. Is it possible to assign a different value to each checkbox so I can produce a 'final' value based on the boxes checked? (I'm trying to 'wieght' the answers given, in order to assign a final 'score') Many thanks in adavnce of... 28 Apr 2010 14:02

auto copy and paste to another workbook by using specific titles
I am trying to get information from a row that contains a specific title to be transferred to another workbook automatically. I also need to know how to do this with the cells not matching up. ... 30 Apr 2010 01:52

Color Definition
How do I convert a color Long - 8210719, RGB(31,73,125) or #1F49FD to something I can use to format the backcolor of a form control? White = &H80000005& - what sort of value is this? How do I convert any of the above color references to this format? ... 28 Apr 2010 08:22

Detect macro in excel file without opening it
Is it possible to detect if an excel file contains macros without opening it. please advise.. thx! - Boss ... 28 Apr 2010 11:44

Save as vba excel
Hello, How can I create a code in VBA, in Excel 2007, for when closing a book, save it automatically with a new name (the system date and time)? Thanks -- HC ... 28 Apr 2010 07:15

Evaluate VLOOKUP in cells in column
Using Excel2003, I have copyied and modified the following code which essentially should fill the value of VLOOKUP(E2,AgeGroup,2) in cells F2:F64500 but I just Cannot seem to get it right. Would really appreciate assistance. Have no VBA knowledge. Sub AgeGroup() Dim i As Long Dim j As Long Application.... 29 Apr 2010 07:53

VBA source or reference
What percentage of your development time would you say that you spend debugging code? Most developers I've talked to say they spend anywhere from 30% to 50% or more of their time -- not writing the code -- but debugging and fixing it. Not only do we use the debugger to check code we've written before we can go on to ... 28 Apr 2010 05:04