Replies

Just brain stormin’ again.

Maybe have a single post that is the FAQ. No one can reply to it. Have it bubble up to the top. It could even point to threads that elaborate on the answers. Then again, would anyone read it?

Some interesting points brought up in this thread.

Just brain stormin’ here, but there’s two things I can think of that might help.(Hey, we need a brainstorming smiley!)

• Would there be a way in your profile to put what you think your programming expertise is? Maybe on a 1 to 10 scale.(1 being “What’s a program?” and 10 being “I write API calls in my sleep.”) Then others responding to your posts can respond appropriately.
• Also, is it time for a FAQ? As with most boards, the same questions get asked over and over. Is there a way to make a FAQ thread always bubble to the top of the list no matter what?
  [/list]

I tend to agree with TomG on this one.
One of my co-workers says something to the tune of “If you have a hammer, all your problems are nails.” We tend to try to solve problems the same way over and over. If you’re a VB/VBA programmer, then all your problems can be solved by writing VB/VBA. You don’t gravitate toward finding another solution to the problem. Microsoft has packed piles of functionality into these Office apps. Only Woody knows a higher percentage of it than most, and he’s making it known as fast as he can. Years ago, I took an advanced Excel class and I was blown away by advanced filtering, subtotals, pivot tables and other advanced features that are somewhat buried and not easily understood. As programmers, we need to know these things or we’re just wasting our time duplicating functionality that already exists in the app. We can solve many peoples problems by just showing them the functionality that exists in the apps, and not having to write a single line of code. Also, we can spend less time writing our programs if we take advantage of this functionality.

I’m not 100% certain, but ASP.NET supports any .NET language. C#, VB.NET, C++. You won’t need to write VBScript in ASP.NET, you can use VB.NET.

I’m thinking the FileSystemObject might do the trick. Unfortunately, I don’t see any method to rename files which would mean you’d need to copy to the new name and delete the old file.

I never could find a way to put a timer into Word. Instead I wrote a VB program that automates Word and sets the timer. After the timer runs out(The program set it for a minute), the program checks the number of documents in the print spool. If there are still some, the program set the timer again until the number of docs in the print spool is zero.

This was for a program that converted piles of documents to PDF on a daily basis.

Application.LudicriousSpeed = True

I agree with Andrew. We’d need to see the code.

One thing I can think of is to use the With statment. The less periods you drill down, the better performance you get. At least I think I had heard that somewhere.

Thanks for the response.

Perhaps I didn’t explain properly. When you click on a link to an Excel workbook on a web page. The Excel workbook opens inside of IE provided you have Excel on your PC. Unfortunately, when IE and Excel enter into this unholy relationship, VBA programs in the Excel workbook do not behave properly.

What I’d like to do without asking the user to tweak IE, is when a user clicks on a link to the Excel workbook, Excel opens up NOT in IE but normally. They’d still get the run from current location or save it dialog, but Excel would not run within IE.

This is on our intranet. The users run IE4 & IE5 and all minor versions inbetween.

Does that make any sense?

I’m not sure I can help, but I can sympathize. I have strange occasional problems with automating Word 2K SP1 from VB6 SP5. Sometimes the “method ~ of object ~ failed” error appears. I can usually cure it by rebooting the NT4 SP6A box or launching Word and then closing Word. Anything is the MS KB about your error?

Excel 95 had ~16,000 rows. Excel 97 & later versions have 65,536 rows. I can’t say I’ve ever come close to that, but apparently I does happen.

You can create a couple of textstream objects.

Everything I’ve heard about digitally signing your macros is more trouble than it’s worth. The last I heard, Verisign would no longer give digital certificates to single developers. In a corporate/business environment getting Microsoft’s Certificate Server up and running is more painful than sticking bamboo up your fingernails, and getting a corporate digital certificate is very expensive. What are the alternatives for someone who develops Office VBA solutions for internal corporate use? Having everyone set their macro security to medium? Installing your macros in the back door startup folder?

Any ideas would be appreciated.

“When it chokes on a page, it’s generally the fault of the page.”

I don’t use Opera but a co-worker does. Opera follows the w3c specs to a t. That’s both its blessing and its curse. Far too many web pages cater to IE since it’s the most popular. The page might work and look good in IE, but it doesn’t follow the W3c spec so Opera will choke on it.

I’m not worthy I’m not worthy

That did the trick! MSForms.ListBox!

Thanks Rob & Kevin(Hey, you were close.)

Don’t keep us in suspense. Tell us how you solved it! Maybe someone out there has a similar problem.