Replies

I’d seriously think about web based reporting solutions. That way, you won’t need install anything. The users just surf to the sites with the reports. There are many ways to do this. Crystal Decisions, automating Access, ASP, …

,

I’ve heard it’s pretty good. I’ve heard that javascript is it’s programming language.

The downside is that it’s still lacking in pulling in Word or Excel files. It does a decent job, but if the document or workbook is more complicated than your average document or workbook, it chokes.

For those who communicate with many people who are using Word or Excel, then it’s probably not a good option over sticking with MS Office.

I haven’t been in the lounge in a long time, but thought I’d put in my in on this subject.

“Note that VB. Net officially supports upgrading from VB 6”

I’m not quite sure what you mean. VS.NET has upgrade wizard that helps port your VB code into VB.NET. Unfortunately, it’s not 100%. I’ve read some comments that it’s probably better to do a total rewrite to take advantage of the functionality of VB.NET instead of putting in a bunch of band-aids trying to port your VB code to VB.NET. Moving to VB.NET from VB5 or VB6 is as big or bigger change than from VB3 to VB4. Another developer I know is using VS.NET and estimates that after getting over the steep learning curve of VB.NET, he’s way more productive using VB.NET than VB6. I’m still trying to get my company to procure a copy of VS.NET.

“And what if MSFT allows all 3 of the .Net languages to be used in Office?”

Actually, I wouldn’t be surprised when Office gets the .NET treatment that all .NET enabled languages(more than 3) will work.

Here’s some links to some articles that discuss “.NET” that may help answer the question, “What is .NET?”

http://www.andymcm.com/dotnetfaq.htm%5B/url%5D

http://www.gotdotnet.com/about_new.aspx%5B/url%5D

http://www.gotdotnet.com/team/clr/about_clr.aspx%5B/url%5D

http://www.oreillynet.com/pub/a/dotnet/200…tdevletter.html%5B/url%5D

As usual with Microsoft, you need to separate marketing from reality. They are tacking the “.NET” moniker on all their products.(SQL Server.NET, Microsoft IntelliMouse.NET, MS Flight Sim 2002.NET, Microsoft Bob.NET, Bill Gates.NET…)

With the .NET Framework(which consists of the Common Language Runtime and the Class Libraries), C++, VB.NET, C#(Pronounced C sharp” – Microsoft’s answer to Java), J#(J sharp i.e. Java), and other .NET enabled languages(Perl, Python, and even COBOL) use the same set of objects/libraries from the Common Language Runtime and Class Libraries. Data types are the same across all languages. Components/classes created in one language can be used in other .NET languages.

Also, a PC installed with the .NET Framework(Win98SE or better) makes installing an app is as easy as copying it to the PC. No more DLL hell or registry baloney.

Of course VS.NET’s claim to fame is rapid application development with more emphasis on web applications and web services(SOAP & XML).

If Office could take advantage of CLR and Class Libraries, then you can do some really powerful stuff.

I’d add that I’ve seen it recommended to use XML documents instead of ini files. You’ll need to reference the MSXML parser in your project.

I wouldn’t give up on the “other end”. I work in an I.S. department for a corporation. Although resources are slim, we are certainly open to ideas. Sometimes there isn’t enough time to do all the cool things the users would like and we need to prioritize.

Anyway, I just did a search on MSDN for “internet explorer object model”. What I believe you’ll need to do is have VB create an instance of Internet Eplorer, have it surf to the URL that has the form, and then … .. I’m not exactly sure at this point. I’m guessing there’s properties and methods that you can invoke to find form fields and place text in those form fields. I’ve automated MS Word, but haven’t touched IE.

I’d think that you’d want to create your own web page for testing. It’d have a form, then you can experiment as necessary without accidently sending garbage to the other end..

Here’s a link that looks interesting, but I haven’t read much of it.

http://msdn.microsoft.com/library/default….accessingie.asp

Maybe someone else on this forum has some ideas.

Good luck..

No, that’s not an IIS program.

That’s be a client side VB program. If the “remote worker” is running Internet Explorer, then you can automate Internet Explorer and have it plug the correct fields. Of course, if they decide to change the form, then you need to change your program.

A better solution would be to export your data out of your database in something like XML, send the XML doc to your company, you company would then be able to import your XML to it’s database. No messing with forms. Basically, your taking information from your database and putting it into their database.

Oh well, gotta go.

Hmmm… I’ve seen it wherey you need to open the template by File Open, and pointing at the .dot template. Otherwise the modules are locked out. I don’t know if this works for the normal.dot.

If I understand you question, I think you want to create an IIS application. It’s essentially a VB app that serves web pages. Don’t quote me, but I think you need to mess with VB’s web classes in order to create the IIS application.

I’d be VB guru Charlotte would know something about this.

I haven’t taken a good look at the code, so here’s my

One Excel trick that helps speed things up is

Application.screenupdating = False

Then at the end of your macro put

Application.screenupdating = True

That might take care of your pesky pop-up sheet problem.

Per the KB article, I ran the regtlib. It seems to have cured the problem. I’ll keep an eye on it for the next couple of days. If it doesn’t cure the problem, I’ll try the late binding recommendation in the KB article. Late binding won’t be a big problem in this program.

Someone( ) should promote you to at least a Star Lounger.

Thanks again.

This looks very interesting and promising.

I’ll give this a shot.
Since my weekend starts in less than 10 minutes, I’ll post later on the results.

THANKS!

That’s a good . The funny thing is that I’m not surprised that this could fix the problem. One time, I had an Excel macro blowing up for no reason. I exported the code and imported it into a new workbook and it worked perfectly.

I’ll try exportin’ the forms and modules to another VB project and see if it magically cures the problem.

The code needs some work. More error checking for one thing. This was before I discovered JMail. Although I don’t see anywhere why Word would be detonating. I’ve got references to the scripting runtime and Word 9.0 object library.

The program compiles a list of Word documents in one folder, a list of PDF files in another folder, and tries to make the PDF files match the Word files. We have a group of users who don’t use Word, but need to read these documents from their Sun boxes. Creating PDF versions of the Word documents was the best solution.

I’ve had this problem even after rebooting the NT box. The job of the NT box that the program runs on is to just run jobs, and there’s no other jobs that do anything with Word.

Well, if you have any ideas, let me know. I’m tired of see this job crashed when I come to work in the morning.

Loungers

PrivateProfileWhat? …[searches MSDN]… I had to look that one up. … veddy interesting. I guess I should change my name from VBNerd to VBIgnorant.

Argh, I just finished an Excel application that remembers some settings in a file. I just used the FSO towrite/read the file.

Earlier this year I attended some free MS lectures/seminars/classes on XML. One of the applications that was recommended for XML was replacing INI files with XML files. INI files aren’t that hard to read, but I guess using XML would standardize the format and allow other applications if needed to be able to read and write these files. The problem is that you need to reference another DLL in your projects and reading/writing an XML file is a little tricky. Maybe it’s a little too bleeding edge and future versions of WIndows & Office will make this easier. I didn’t do it in the Excel application because I didn’t want to have to install anything on the user’s PC.

Have any of you used XML to read/write your files with app settings? What’s your experience with it?

You’ll find that ASP code runs faster if it doesn’t have to switch back and forth between ASP and HTML. Staying in ASP and spitting your HTML through response.write “html code” speeds it up significantly.