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 dencom 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: XB9R
  • Content: Threads
  • Order by date
  1. XB9R

    Excel file locked after data import

    Hi All, I have exactly the same issue is described in thread707-1650324. Unfortunatly there is no solution given ... My specific case: I want to use data from an excelfile, let's say "Data.xls" and import it in "Master.xls". The data file is refreshed once a day somewhere between 2 and 6 pm...
  2. XB9R

    Query showing "No current record"

    Hi all, I have a db with a simple query: main table & detail table linked through 1 IDkey - display all records from main table and only the related records from detail table. Output is grouped: IDkey from main table and a Yes/No checkbox from the detail table. The detail table is empty (no...
  3. XB9R

    attachment is unreadable in LN mail

    Hi all, I have some VBA code to send a Lotus Notes email from MS Access. The code has the ability to attach a file. Code works fine : it creates & sends the email. There's only one issue: when attaching anything else than an .TXT file the file is unreadable for the mail-recepients. I'm using...
  4. XB9R

    Excelfile send via LotusNotus using VBA is not opening

    Hi all, I'm using some code to send an Email with an attachement. We are using Lotus Notes 7 and Excel 2003. the code: Call Body.EMBEDOBJECT(1454, "", "C:\MyFile.xls", "") It sends fine, only the file can't be opened by the receiver. Only TXT-files can be opened. Any other extension...
  5. XB9R

    Code no longer works in Excel2003

    I got following code : origpad = ThisWorkbook.Path Workbooks.Open (origpad & "\Myfile2.xls") With Workbooks("Myfile2").Sheets("Data") ' just doing my stuff here in the Myfile2 workbook ... End With Workbooks("Myfile2").Save Workbooks("Myfile2").Close Works great in Excel97 but gives error 9...
  6. XB9R

    Call shell stops working in 2003

    Hi all, I have some simple code in an Access97 that just opens an Excel file on the server. This stops working on XP2 with office2003 (and an extra install of access97). It works fine on Windows2000 + office97 and on XP2 + office97. Please do not suggest to upgrade/convert to access2003 : the...

Part and Inventory Search

Back
Top