Search results

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...

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...

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!

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...

I have a access 2002 application with several forms. I open those forms by clicking the continue button one after another by order. Once the next form is open, the previous form will be hidden. If the next form unload, the previous form will be shown. In the last form, there are several buttons...

Hi VBA gurus, Sorry for my very limited VBA skill level in access especially when need to work on Excel automation. I need to write a function in Access vba to delete entire column or columns and shift lef in Excel. After delete the column(s), it will save the change. This function can be...

Hi Access VBA Excel automation gurus, I have been searched the web the past 2 days to find a access vba function to find a text in a excel file and return the column number, but I can not find it. Please help! The Access vba function will be allow to be reused by passing parameters. I would...

Hi Gurus, My project will be due by the end of this month. It is an urgent request for your help. I have a continous form uses a table as a record source. All of the text boxes are bounded to fields in the table. There is a check box also bounded to on Yes/No field in the table. I disabled all...