Search results for query: *

Hello! I am part of a small team that is creating a webpage the feeds off of an SQL Server database. We want to add a security feature that will allow users to use their existing password for another sql server app. Many people already have these accounts. Therefore, we need a way to place...

This one may not even be possible with excel alone, but there is no harm in asking! I have a spreadsheet populated with URLs. Most of these point directly to .zip or .exe files. My task is to verify that these links indeed point to an existing file. This process must be automated and the...

The macro recorder is how I originally made the query. If the query causes future DDE messages to be ignored, then I need a way outside of a query to import it. Is that even possible??? I haven't worked with queries in excel much as I'm normally an access guy! thanks, LsiGuy

I did use get external data to create the macro that imports the text file. However, the Ignore Other Applications option is unchecked. Also, I am using Excel 2000. Is it likely that the issue with having to exit and restart Excel 97 carried over to this version? If so, does anyone have a...

I recently wrote a program at work that performs several queries on sqlserver databases on outside servers. Additionally, it dumps the results of Pulist (a WIN NT RK add-in) into a text file which is then imported into excel via a recorded macro query. This data is then compared to old process...

Hello, I am using a notepad txt file to dump log info from my VBA program. I am using the Append method to tag new info onto the bottom. Now, it is getting really big! (As I'm sure you can imagine...) Is there any way that I can tell VBA to start deleting stuff from the top once it gets to a...

Hi guys. I am trying to write a program that will go through the shell, attach to a FTP server, and get a file. My problem is, I need to be able to issue commands such as "cd" to the shell to get to the correct folder for FTPing. How can I open the shell, issue simple commands to it...

Where can I get a program to install this on my machines? Then, how do I make it install correctly? LSIGuy

Hi, I wrote a program on one computer in our lab area. I put it on the network drive and uncompiled it. It works fine on the station I was working on when I created it, but when I run it on another networked computer, it gives me an error saying it can't find the so-and-so module. What...

Hi, I wrote a program in VB for Excel and it worked perfect. Now, since I need to compile it, I have transfered it to Microsoft VB 5.0 and my OnTime statements don't work. These statements served to time out my program as it needs to run every 30 minutes. Is there any function that I can use...

Will this work if I have a user form as well?

I wrote a host pinging program for my job. It works great a continuously (Thanks to many of you guys out there). I had just one more question for this specific project. Can I compile this program into an exe or something so I don't have to have excel and VBEditor to open it? The idea is to...

Yeah, the line of code above sits within the macro Runme()

I finally got my continuously running host ping program to work. Now I am just curious if I can run it outside of excel so I can leave it running at all times without having excel and the vb-editor on my screen. any tips?

For some reason, when I put the command... Application.OnTime Now + TimeValue("00:30:00"), "Runme" into my program, it can not find the Runme macro. This macro is not visable in the the run menu, but it is there. I am attempting to use this function to have a program run...

I was instructed that in order to transfer a cmd prompt command's output to a useable txt file, I needed to make a .bat file that would run this command for me. I started with an open statement... i.e. Open ("c:\dump1.bat") For Output As #1 Then I wrote the bat file... i.e. Print #1...

Can someone please give me a pointer on how to save the output of a shell command issued through Excel VBA to a dump file? I need to be able to analyze the return to continue my program. Thanks.

I am trying to write a program that will ping a host through DOS every 30 min. I need to know how to write commands to DOS through Excels VBA and then how to make it issue that command every 30 min. The program must be running constantly so I was curious if any of you guys had any ideas...