advise

Hi I have the following formula in excel spreadsheet but would like to learn how to write in vba, please advise: 1. =IF(EXACT(C2,UPPER(C2)),MID(C2,SEARCH("(",C2)+1,SEARCH(")",C2)-SEARCH("(",C2)-1)+0,"") 2. =IF(EXACT(C2,UPPER(C2)),LEFT(C2,SEARCH("(",C2)-2),"") C2 can be any cells on column C...

Hi pleasant day to everyone. I am new to this forum and I need some advise in MS Access - Excel VBA. Starting with MSAccess, how do I read a text file line by line and put it in a VBA variable? thanks in advance. Data content of a text file hostname = 192.168.33.11 port = 3306 username =...

I have an unprotected workbook, but when trying to hide columns, I does not hide the selected columns It would be appreciated if someone could advise me

I have a process that needs to enter a formula into a cellRange("Table_RowCount").Formula = "=COUNTIF(D5:D4999," > ")" I'm not sure why but when this executes it returns 'TRUE' as text in the cell rather than the formula. Can anyone advise as to whats going on here as I've not had a problem...

What is the best practice in storing the MACRO? Is it in the personal workbook or in the workbook itself ? I have realized that I need to use the macro on different devices. Under such circumstance, I should copy back the macro one by one and save it in the workbook ? Kindly advise.

Hi! As a new member I've search thru the forum in the hunt for an answer to question, but no luck so far. There are som similar threads but none with a specific anser to my issue. I've created a workbook with a lot of soccerscores. At this point I'm forced to input the scores manually, but I'm...

Hello All, I am comparing two sheets. Changes should be saved in the new sheets. If there are any new lines, add, removed, changes I got one information from you tube, however when I try it real time scenario it not working. Please advise if anyone from the forum would be able to help me...

Hi guys I need help finding out which formula works best at find similarities between to rows. For example Row A1................... Row B2 8443..................... 1231 1554...