I am trying to modify my macro for the import of XML files. I want the new macro to open CSV files. I attempted it but encountered a problem with the syntax for the Open Filename procedure.
Just below is the code with the problem. Further down is the whole script.
Please somebody assist in debugging this problem.
Please Login or Register to view this content.Please Login or Register to view this content.
Last edited by dschmitt; 06-16-2010 at 10:30 PM.
found the problem.
Please Login or Register to view this content.
I have another problem with the Workbooks.Open Filename procedure.
The script line below opens the comma delimited CSV file in a new workbook. That means if I execute the macro in one workbook the data will appear in a newly created workbook.
That's bad. I need the data in the workbook in which I execute the macro. Is there a way to modify the script below so that I can achieve that?
I tried ActiveWorkbook and ActiveWorksheet but both don't work.
Please Login or Register to view this content.
One work-around can be to copy data from new workbook, paste in your workbook (ehich has macro), and close the new workbook.
hth
Ajay
yes, that one I already thought about. The other one is to import the data. I am working on that too. But with that I am having a problem. I may have to ask a question about that tomorrow.
Anyway, I hope that there is a more elegant way than to copy the data and delete the workbook.
You either copy or you import; no other choices since if you open a workbook, you obviously get a new workbook opened!
Remember what the dormouse said
Feed your head
I was afraid I would receive this sobering answer abruptly pulling me out of my dream
Thanks.
That may be the first time I've ever been accused of sobering things up...
I decided to go with the open file method.
The below macro does copy the data from the opened csv file to my main workbook. However, closing the csv workbook gives me a "script out of range error".
Please somebody help to debug this step. Also please include a handler that deals with the keep/not keep info in the clipboard at closing.
Below is the line that gives me the error. Furtherdown is the complete sub. Attached is a test.csv file.
Please Login or Register to view this content.Please Login or Register to view this content.
Last edited by dschmitt; 06-16-2010 at 10:01 PM.
I solved the problem that I had with closing the csv workbook. See script below.
But I am still looking for code to handle the question about what to do with the large data in the clipboard.
Please Login or Register to view this content.
solved it.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks