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!

  • Congratulations Mike Lewis 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
  • Order by date
  1. XB9R

    Excel file locked after data import

    Hi Skip, Thanks a lot - I got it working. This is how I did it: Data > Get External Data > From other sources > From Microsoft Query > Databases tab ... UNTICK the wizard ... Select Excel Files* and drill down to a workbook ... In the Add Tables window, click the OPTIONS button and make...
  2. XB9R

    Excel file locked after data import

    Hi Skip, Thanks for your reply. Not sure whether I understand you correctly. a) When I use: Data > Get External Data > From other sources > From Microsoft Query > Databases tab ... Select Excel Files* and drill down to a workbook - I get an error that the file doesn't contain a table. I'm...
  3. 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...
  4. XB9R

    Query showing "No current record"

    Thanks for your responses. Some more background: As I told 2 db's, db2 being a copy of db1. db2 transferred to different PC. db2 worked fine until a day ago. Copied db2 back to my PC. the "No current record" stays. So same OS (XP pro), same Access 2003,... I traced the error down to SQL in a...
  5. 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...
  6. XB9R

    attachment is unreadable in LN mail

    OK, I need to give more info: ° When the attachment is created 'manualy' it sends fine & opens without any error/remark. ° When sending the same excel-file through VBA I get the above error. I would like to think that a missing/incorrect registry entry would also affect the manual approach...
  7. XB9R

    attachment is unreadable in LN mail

    Sorry, i've been away for a while. Now I'm back. The file is still tagged as .xls. On opening LN displays a message : This file is not in a recognizable format. You can however select to open the file. The file is then displayed reading something like : –6h3Â. Ä4á@!GÀüÿ€Ñx...
  8. XB9R

    attachment is unreadable in LN mail

    No ideas ? Nobody ? Dave
  9. 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...
  10. XB9R

    Excelfile send via LotusNotus using VBA is not opening

    Thx for pointing me to 2 valuable forums - can't remember what made me post in this forum... Well actually the code is in Access (VBA) We're trying to send a Lotus Notes mail with an excel file attached to it. The code works fine when we attach a text file. Attaching any file with a different...
  11. 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...
  12. XB9R

    Automatically Check for and Add/Correct References?

    It worked for me with Access ...I got the error After installing the 'Microsoft Office 12.0 Object Library' is available as a reference in Access. ... still it might not work for you ... Dave
  13. XB9R

    Automatically Check for and Add/Correct References?

    I had the same problem with a 2007 access database developed by a co-worker that used some new 2007 reference. I'm still on the 2003 version. I got around the issue by downloading & installing the Microsoft Office 2007 Viewer...
  14. XB9R

    Call shell stops working in 2003

    Thank you all for replying. I 'accidently' found the solution: Since there raised a problem with Excel2003 not recognizing a rather basic function as WEEKNUM(), I installed all of the possible addins (goto tools->addins). Solved the problem of the unknown function and also solved this problem...
  15. XB9R

    Code no longer works in Excel2003

    Thx PHV that works great Dave
  16. 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...
  17. XB9R

    Call shell stops working in 2003

    Anyone ? Or just another way to accomplish this ? Basically I just want to open some files (like excel, access, word, any other application) Dave
  18. XB9R

    Call shell stops working in 2003

    Don't wanna use the path to excel, because it is not always the same on different PC's. I've started excel succesfully from the "START - RUN" command, so the path to excel.exe is known. Also office 11.0 library is on the PC. Dave
  19. XB9R

    Call shell stops working in 2003

    Thanks for the reply. You're right: I made an typing-error -> It is like you said. Nevertheless the code works whenever there is excel97 installed on the PC. It just won't work with excel2003 and I can't figure out why. I even tried to convert the accessDB from 97 to 2003 : the code itself was...
  20. 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