$$Excel-Macros$$ Re: Macro to print sheets to different printers

I will try tomorrow and let you know the outcome thanks for the quick feedback. On Nov 9, 10:35 am, "Tom Jeffries" <[EMAIL PROTECTED]> wrote: > This may do what you want: > Sub Print_() >     Application.ActivePrinter = "HP LaserJet"   ' put in printer name >     Sheets("Sheet 2").PrintOut Copies

$$Excel-Macros$$ Re: How can i print a range of worksheets from workbooks in a directory

Thanks, I've got that working nicely thanks. I just need it to drill through subdirectories now. On Nov 7, 3:10 pm, "Akhilesh Karna" <[EMAIL PROTECTED]> wrote: > Hi, > > Your purpose can be achieved by minor improvement in your code. You can > replace the following part of first macro. > >      

$$Excel-Macros$$ if statement benchmark

I've been benchmarking some functions in vba. When benchmarking if statements (through a loop that ran 100,000,000 times) the time differences were: # if statements - time 1 - 3.36 2 - 8.41 3 - 8.67 4 - 11.14 why is the difference between 2 & 3 almost nothing? This timing is consistent with one

$$Excel-Macros$$ Re: Using Name.Name to Access Cell Names is Slow

I think this does what you want: Public Sub GetNames() Dim n As Integer For n = 1 To ActiveWorkbook.Names.Count Sheets("Sheet2").Cells(n, 1).Value = ActiveWorkbook.Names(n).Name Next End Sub On Sun, Nov 9, 2008 at 2:04 PM, <[EMAIL PROTECTED]> wrote: > > Hi, > > I have an exce

$$Excel-Macros$$ Running a sub through sub directories

Hi Everybody, I've written some code which prints worksheets were a range is not empty for each workbook in a directory. As below. I'd like to use the getdirectory to choose the root directory. then run the Printworkbooks(spath) for each directory below it. e.g. all it's sub directories. I've ha

$$Excel-Macros$$ Picture in a workbook

Hello, We are using a function to add pictures to an Excel workbook in a VB macro, the function call looks like this: myDocument.Shapes.AddPicture _ v_url, _ True, True, v_left, v_top, 45, 65 The picture is returned from another server from the URL string that is obtained from our da

$$Excel-Macros$$ Macro for Login Page

Hi all, I need to create a login input box for a workbook.When someone open the workbook, the login input box must pop up and ask the user to key in the USER ID. The table of user id is actually in one of the sheets in the same workbook. So the macro can compare with the user input to the user

$$Excel-Macros$$ Can't Login via QueryTables to a Webpage (POST Method)

Greetings, I'm having some problems with my current VBA script in Excel. The goal is to get a table from a website with the QueryTables function. Well, works fine so far. But to access the data which I need, I have to login (username/password). The login form runs with the POST method. Here is

$$Excel-Macros$$ Re: scheduling with excel

I'm not sure how to add an attachment? On Nov 10, 1:32 am, "Akhilesh Karna" <[EMAIL PROTECTED]> wrote: > It will be much easier if you attach the file itself. Your question is not > very clear to me. > > Akhilesh > > On Fri, Nov 7, 2008 at 4:16 PM, <[EMAIL PROTECTED]> wrote: > > > I want to use

$$Excel-Macros$$ Re: scheduling with excel

I will agree... Will need the excel sheet you are talking abt so that we can play around and find a solution. Regards, Rahul aka Dude --- On Mon, 10/11/08, Akhilesh Karna <[EMAIL PROTECTED]> wrote: > From: Akhilesh Karna <[EMAIL PROTECTED]> > Subject: $$Excel-Macros$$ Re: scheduling with exc