Search results

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

Thank you, JR. Without oXL.Save, I got save as dialog box. With it, I got "A file name 'RESUME.XLW' already exists in this location. Do you want to replace it?" I googled it and I changed oXL.Save to oXL.Activeworkbook.save and it works fine now. However, I used the same method in another...

Thank you, JR. I think some how the access vba open it behind the scene without releasing it and cause the file to be read only. So it always ask to save as and to replace the existing file. Any suggestion? Thanks!

Thank you, JR! How to clear the rouge excel instances in memory? I did kill all the Excel processes from windows task manager, but the pop up dialog box still shows: A file name 'RESUME.XLW' already exists in this location. Do you want to replace it?

Thank you so much, JR! It works better! The first time I ran, there is no error or any pop up dialog box and it did delete the column. However, the second time and later, when I click the button, I got a pop up dialog : A file name 'RESUME.XLW' already exists in this location. Do you want to...

Thank you so much, JR. It did not error out, but it pop out a windows save as dialog box. When I say I want to save (replace the original file) it says the file is already existing, do you want to replace it? If I say yes, it say you can not access the file, it may be read only. I don't want...

Thank you so much for keep trying to help me! The input parameters are like this. It's weird that the code error out. What version of Access you are using? Thanks. Private Sub cmd1_Click() Dim bookname As String bookname = "c:\file1.xls" Dim sheetname As String sheetname = "file1" Dim...

Thank you! Yes, it did the deletion successfully.

Thank you so much! I still got "Run-time error '1004'; Application-defined or object-defined error" on the line oSheet.Range(cellcolumn).EntireColumn.Delete xlShiftToLeft I wonder that if the version of access make difference. I am using access 2000. Thank you!

Thank you for keep helping me. I got the error: Run-time error '1004'; Method 'Range' of object '_Worksheet' failed. The error falls on the line: oSheet.Range(cellcolumn).EntireColumn.Delete xlShiftToLeft

Thank you. Here is the command button which calls the function. Private Sub cmd1_Click() Dim bookname As String bookname = "c:\file1.xls" Dim sheetname As String sheetname = "file1" Dim cellcolumn As String cellcolumn = "H2" Call DeleteColumn(bookname, sheetname, cellcolumn) End Sub

I got the same error on the line :( oSheet.Columns(cellcolumn).Delete xlShiftToLeft Thank you!

ByteMyzer, Thank you so much for help. I got an run-time error '1004'; Application defined or Object defined error on the line oWKSource.Worksheets(strSourceSheet).Columns(cellcolumn).Delete xlShiftToLeft Please help me again! Thank you very much!

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

fantastic!! It works! Thank you so much for all your help!!

Thank you so much for help! I tried to test it in a command button, but get a "subscript out of range" error on the line "myCol = myArray(1)" :confused: myString = GetTheColumn1(theFile, sheet, theString) Dim myArray() As String If Len(myString) > 0 Then myArray = Split(myString, ",") myRow =...

Thank you so much, SpentGeezer! It's very nice of you! It works perfectly! This is exactly what I need! Question: I want to use another function and within that function, assign a variable to the return value of your function. In case I want to get the 2 return values for column and row, how...

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

thanks for responding. Bob, Thanks for responding. No. I don't want to enable the text box from the checkbox. Do I need to enable the text box to make it work? The code is like the following. (the original SQLs are too long, here I make a short one to make it easier to read.) The SQLs should...

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