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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Spooku777

  1. Spooku777

    HELP: Send a file from office program issue

    This seems to be a common problem - lot of forums ask the question - not always an answer. A couple of possible solutions: OLEXP: "Send To" and E-mail Links Do Not Work Using Outlook Express as Default http://support.microsoft.com/?kbid=306098 From another forum this post (marked as...
  2. Spooku777

    Unable to open word 2000 documents in e-mail attachments

    The Office 2000 installation could be the culprit. I recall some time ago here at work the PC/LAN support guys stressed that it was very important to first uninstall existing Word versions before upgrading to Word 2000. (this was using an automated mechanism on the network). The PC/Lan Support...
  3. Spooku777

    Disable buttons in excel

    The buttons are easy btnSave.Enabled = False To "disable" cells you have to set the Locked property for each cell and then set the sheet to be Protected. VBA terms to use are Locked, Protect and Unprotect Range("A1").Locked = True Sheet1.Protect Sheet1.Unprotect Spook :-j
  4. Spooku777

    Append data from an Excel file to another without opening files

    If MS Query is not your style you could use the ActiveX objects as Skip suggested. To open the workbook in the background: Set XL = CreateObject("Excel.Application") Set MasterWbk = XL.Workbooks.Open(FileName:="C:\Temp\MyMasterFile.xls") FName = "C:\Temp\MyDataFile.xls" Set Wbk =...
  5. Spooku777

    Opening and Saving new Excel Workbooks from Access VBA

    When you perform a SaveAs in Word or Excel it still "remembers" the original file - I could be wrong but I've had issues with this in the past. Maybe something to do with the temporary file in the background. Since your using Excel you may be better off performing a SaveCopyAs then opening...
  6. Spooku777

    Excel file taking a long time to open

    One thing to check is the UsedRange Even blank cells in your UsedRange can take up storage/memory. Sometimes if you've delete/cleared a swag of cells or rows then the used range can still be large and artificially inflate the size of your file. Perform a Ctl+Shift+End to see where the...
  7. Spooku777

    Excel Formula Help!!!

    Try this formula in B1 on Sheet1 =IF(A1=Sheet2!A1,A1,"") or =IF(A1=Sheet2!A1,"Match","No Match") You can then copy and paste the formula down column B and it will keep the relative references eg. copying the formula to B4 will result in =IF(A4=Sheet2!A4,A4,"")
  8. Spooku777

    Keep cells hidden when using autofilter

    One possible solution is to put your hidden row above the filter row - that is, above the row with the filters dropdowns. I'm assuming you have a header row in Row 1 of the sheet. So, if you unhide your Default Info row, cut it and insert paste it to Row 1 (then hide it again) all the...
  9. Spooku777

    How to Maintain Formulas of Copy and Cut

    The easiest way without a macro is to Copy the formula text and paste it... 1. Double click the cell with the formula you want (eg A3) 2. Select the formula text 3. Copy it (Ctl+C, or right-mouse click and copy) 4. Paste it to your destination cell (B3) But if you really want to use...
  10. Spooku777

    Using Dir command to loop through documents

    Note sure why DIR doesn't work except on the first one. You could use FileSystemObject to list files. See sample code below (new bits highlighted in red) Note - there's a check to make sure it's a Word document before opening it the Word application. - For loop is used rather than While...
  11. Spooku777

    Using Dir command to loop through documents

    This all depends on the string in the first use of DIR. The initial use of DIR should be for path only. Path and document name only returns that filename string and subsequent use of DIR returns nothing. And make sure the FIRST use of DIR includes path only with "\" at the end of the string to...
See more

Part and Inventory Search

Back
Top