Search results for query: *

I'm sure there used to be a feature of Excel that allowed you to create your own series so you could effectively autofill across rows and columns. I think weekdays were built in automatically but you could write and add your own. I'm now using Excel 2003 and can't find it - Have I completely...

I have some code which effectively replicates the functionality of the Search function within Windows. However, when I am searching for files and it picks up a shortcut, it is capturing the attributes of the file that the shortcut points to rather than the shortcut itself. I have looked at the...

Hi, I am trying to extract a full list of all Excel Spreadsheets on a drive showing their path and various document properties. I have found this excellent example on the web...

Hi, I am trying to extract a full list of all Excel Spreadsheets on a drive showing their path and various document properties. I have found this excellent example on the web...

Hi, Does anyone know a way of taking elapsed time away from another elapsed time and showing the correct format. Eg 00:00:44.44 - 00:00:46.08 = 00:01.64 (The 00:01.64 is the bit I'm struggling with - I currently have a formula of A1-B1 - I'm assuming this would remain the same) Thanks...

Hi, I am creating a new file from a list of rows which have columns A to U populated. The list has an Auto filter. This is then copied to a new file and the user has the option to save the file. The file name is prepopulated based on a variable and the current date using the following...

Hi, I have a database that was created in Access 97. When trying to open it in Access 2000 it says that the database was created as a read only database and therefore cannot be opened. How do I change it from read only (and can I do it from Access 2000 or do I have to do it in 97) Thanks...

Hi, Is there a way of having more than 3 criteria on an Excel conditional format range? Tiglet [reading] Duct tape is like the force; it has a light side & a dark side, and it holds the universe together.

Hi, I am trying to use quote marks within the Sendkets string but I can't get the syntax right. SendKeys "+{TAB}{ENTER}mafile.csv{TAB}{TAB}{ENTER}{TAB}/{TAB}","{TAB}{TAB}{ENTER}", True The "," in the middle of the String is what causes the problem - not really a...

Hi, I have a csv file (which I can't change the format of) which includes dates (which VBA tries to convert to US format). If I load this file into Notepad, do a find ("/") and replace (",") and then save, then open .csv in Excel, the date is now spread across 3 columns and...

Hi, How do I open new workbooks with just one worksheet in without changing the default SheetsInNewWorkbook property? Tiglet Duct tape is like the force; it has a light side & a dark side, and it holds the universe together.

Hi, I have a spreadsheet with rows of data, I would like to insert a column, ("H:H"), enter a formula in ("H1"), then copy and paste that formula down all of the rows that contain data in other columns. The problem is that the number of rows is different in each spreadsheet...

[sadeyes] I have a whole load of excel s/sheets to send out so in a separate s/sheet I have a list of filenames in Col A, the recipients in Col B & subject in Col C (See code below). However, what I can't do is send email with attachment and message body (rather than subject). Please could...

I want to be able to send emails to specified recipients, with subject line, message and attachment. I have written the following macro which extracts data from an excel list and does all of the above except adding a message and I don't know how to. Any ideas? PS Running Novell Group Wise &...

I want to be able to send emails to specified recipients, with subject line, message and attachment. I have written the following macro which extracts data from an excel list and does all of the above except adding a message and I don't know how to. Any ideas? PS Running Novell Group Wise &...