resolved thread

Hi all, I am not quite new to VBA in a practical sense. I have been working on this macro today but I cant seem to get it to paste for some reason, It was intended to open hyperlinked documents from a excel file, within this document is a word table, from which I run a macro to copy the...

Hi, I have a a target macro that starts with Private Sub Worksheet_Change(ByVal Target As Range) Dim Keycells as Range Set KeyCells = Range("R:R,AF:AF,AT:AT,BH:BH,BV:BV,CJ:CJ,CX:CX,DL:DL") If Not Application.Intersect(KeyCells, Range(Target.Address)) _ Is Nothing...

Hi All, I've got a problem that I think may be solvable with an array function, however I'm struggling to think of how to put it together and thought y'all would be able to help. My general task is that I'm trying to determine the data type (string, integer, double, etc..) of certain fields in...

Dear All, I searched on the internet but run out of luck. I am looking for how to write in the script the field data type. Below is my sample code to create table: Set objConnection = New ADODB.Connection With objConnection .Open strConnectString...

Dear All, I made a code which delete the old access db and create new access db and table daily basis. My code works perfectly fine but I encounter some network problem time to time which keeps locking my db open. Therefore I cannot delete the db on those occasions. All of a sudden I get this...

Hello Wizards, I'd like to ask your help with creating a macro. There is one workbook that contains a main worksheet titled "Project List". The 'Project List' worksheet has data headers or a total of 21 columns. Each row of 'Project List' contains data that must be distributed into multiple...

Hi Excel Masters, I tried to find it on net but was a bit out of luck. How can I customize the format of the number as below requirements: 1. If the number is greater or equal to appears with "k": 4,123,567 should be 4,124k 2. If the number is below 0; the number turns to red with no bracelet...

Dear Board Masters, I have been trying to learn the way to extract data from sql server to excel by using VBA (ADO procedures). I managed to write several codes to extract data then add additional code to convert some of those data using for next statements. However while dealing over 100,000...

Dear All, I have a certain data in over 2000 rows. There are staff numbers on column J to column AA in row. But sometimes the same staff numbers are dublicated in the same row different column. That is my problem. I tried to remove dublicated staff numbers from each row but could not really...

Hi Thank you for those who will help me. I have a questionnaire that generates a number sum total between 0 and 40. (in cell A1) The totals represent the following attributes: Normal 0-13 Borderline 14-16 Abnormal 17-40 How do I show the value, Normal or Borderline or Abnormal (in cell...

HI Everybody, I have a data sheet which has the skill codes of our staff in the casino. These are gaming skills such as; BJ,MD,NBC and so on I have a comboboxes which filters the data in the listbox list which works under "listbox.change" event. Whenever I change the combobox text to let say...

Hello, I came into an issue while setting up macro on a workbook i have. the issue is i need the following sets of actions to be completed when the workbook got opened programmitcally : save workbook and save as pdf. below the macro i have Private Sub Workbook_Open() ActiveWorkbook.Save...

Dear ALL, I made a code to assign conditional formating on one specific rage. That range change as with the entries and on column F if the data is 4; column B to F for that row should be strike through and red color. However, something is wrong.If I check the individual cell's conditional...

Good Morning Everyone, I am working on a project which is hopefully leading to end soon. There are some codes which slows down the whole operation. I tried to identify those code and I found one of the code takes about a minute. The purpose of that code to clear the spaces that comes from...

Hi All, I found one vllokup function from access data base in earlier posts. Thanks to the author. However, when I tried to adop in my userform as it gets the password line form access data base. But I am getting an syntax error.The error occurs in adoRS.Open Source:=strSQL...

Hi Everybody, I tried to find value on the other workbook but I am having a kind of trouble. Gives me error "Type mismatch" Can anyone help me?Below is the code in my VBA project Thanks in advance and happy weekend. Baha Private Sub Worksheet_Change(ByVal Target As Range)...

Hi Everyone, I created the access table by using VBA code. Actually I found the code on net and altered that a bit. My problem is I want the primarykey is to be autonumbered. How can I define that? Below is my code Thanks for helping me Baha Option Explicit Const TARGET_DB =...

Hi All, I have too many numbers of users who use one particular excel file. Since sharing workbook is not very much reliable, I added a code which creates access database. All data actually stores on access data base. I found the code and way on one of the very good website which was mentioned...

Hi All, I have a workbook which triggers vba code and records all data in access database. Now what I want is to open the file as read only when the username is:"pit".I do not have a hope for that but any chance that some one has a trick for that.For some reason I do not want to share workbook...

Hi All, I have a worksheet with 1000 rows with three columns. First column A is the employee numbers, column C is the employee skills as in below table1. I have a code which text to column those data. But I want them text to column in the order of table2. Anyone can help me to give an idea...