ok I have resolved that one on my own, I guess I had a missin referance (that I wasnt even calling) but it is ok now. BUT now when I try and run the test sub then I get a ByRef argument mismatch. what is XXXXXX is this????
I asked for help a while ago but was pulled away from my project and now am getting back to it and am in need of more help.
I am trying to communicate via VBA excel with an instrument on the GPIB. my board index is 0 and instrument address is 21.
excel dosent like ud%. it highlights it and I...
I am having a problem calling a access event procedure from excel. I added a button to envoke the procedure (as recommended in another therad).
what I really want to do is look at a cell in excel take the value and then enter that value in a text box in access. that text box in access uses a...
I am also having a problem calling a procedure from excel
Private Sub CommandButton1_Click()
'Microsoft Access database object
Dim appAccess As Object
Dim en As String
Dim r As Integer
Dim c As Integer
Set myrange = Range("A10:A60")
'Create an instance of Microsoft Access
Set...
1. I am writing this code to be used by more than myself. There are two other users. I have a NI PCMCIA GPIB card and one of the others have a NI PCI card and the other user uses a NON NI PCI GPIB card. If I use the NIGLOBAL.BAS and VBIB-32.BAS this shoule work for both NI cards but not the...
David,
My validation lists are on the same worksheet as my data but this is how I did it, but I have to click on the button to run it.
Private Sub CommandButton1_Click()
Range("F4").Select
Selection.Insert Shift:=xlDown
newvar = InputBox("Enter your new variable here")...
DSI,
I need to open html files in a directory on a hard drive they are 4 folders deep with 1 or more html files in each directory going down, and replace a bit of imformation that is incorrect. there is 7 of such folders and maybe 200 or more total files to be fixed.
I need to create a VBA file so that when a user ckicks a command button it will open ALL the files of a certin type in the directory (and sub folders) searches the files for a word or words and replaces it with what the user enters in a text box on the user form. Any ideas????
Thanks