excel vba 2003

Hello, I have already posted this on Stackoverflow, but I better also try here I saw a great tutorial from this gentleman: https://www.businessprogrammer.com/how-to-use-listbox-in-excel-vba-userform/ But if I only make 1 data row, I get an error: Type missmatch. Can you help me why I get this...

Hello, I have a userform on excel that connects to ms access DB, i have developed the code to display,movenext and update records but i have an issue when i try to move to the next record with SQL query that filters records. ex: SQLquery= select * from table1 where test1='unique' --- then i do...

Hi all, I have two workbooks, one consolidated data sheet with about a 100 names like this: Home - imghst free image hosting - View Image and I have to generate one workbook per name with the data and Chart for each name from the Source book as in the below image: Home - imghst free image...

Can anyone please tell me why the R1C1 formula line is giving me syntax error? I am using excel 2003. I have a dynamic range of data on report tab and trying to copy from ABC pivot table (on ABC pivot tab) to the report tab starting at the end of the dynamic range of data. I am trying to auto...

I have text (.txt) files in a folder. The text files are delimited with Tab. What i need to do is import the text files in to an excel template. The text file first line is having the column headings. The template having the columns. I am able to import the text files from a folder. But, I am...

I really hope someone can help me with this, I have an excel file with some columns and one column having file name in English and other column having the filename in other language. Now i need to do is rename the file in other language, is it possible to rename. Sample Data ID OldFileName...

Hello everyone! I really hope someone can help me with this because I need to do, i have text file data in a certain folder that I need to open and then import into Excel. I don't know how many files are going to be in the designated folder. The text file contains 1st line is column heading...

Hello, I see that there are several threads based on this topic, but being a novice Macro user, I don't feel comfortable using a previously posted code and trying to alter it for my purposes. I was wondering if anyone could assist me. I'm trying to set up a worksheet that will only show the...