Search results

I have about 70 users that will use this spreadsheet. I thought I would create a button for them to export the data as a text file. They would send me the text file and then I could combine the files and import all at once.

I have some code I would like to try and use to export data from my spreadsheet to a text file so I can import it into Access. Can someone help me put it in my spreadsheet and make it work? The vb and the spreadsheet are attached. Any help would be greatly appreciated. Thanks in advance.

I have used some code I found on the web to create a form for data entry (attached). I just changed it enough to see how it worked so don't expect much. I was wondering if anyone knows how to add some navigation buttons to the form and a way to select already created records so you can edit...

I've added it to four queries that we run morning and afternoon. Now we don't have to type in who ran them. My desire to do this was because I want to put timers on these queries/macros so that they will run automatically. I needed to eliminate any manual intervention before I could move on to...

Works perfect. I guess I was doing something wrong. When I put it in the query it works like a charm. Sorry to be such a pain. You rock. Thanks so much for the help. CB

I attached the database. It's just a shell really. Thanks so much.

Says: Sub or Function not defined This is what is in the code: Option Compare Database Private Declare Function apiGetUserName Lib "advapi32.dll" Alias _ "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long Function fOSUserName() As String ' Returns the network login name...

I was just hitting the run button from in the VB editor.

I was not able to get that to work. I pasted in a module and named it like it said. When I try to run it, it does not do anything. Any ideas?

I really have no experience with modules and code but i have tried to use code that others create. I am trying to use this code to enter in the username into a table when the user runs a particular macro. I was told that I have to convert this sub (?) into a function. This was my original way...