Browse Site by Tags - Excel User Group

My Coding Technique

Dick has been kind enough to allow me to mirror posts from DDoE, but gets little back. Therefore as a guest poster I thought I would post some ramblings I made today on excel user group regarding my own particular coding techniques. (It also allows him the weekend off) I have recently been doing most...

Posted to Daily Dose of Excel (Weblog) by Anonymous on Fri, Aug 15 2008

automate sending worksheet to distribution list

Using Excel 2003, I would like to automate the process of creating a worksheet from a template, got this working, then automate sending this worksheet to a defined distribution list. I tried recording a macro but it stops after the email is called without entering the recipients and then sending the...

Posted to VBA (Forum) by rfk100 on Fri, Aug 15 2008

My Coding Technique

I have recently been doing most of my coding in Visual Studio, doing some 'real' work for a change, coding using VB.net, ASP.net and ADO.net. The environment in VS2008 is much improved over the VBE in MS Office (VBA). For example, it auto-indents and, with the addition of Developer Express's...

Posted to Nick Hodge's Excel Blog (Weblog) by Nick Hodge on Fri, Aug 15 2008

VBA development in a team environment

Does anyone have experience in developing a single file in a team environment? I have been working on this file by myself, but we have finally added one more person. I know you can't share a file that has a VBA project. So how do you go about working on the same file? Thanks

Posted to VBA (Forum) by JWiser on Tue, Jul 8 2008

Alternative to sendkeys to copy page setup

I am trying to avoid using sendkeys in one of the application. The code is simple and I am just trying to copy page setup from one worksheet to second using a hack. It selects 2 worksheets and activates the worksheet from which I want to copy the page setup and sends the keys to the page setup dialog...

Posted to VBA (Forum) by Kedark on Tue, Jul 8 2008

Reading excel file with ODBC

I am trying to use ODBC to read a closed spreadsheet. The code that I am using (see below) works, but instead of just reading the data, it is actually opening the file and reading the data. I do not understand why or how. Any ideas would be greatly appreciated. Here is the code: Public Function read_table...

Posted to VBA (Forum) by Pgmer on Mon, Jul 7 2008

Identify Empty Cells in VBA

Whenever I need to determine if a cell is blank, I call the IsEmpty function on the Value property. If IsEmpty(ActiveCell.Value) Then This anonymous blogger uses vbNullString. If ActiveCell.Value = vbNullString In other news: In Firefox, Cntl+Click on a hyperlink and it will open that link in...

Posted to Daily Dose of Excel (Weblog) by Anonymous on Thu, Jun 26 2008

Create a QueryTable from an Excel Source in VBA

Elton is trying to create a QueryTable based on a named range in a closed Excel file. When the code tries to refresh the QueryTable object, he gets an SQL Syntax Error message. Although he's sure his SQL syntax is correct, it's almost certainly not. The syntax you get from the macro [...]

Posted to Daily Dose of Excel (Weblog) by Anonymous on Tue, Jun 24 2008

Insert Rows and Add Missing Dates

I have spreadsheets which have dates listed in Column A with other data in subsequent columns. There may be multiples (even hundreds) of one date listed (see example below). 5-May-08 6-May-08 7-May-08 7-May-08 7-May-08 8-May-08 There are also missing dates (e.g. 1-May-08 to 4-May-08). Ultimately, I need...

Posted to Functions and Formulas (Forum) by theCruv on Fri, Jun 20 2008

Application object failed while trying to print

Dear All , i was trying to execute this code and found that the code would just run fine the first time i run it and sometimes not , the error it throws is as follows ..........................i tested the printers and they were just working fine.......... any guesss? Thank you all for your suggestions...

Posted to VBA (Forum) by venu on Thu, Jun 19 2008