-
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...
-
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
-
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...
-
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...
-
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...
-
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...
-
Woza I've made a few assumptions: You have Excel 97 to 2003 (It will work in 2007, but not if there are over 65536 rows) Your top left of your data is in A1 If so, then this code should work. Sub MoveData() Dim lStartLastrow As Long , lEndLastRow As Long Dim myCell As Range Dim strJobNo As String...
-
How do i make this macro to automatically save the file without the user ackenowledging with " OK" . I want the user to skip this event so that excel shutsdown automatically after saving the file with a time stamp on it. Your contribution is highly appreciated........ Venu Private Sub Workbook_Open...
-
I have a spreadsheet of addresses that was scanned using OCR. The scanner did an acceptable job of text recognition, however due to additional Title's (i.e. MD, PhD, RN, etc) the columns in excel became wildly unmanageable. I need to extract Telephone, Fax and E-mail from a long list of contacts...
-
Is there an easy way when running this macro to prompt the user to path to the database of interest? The query will remain the same for every case; only the database that it's pulling information from will change. I've been opening the VB editor and manually changing the location name, but it...