Search results for query: *

Hi, I have some code which loops through a given folder and deposits filenames and their locations among other details into a table on a worksheet: I have some code that then loops through the Hyperlinks in the "File Link" field/column and saves these files to a static location within the...

Hi all, I've found many things like what I want, but nothing that gives me it exactly. I've been trying to get this right for 2 days now.... I have an Excel table, "ActionPlan", which starts at cell B101. The table can be variable length and forms a template which many colleagues will take and...

Hi, I have scoured the internet for the last few hours looking for solutions to this and, while I have found a lot of information around this error, I have found nothing that seems to relate to my specific issue. When I run the below code (which I have not written myself, I have pieced it...

Hi all, I have searched and searched for a solution to this but I can't seem to find one anywhere. I want to be able to embed any number of Excel files into an Excel worksheet and have the code run through each object, open it, print it and then close the object again. Sounds simples, but I...

Hello all, I have a problem that goes something like this: I have created a workbook wherein I have this module saved: Sub DAOTest() Dim db As Database Dim rs As Recordset Dim intColIndex As Integer Dim mydb As String Dim FieldName As String Dim MyCriteria As String Dim TableName As String...

Hi all. I have this ADO code to import data from an Access query to Excel: Sub Test() Dim db1 As Database Dim rs1 As Recordset Dim intColIndex1 As Integer Dim mydb1 As String Dim FieldName1 As String Dim MyCriteria1 As String Dim TableName1 As String TableName1 = "tbl_UK_All_Data"...

Can anybody suggest where I should go with this please? I would like this if statement to loop until the user clicks "Yes": Sub Period_Year_Input() Dim Answer1 As String Dim MyNote1 As String FinancialYear1 = InputBox("What financial year is this report for? (YYYY)", "Financial Year Input")...

Hi all, I have a number of sheets within a number of workbooks that are all the same in terms of format. These sheets need to be formatted regularly, and in exactly the same way, to make way for new data. Now, instead of writing a huge piece of code and copying and pasting the same code over...

Hello all. I have been scouring the internet (including this site) for help with this but have been unsuccesful thus far. I have 2 text files that I need opened in Excel using fixed width (they are not delimited), but, in all the separate pieces of code that I have found, you need to declare...

Hi all. I am working on a project that involves formatting a vast array of workbooks in exactly the same way. One of the problems I have come across is, although the bulk of the filename will be different across the books - Coffee.xls, Tea.xls, Hot Chocolate.xls, for example - the reporting...

All, I'm not too sure how to upload an example of the spreadsheet but will try and explain: I have a financial sheet that I would like to create a rolling 24 month tracker in. The periods will range from column C to column Z. In terms of rows in the range, I have a few: Income (C20:Z20)...

I've been looking all morning for a post that can help me with this, but have been unsuccessful. I need some code to copy either a formula, a vlookup or just the contents of a cell, all the way to the end of a range or table. There must be a post here from someone else asking this question...

Hi, I've got a combo box that uses a column in a table to filter out records in a subform/query. The column is for the promotion mechanic. I now need to create another combo box that will filter the subform still more by selecting the vendor who is "hosting" the promotion. My only problem here...

The IT Dept. at work have deemed it necessary to cap our email storage to 40mb. This has prompted me to create a personal folder on my hard drive to which all of my mail is now delivered to and stored. Problem solved...? No. My problem is now that my PA needs access to my calendar and, since I...

I have a list of data: Unit Number Period GB045543 2006/01 2006/02 2006/03 2006/04 GB300994 2006/01 GB329025 2006/03 This is just a small snapshot of the data list - it goes all the way down to 4,500 or...

Hi all Hopefully a quick one for you: I've used SQL Server 2000 before and the equivelent of what I need to do in Teradata's SQL Assistant would have gone like this in SQL Server: select COLUMN_A, "Help me" as Column_B So this would have inserted a new column called COLUMN_B and put the value...

Hello all, I may be just making this up, but I heard once, eons ago, that it's (maybe) possible to do this For example, in the "View" menu in Excel(2003), there's something you can do to select multiple things within that menu without the menu disappearing everytime you click. So you'd be able...

Hi All Got a bit of a problem and I'm not sure how the problem occured. My DB is a relatively small one which uses MS Query to dump data into some Excel Spreadsheets. Now, the problem occured about a week ago when I went to open the DB and append new data into it. The .ldb file was present...

God, I hope someone can explain this to me or help me sort it out - it's been the bain of my existence for two solid days now. I have written some code in Excel that cuts up a large spreadsheet and splits the data between two other spreadsheets. This all works fine. the code then saves and...

People I have a macro stored as a personal macro that will run in a spreadsheet which will have a different name everytime. My question is: Is there a way, without cutting the data into a new spreadsheet and saving that with a common name (that way just seems too messy), that I can revert...