Recent content by LSIGuy

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...