$$Excel-Macros$$ Re: Need some vba code to copy and paste automatically when the file is opened, only last day of month

This is a lengthy solution and since I am still a novice, I welcome anyone to condense the code down where applicable. I added a component that will make sure you can't duplicate a month. Sub ValueClone() Dim lngLastCol As Long Dim lngLastRow As Long Dim wsMetrics As Worksheet Dim varMonth As Va

$$Excel-Macros$$ Need some vba code to copy and paste automatically when the file is opened, only last day of month

the data I am copying always lies in A1:F5 On the last day of the month I need to copy B1:F5 to B10:F15 and put the month name in B9; after that it would go to the next empty column (in this case E) and paste again for the next month. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do y

$$Excel-Macros$$ Re: excel vba userform using & data store in access database

Tick on below and click ok try after. Or if getting error after that then share Access or excel

Re: $$Excel-Macros$$ excel vba userform using & data store in access database

what error? I added it to my VBA project.I think you need adodb.Connection(see the ".") Dim con as new adodb.connection Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To

$$Excel-Macros$$ excel vba userform using & data store in access database

Hi Everyone, I have created a userform where i want the data to be stored in access automatically, However i have written some code, where in start only i m getting error at the * Dim con as new adodb connection * Can some please tell me why is this error occurring, or how to come overview