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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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
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...
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...
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...
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
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.