Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: ickleMouse
- Order by date
-
Import Excel Spreadsheet into existing Access table using ADODB
You say you've created an ADODB connection to the spready - I'll assume then that you've created a recordset object based on the data in the spready that you want to xfer to Access. All you need to do now is create an ADODB recordset based on the table in Access that you want to append to and...- ickleMouse
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
how to display a message for 1 second?
Have a look at the API function GetTickCount. I've even used this to make Excel 'sing' by using it "in concert", so to speak, with the Beep command. I've found it as good a way as any when it comes to timing. HTH- ickleMouse
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Tracking who has opened a workbook
I have a need to do the exact same thing. If user opens with disabled macors all they see is a sheet asking them to quit and enable macros. When enabled, the open process unhides all of the 'very hidden' sheets. The workbook open process then writes out the user info to a text file I have...- ickleMouse
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
