vba code modification

I have a code error that was fine with Windows 7 office 32 bit, but with Windows 8.1 Office 64 bit.. it keep marking error at the set db = opendatabase command! how do i fix this problem. or how do i rewrite the code so it works! --------- Sub AddNewProduct() Dim dbsDuke As Database...

I found a VBA script to convert a column of text to a single cell separated by spaces (see below), BUT it will only select a list of data from column A and only return the data to column B. I was able to figure out that altering the numbers in rows 7 and 8 (dataRow =# and listRow =#) will...

Hello I am trying to automate inserting of data. i have an insert button which is to copy the entries into relevant columns (see record macro below). the limitation with the macro below is when i insert new data entries it wipes out the previous one. Sub insertdata2()' ' insertdata2 Macro '...

I have a code that will autofill cells with the information listed in another cell. However, it takes forever for the code to run...I am assuming it takes so long to run because of how I have the code written. Is there a way this code could be modified? Here is the basic code...It is written...