Recent content by Thingol

Hi! Never mind! I spotted the error. It's in the line: .Cells.Find( .... After:=ActiveCell .... ) This sould have been: .Cells.Find( .... After:=.ActiveCell .... ) So I did have unqualified references Best regards, Martijn Senden. In the Beginning there was nothing, which exploded. --Terry...

Hi All, I've made a script that I use to convert a set of tab separated text files into formatted excelsheets. The script works, except that it leaves an instance of excel open, even though I think I am closing it and removing it from memory. I read about 10 threads on different fora before I...

Thanks Jerry, Our last two posts crossed each other. I tried your suggestions and they worked! I had to clean up some other errors of my own, but now the code runs smoothly! Thanks and a star! (Also for PHV, for his valid remark). Regards, Martijn Senden. p.s. The code I have now...

Hi Jerry, Yes, I still need to clean things up. :) Thanks for the tips for those extra lines of code. Problem remains: Access sees things as a variable. Maybe because DataType is something entirely different in Access (a field property) than what I'm trying to use it for? I hope someone knows...

Hi PH, Thanks for your reply. I changed my code. I still get an error (variable undefined). Below is the code I use. I highlighted the code Access doesn't understand. Best regards, Martijn Senden. Sub conversie_tekst_excel() 'Excelobjecten declareren en instellen Dim objXLApp As Object Dim...

Hi All, I have created the code below (code block 1) to convert sets of tab-separated text files to MS-excel (2000) workbooks. I want to import the excel-files into MS-Access (2000), and I would prefer to run the conversion routine from text to excel from within Access as well. This way I could...

Thanks for that feedback. By the way, I have one more question: Would it be possible to run this routine from within an Access mdb? If so, how would I have to approach this? Best regards, Martijn Senden. In the Beginning there was nothing, which exploded. --Terry Pratchett, Lords and Ladies--

Oh, and thanks for your efforts of course! :) In the Beginning there was nothing, which exploded. --Terry Pratchett, Lords and Ladies--

I figured it out! Here's the code I used (No time to clean it up or translate now, but at least it's the working code): Option Explicit Sub Tekstbestand_converteren() Dim Titel As String Dim Filter As String, Title As String, msg As String Dim i As Integer, FilterIndex As Integer...

Thanks for your replies. Using FileName(i) is what I did at first. It gave an error as well. (Subscript out of range). I put it back, but i still get the same error. Deleting the s doesn't work either. What can I do? I can't work it out! Best regards, Martijn Senden. In the Beginning there...

Thanks for your reply. I tried to use save, but it doesn't work. The file I opened wasn't an xls so it won't save as one this way. I get the same error message (13 - Type mismatch). I then tried to put an explicit filename into the saveas code, using this line: Workbooks(FileName).SaveAs...

Hi All, I'm trying to create a batch-conversion script that converts a set of text files to a set of excel workbooks. I've currently made a script that I thought would do the trick, but upon saving I get the error message: Runtime error 13: Type mismatch Below is the script I'm using (the...

Hi Shawn, Maybe this article can help you further: http://icant.co.uk/articles/tables/ Best regards, Martijn Senden. In the Beginning there was nothing, which exploded. --Terry Pratchett, Lords and Ladies--

Hi All, I've never experienced any kind of these problems before. I have an apache server with mysql and php running smoothly without any issues. I'll try installing an earlier build. I'll also try the forward slashes, although that is not something windows would normally understand. I won't...

Hi, I checked all these things before I posted here: 1. It's my own pc and I have all rights. 2. As I said, I also tried the install with all options set to default, with the exact same result. 3. I downloaded the correct binaries (As I said...