Search results

The original tab delimited text file extension is .REC. If I manually open it with notepad, it still has text wrapped. If I manually open it with wordpad, there is no text wrap. The problem I have is I use the function to directly convert the .REC file to excel. I guess it opens it as...

Thank you for help. Decompile and recompile is new to me. Does it mean that any access database we develop will automatically be compiled? I had not compiled the database and my version is access 2007. I had attached the sample txt file for your reference. I still can not figure out why the...

Sorry for responding late. I don't have time to try it until now since my friend just past away. Thanks a lot for help. I changed the code as you suggested. Unfortunately, I still got the same error. Run-time error '1004'; Application-defined or object-defined error. highlight at this line in...

I got an access vba function works well when converting regular tab delimited text file to excel file. However, when there is too many columns (178 columns)(wrapped at 114th column), the function errors out with the following error message. I will be very grateful if you can help me to resolve...

Thaks so much, plog! I change all the variable declarations to the array and use the loop incremental variable as the array index. It works like a charm. Thanks again!

Thank you so much for sending me the link to learn array and appreciate your sample code. It is very helpful for me to learn. It seems to be very promising to my problem. I will try to use array to modify the code tomorrow and let you know how it works. Thanks again. Very nice of you!

Thank you for spending time create this form. Appreciate your help. My actual issue is more complicated than simply display the value1, value2, value3. I do need a loop and use the loop incremental variable to identify file names to do data processing. The issue is it recognize variable as...

I wrote a vba subroutine to concatenate a string with the loop incremental variable to form a new variable. However, it seems like it translate it as a string rather than the variable. I tried to find the solution and found one similar issue one user had asked, but I can not find the answer. I...

I can't express my gratitude enough. The code is too good to be true. It works extremely well. I will need to study further to fully understand your codes. Thank you so much for your help!

Thank you for reply. It's a .txt file not a csv file. the fields in the text file are delimited by tab. It has about 4,000 lines. the format for each line is like this : total 9 fields 1260.400 13.437 13.352 13.347 13.432 13.460 13.266 13.430 13.757 If I use a split...

Thanks for the link. I read through that, however, I admit that I don't have enough vba knowledge and skill to start from there to achieve my goal to copy the line in the text file (with tab delimiter) to excel's multiple cells. Would you please help me further? Thanks!

Is there a way to copy a specific line in a tab delimited text file to an excel file without converting the entire text file to excel? The text file is big and the conversion to excel simply takes too long. Thanks a lot!

Thanks for replying! That numeric column originally should all have - signs if they are numeric. There are probably a couple hundreds of rows in the sheet. Maybe a few of the cells (less than 5) in the column with the cell value = "n/a" (not numeric) That's why I would like to check if...

Thank you for reply! I no longer pursue The text - Excel conversion issue. The issue I am having now is to "add back the minus signs" (multiply -1) back to the numeric cells in the specific column. That column originally has - signs for all the cells which have numbers but the - signs were...

Right. I can not go just by spaces or just by tabs. I have to eliminate the - in order to sort by those columns. Thanks.

I have to convert a text file with space, tab, and - as delimiters. In order to convert the text file to excel and then to sort the file by the columns with numeric values, I have to replace the tab and - to space first and then use space as delimiter then convert to Excel. the problem I have is...

Sorry for my stupidity. I don't mean by that. I apologize that I only have very limited knowledge in VBA especially when working from Access to automate some tasks in Excel. My knowledge in Excel is even worse than Access. I do need help to learn little by little. If you can recommend a book for...

Hi Gurus, I need to write a access vba function to pass the excel file name, sheet name, column letter as parameters and then multiply a minus sign number to all the cells in that column. How can I do that? I wrote a not working code. Would you please change it for me to make it work? Thank you...

Thank you so much! It works very well and I don't need to worry about the weird error message! I did not know before that I can use CurrentDB.Execute sqlupdate, dbFailOnError to prevent the warning message. Thanks for the great help!

You make me lol. :) Thanks for sharing! That's very true about Microsoft. Oftentimes, it's not very stable and comes up many weird problems and I have no idea what caused those issues. It did make me look bad when I had to demo the program to my boss and had no idea how to fix the issue.