Search results for query: *

It would be super if we could use absolute page numbers to print pages from a word document. For example, we have two sections, each with 5 pages. Is there a way to have the user input "1-8" and get vb to print out the pages properly? I do NOT want to use the p1s2 stuff. -Nick

I'm having trouble getting VBA to display the user names of individuals who have a workbook open for editing. I am using: Sub GetUserName() Dim users As Variant Workbooks.Open ("T:\Book1.xls") users = Workbooks("Book1.xls").UserStatus If UBound(users, 1) > 0 Then...

I am opening a workbook using workbooks.open("book.xls") If it is already open, excel is opening it as read only. I would like for it to instead display the dialog box wherein the user can choose whether to open the book "read only" or "notify" or "cancel." How can that work? -Nick

I have a macro running that opens some workbooks, selects some sheets, and sends out a print job to Adobe PDF, and makes a post-script file. I would like to append all the print jobs into a single post script file. Is this possible? How could that work? Also, the macro is being rewritten so...

I have a set of worksheets, all listed in a single cell. Like this: "Sheet1, Sheet2, Sheet3 . . . " And in VB, I want to select all of those sheets. I WAS using sheets(array("Sheet1", "Sheet2", . . . ).select But now I want to use sheets(array(SheetNames)).select Where SheetNames is the...

I need to be able to access cells in a closed workbook based on strings that contain the filename, sheet name, and cel range. I'd like to do this in a function, eg: A1 = "C:\" A2 = "Book1.xls" A3 = "Sheet1" A4 = "A1" A5 = "GetClosedData(A1, A2, A3, A4)" And return whatever was in that...

I am trying to write a DLL and have its functions accessible to Excel so that the code runs faster (right now, I have one module taking about 2 minutes to calculate). I wrote the following code in Visual Basic 6.0 Pro: Public Function TimesFive(x As Double) As Double TimesFive = x * 5...

I'm trying to access a function within an XLL. I cannot get it to register with through Tools > References. I tried this code: Declare Function EPPc Lib "Generic.xll" _ (x As Double, y As Double) As Double But the function is still not being referenced. I have a similar...

I have a string of numbers that I want changed into letters in the same format as Excel's columns. I.E. if the number input is 4, I want to get "D" back. If 27, I want "AA" if 53, "BA" etc. Is there a built-in function for this, or do I need to divide by 26, get...

Hi there, I am writing a VBA to record all changes made to a document, and write them to Word. I already have the Word implementation, what I need to know is this: How can I record all changes made to a document since it was opened? My only thought was to have the VBA record Macro data and...

Hi there, I am writing a VBA to record all changes made to a document, and write them to Word. I already have the Word implementation, what I need to know is this: How can I record all changes made to a document since it was opened? My only thought was to have the VBA record Macro data and...