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--
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...
Hi all,
I just tried installing ActivePerl-5.8.8.817-MSWin32-x86-257965.msi on a Windows XP Professional machine.
I more or less accepted the default options, except I only checked the upper two checkboxes in the optional setup actions window. ("Add Perl to the PATH environment variable" and...
Wow, thanks! With some minor adjustment that was really usable!
Best regards,
Martijn Senden.
In the Beginning there was nothing, which exploded.
--Terry Pratchett, Lords and Ladies--
Hi all,
I am making a simple cash book for my own administration. I structured the input of data like this:
______________
| |
| Receipt data | Important field: Total sum on receipt.
|______________|
| 1.
|
_______?_many______
|...
Hi again!
Thanks once more!
Skip: I know, it's probably an unusual thing to want to do. I'm a project manager and for one of my projects a webdesigning agency is creating a website. The website is going to have a database with publications in it. To fill the database the designer asked me to...
Thanks all!
Skip: Yes, that's the point: I don't since I'm pasting stuff from word and I want all of the content to end up in the same cell.
John: The content is being split into several rows (one column).
Ben: That seems to be heading towards a solution for my problem. How would I replace...
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.