Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: richand1
  • Content: Threads
  • Order by date
  1. richand1

    Loop through worksheet hyperlinks and save files in a different location

    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...
  2. richand1

    Loop through a table range and evaluate specific columns

    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...
  3. richand1

    Runtime Error 2147467259 - not a valid path

    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...
  4. richand1

    Printing Excel files embedded in Excel

    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...
  5. richand1

    Problems with DAO 3.6 Library

    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...
  6. richand1

    Access select query results into Excel

    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"...
  7. richand1

    Help with looping an If statement

    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")...
  8. richand1

    With Worksheets [Call Module] ?

    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...
  9. richand1

    Text File Wizard/Varying Column Widths

    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...
  10. richand1

    Using value user inputs into text box as part of File Name

    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...
  11. richand1

    Check for next blank cell in given range until range is completed

    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)...
  12. richand1

    Excel copy to end of range

    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...
  13. richand1

    Combo Box - Select */All if null?

    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...
  14. richand1

    MS Outlook 2002 Query

    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...
  15. richand1

    Excel - copy value down list

    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...
  16. richand1

    Creating a column in a view

    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...
  17. richand1

    Multiple selections in drop down menus

    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...
  18. richand1

    Access DB locked - cannot open, replace or delete DB

    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...
  19. richand1

    Link Tables - Access 97 bug...?

    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...
  20. richand1

    Referring to a workbook whose name changes

    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...

Part and Inventory Search

Back
Top