here is a snippet of my code:set ie = createobject("internetexplorer.application")
ie.navigate me.website
while ie.busy
do events
wend
ie.document.forms(me.formnumber).item("username") = me.username
ie.document.forms(me.formnumber).item("password") = me.password...
I think this has something to do with me having multiple versions of excel on my machine. This will work for me:q:
cd DIR
start excel.exe "file1" "file2"But get this...ONLY IN THE DOS PROMPT. If I write the same thing in the text editor and save it as a BAT file, only the first file will open...
Here is my batch file:
Q:
cd DIRECTORY
"FILE 1"
"FILE 2"
"FILE 3"
"FILE 4"
"FILE 5"
"FILE 5"
"FILE 5"
"FILE 6"
i AM GETTING the first file to open in excel, but the rest of them will not open. It will freeze on the first one, and not open the next one in the list until I close excel first...
thank you for all the replies. I will try them all, but I'm afraid I'm already ahead of most of them. sorry! and thanks for the help once again you guys.
Hi Folks. Here is some code to navigate automatically through IE in Visual Basic:Function FillGoogle()
Dim ie As Object
Set ie = CreateObject("internetexplorer.application")
ie.Navigate "http://www.google.com"
ie.Visible = True
While ie.busy
DoEvents 'wait until IE is done...
I would assume you can assign a variable to part of the image name as an integer, and then loop them. say for example you have 3 pictures, then name them:
pic1
pic2
pic3
then maybe write something like this with the on timer event:
dim i as integer
timerinterval = 500
i = 1...
I wonder if you could just popup an input box and get the user to input the name of the file they want in that? That way, you could assign the file extension yourself and not even let them know that you are doing it. Take it out of their hands. That is one way to do it I suppose, which is the...
puppy,
you do not need a filter to do this. All you need in your subform is an SQL statement with a WHERE clause in it as your recordsource, and then one line of code when you select the combo value. Like this:SELECT [whatever] FROM table
WHERE [state] = forms!mainformname!comboname;Then...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.