Programming

Extracting date file modified from a text file.
Hi As part of an error checking control step I would like to add some VBA to a Macro which requires extracting the date of modification of a text file. Specifically I want to read the date modified property of an external .txt file before continuing to import the data from that file into my current workbook. ... 19 Apr 2010 17:48

Format sheet based on column contents
I would like to format my spreadsheet using VBA to make it more presentable. My spreadsheet is set up as follows: Col A Col B Col C Col D Yes 1 Number Text No 0 Number Text No 5 Number Text This report is generated by another application. It may contain 10 rows and columns or it may contain 1000 r... 19 Apr 2010 13:39

RegExp not matching what I want
Aha, I fixed my problem, I was iterating over the Matches instead of the Matches.SubMatches! Phil. ... 21 Apr 2010 11:33

template task pane opens when work book opens
I have a check registery template and every time the workbook is opened the help task pane pops up on the right side. The vba code for the work book must be hidden nothing shows up in the VBA project. How can I get the help task pane from opening every time I open the workbook? ... 19 Apr 2010 10:32

Progress Bar Internet Connection
Hi all, I am using Office 2003. I am trying to develop a routine with a Progress Bar that ping pongs until connection is made with the relevant URL. Once connection made and URL activated the StopFlag should be set to TRUE at which stage we exit the Ping Pong Progress bar and the application should continue ... 19 Apr 2010 08:27

macro to filter data based on selected data
Hi, I am looking for a macro that requests input of a reference code and then a date and then filters the data in my spreadsheet based on this criteria. I am using excel 2007. Any help with this will be greatly appreciated. ... 19 Apr 2010 09:30

Save as variable file name
Hi there, I've got a list of 55 cities, and I'd like a macro to go down the list one by one, and save the file with each city as the file name, so that in the end I have 55 different files, each called city1.xls and city 2.xls and so forth. I'm sure this is possible but not sure where to start! Thanks for your... 19 Apr 2010 21:56

MAC OS Excel 2008 Visual Basic Programming
Hi All I have designed a application in MS Excel 2008 on Windows XP using Visual Basic Application (VBA). Each and every thing is going fine on my side. My client is using MAC OS and MS Office for MAC. When i deployed my application to Client end one serious problem comes arise. The problem is... 19 Apr 2010 02:15

Knowing is a workbook's VBA project has password or not
Is there a way to know (using VBA code) if a workbook's VBA project is password protected? In other words, I want to be able to know if the workbook's macros are running on a password protected or un-protected VBA Poject? ... 19 Apr 2010 13:39

Format a PivotTable
I am trying to: Loop through cells in Column A If the cell is empty then format the cells from 1 cell to the right to count of used cells to the right with a line on top go to next cell do until cell equals "Grand Total" ... 18 Apr 2010 23:03