o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

Pagesetup is slower than a snail! How can I speed it up -

I create diagrams via VBA in Excel. Everything works neat and at a reasonable speed except all of the pagesetup functions. Those all need a few seconds each! In total this takes up 20 - 30 secs for EACH diagram. Is there a way to either speed things up or define that stuff once and for all either by code or manually?

thx,

Helger

 

Pagesetup is slower than a snail! How can I speed it up -
I create diagrams via VBA in Excel. Everything works neat and at a reasonable speed except all of the pagesetup functions. Those all need a few seconds each! In total this takes up 20 - 30 secs for EACH diagram. Is there a way to either speed things up or define that stuff once and for

Excel pagesetup slow on fast machine, fast on slow one - why -
I have some code that produces diagram in Excel adds them as new forms and in the end sets up the page for printing. I need to run this on two machines. Both NT4 SP6, Excel2000, Laser Jet 2100TN. While on one machine(actually the one with the slower CPU and less RAM) the code execut

[Excel 2003] Print page setup appears to take 30 secs or more -
Hi, I have done a record macro, tweaked it to use objects but I have noticed that the excel app takes ages setting each option on the sheet. Is there a way of speeding this up? Code: sht.PageSetup.Orientation = xlLandscape sht.PageSetup.Ce

VB, Speed & Ability -
I was wondering. Why is VB so much slower than Delphi & C++? Like 50 times slower, and why is there so much stuff you can do with C++ that you can't do with VB? Is there anything that you can do in VB to make it faster? I've noticed that VB's loops are reallly slow. Thanks.

Wossname... and whoever else -
What's up with the grumpy snail? I'm working on my own first robot project and was curious how the grumpy snail is going. Also, did he ever talk over Wi-Fi?

Snail EMail -
I sent someone an email on 17th February 2006, and they have just opened it today, five mopnths later. Anyone had any slower responses?

slowing down system time (SPEED CHEAT) -
I am an avid online player.. and if any of you are then you know by my subject header what I am describing. For those that don't: Speed cheaters can run very fast and zip across playing fields in online games because the cheat supposedly makes the Windows OS think it is running sl

Speed Question[Solved] -
Is having 1 if statement with 4 questions (something like x < 0 and y > 0 and y < 5 and x < 5), faster or slower then having 4 seperate if then statements with 1 each? Also, is an if statement that comes to false a high detriment to speed?

How to import PageSetup attributes from Excel -
Esteemed Forum Participants and Lurkers: I can open and manipulate data in an Excel Spreadsheet (Excel 97-SR2), but is there any way to read/import the PageSetup attributes? I especially need to see the "PageSetup.CenterHeader" value. Thank you for any and all comments

Is VB.Net really as slow as this... -
okay, as some may have noticed, i started the thread on performance timers... which is now sorted. But having got it sorted, my time comparisons are a little *bad* as you can see: okay, first up - test machine: 700mhz Athlon Thunderbird / 288mb PC100 RAM (ie, not slow!) I'm t

Excel PageSetup Zoom category -
Hi, I've got some code that has run fine on a web server for years, I moved it to a new server this week and now get the error message below. As far as I can tell everything is identical, windows 2003 server IIS6, same version of excel. Can anyone help? I've tried installing a pr

VB6 vs VC++ 6 -
Hello, I am really curious to know about the speed comparison between VB6 and VC++6. Some say that VB6 is much slower than VC++ 6. Is that true ?? Please explain... About the MFC libraries in C : isn't it slower to use the MFC instread of calling the fundamental libraries (

[2005] For graphics stick with VB03. VB05 noticeably slower. -
I've noticed that no one has replied to my thread, "Upgraded program from 03 to 05. Graphics running much slower." I've been looking at more of the screens in my computer art program in its VB05 version and I've decided I'm going back to VB03. Many of the screens are running

Anyway to speed up form loading -
Does anyone know of anyway that it would be possible to speed up the process of loading forms. With VB6, forms (simple ones) was extremely fast but with VB.net, the initial loading of a form (even the simplest one) takes very long. Although it gets better once it's loaded once and t

*AIR HOCKEY*...need serious help making this game work!... -
Ok, I've started to make an air hockey game in VB...i've been using VB for about a year now...so I am familiar with the 'basic' code and commands...i got most of the main game running but i have some serious problems... things needed to be fixed: -puck sometimes goes through the

Compiled code is slower -
Hi All, Does anyone know of any reasons why a compiled project should run slower than when the project is run from within the VB6 development environment. This is happening to me on my works machine (my home machine seems to run the compiled version fine, both XP Pro) and I would li

Extra Component Faster of Slower -
Hello, I wanted to know if when I make an extra component, will my application become slower of faster. The extra ActiveX UserControl takes care of some functions. This was easier to do that to maken te program handle the functions directly (trust me ). Anyway, i was wondering i

Stream cypher in .NET is slower than VB6! -
I'm upgrading from VB6 to VB.NET. In VB6 I used a custom RC4 class to encrypt big strings (about 1MB) and its fast enough to be no delay for users. In .net I've not found anything as fast. There are lots of examples for encrypting to and from files but what about from string to s

[2005] Programatically Get & Set the Page Margin from RDLC Report viewer -
Dear Friends I am facing a serious problem while Set & Get the Page Margin, Paper Size, Orientation etc to & from the RDLC - Report Viewer Page setup dialog. I want to do this in Programatically. Note : 1. Programatically I can able to get the default values of Pag

ADO v DAO speed -
I've read on different sites that ADO is faster than DAO yet on others they say DAO is faster than ADO. I've always worked with ADO but on converting a DAO project to ADO that i've taken over, i've found ADO to be a lot slower Attached is an example of how importing a CSV fil

Slow query performance VBA -
Hi! I have a Excel macro that queyes a sql server about 2000 times every time I run it. My problem is that the macro gets slower and slower everytime I use it, eventhough I delete old querytables after almost every query I send. It's not a problem with the sql server. If I copy the m

Excel page setup -
I have this code Code: For Each tab As Excel.Worksheet In WB.Worksheets tab.PageSetup.Orientation = Excel.XlPageOrientation.xlLandscape tab.PageSetup. tab.PageSetup.FitToPagesWide = 1 tab.PageSetup.CenterFooter = "STANDA

How To Make The Mouse Cursor Move Slower -
Hey , i have a game (Warcraft 2 ) that the mouse scroller is too fast i was thining , maybe its possible to write a small program to make the mouse pointer move slower i know that the mouse is related to int 33$ , but i cant remember how to set it up and another question is

error while seeting pagesetup property in vb 6.0 -
hi, i am getting the following error while setting page property for excel here i am giving the code which i am using in the application Error: 1004- Unable to set Zoom property of the PageSetup class Code: 'Setting Fit to Page With xBook.Worksheets(1).PageSetup .Zo

ani button help -
how can i make the frames go slower than what they do. i have tried using form1.anibutton1.speed = 1000 (or another #) but it doesnt work

Problem setting margins when creating an excel doc in ASP.NET -
Here's the deal: I have a web application that, when called, creates an Excel 2003 document on the web server, then redirects the user to the excel document. Everything's working fine except for one part: Setting up the margins on the page. This is the code I'm using: Code:

Access 97 VBA speed -
Alright, I know Access97 is old and shouldn't be used anymore but that's what I have right now. I just started this job about 2 months ago and this is what my predesessor used so I have to use it until I have time to upgrade. Now my problem is this, I have two modules that run almost

Super fast square root approximation -
Just as the title says. I'm doing a force mapping function, which works very well, but is slower than I'd like. Right now, I'm forced to use Math.Sqrt for every force point on the map, then once more to get total force out of the X and Y vectors... and this is done for every pixel on a

Speed up process -
Is it possible to speed up a process I'm doing in word? I've written a function that loads a file line by line, creates a new row in my table, and inserts data from the file accordingly - this works fine, but I have 2000 entries, and since Word shows everything(tables being made, etc.)

so far no one has been able to help -
i'm using VB 6.0 to open word and create a new document. in the document i need to center some of the text but VB doesn't recognize the word constant wdAlignParagraphCenter i'm using the following code and it isn't working: Set FormsList = CreateObject("word.application"

Speed problems... -
I got an assignment in school to create a game. I'm using DX7 and VB to create it. I have a couple of problems with it:The background of the game is constant, and blitting it on the buffer every cycle in my loop eats up a lot of time. Since it's a constant background, can it be 'fixed'

Anybody tried VB.NET -
Hi! Did anyone try VB.NET (not beta)? I am curious how it performs resource-wise (does it run as well as VB 6 or much slower)? Looks like it finally has all a developer might want from a programming language, but speed is still an issue for most people. Thanks a lot in advance,

TimeOut on MSDE but not on SQL Server -
Hi All I am getting "SQL server does not existsor access denied" error when I am running my VB6 app on msde database. Same app is working fine if the database is in SQL Server. App use two databases. I am getting error when transfering records from one database to another

c++.net -
i dont get it...what is the advantage? c++ is known for it speed...c++.net is a bit slower than c++6. c++ almost doesnt have runtimes..c++.net needs the framework c++ uses win libraries(i think)...then why use framework ones? hm.....what are the advantages of using c++.ne

Slow Motion Video -
Hi there, Is it at all possible to play a video file at a slower than normal speed using the Multimedia Control? Thanks, GT

Windows Vista is absolutely fantastic! If you want to slow your computer down a lot. -
I just upgraded to Windows Vista Business from Windows XP Home. I've been installing updates for more than a day now. I've noticed before and after the updates that the Visual Basic 2008 application I've been working on for some time that was originally a Visual Basic.NET 2003 applicat

VS.NET 2003 getting slower.... -
Hi, Because of my poor coding skills, I always debug in VS.NET 2003, and need to run my code again and again. My code usually retrieve data from sql server using dataadapter, and do some processing on the datatable. I notice that the VS.NET response slower and slower as I use for

How do I format PageSetup in Excel from Access using VBA -
Does anyone have any suggestions about programming PageSetup in Excel from within Access using VBA? For example, the following variations of code do not work: .PaperSize = xlPaperLegal .xlPaperSize.xlPaperLegal .PaperSize.PaperLegal Thanks

Help With Maze Game -
Hi im Simon and im new to the forums because i have only recently got a hold of a copy of VB. I was wondering if anyone could help me withthis problem. I'm making a maze game and i have assigned the snail to the arrow keys so it can move about on the form but how can i make it so

Pdf to Rtf -
Hi all, i am in need to convert the pdf file to rtf file.. i did it using an third party component, now i have to set page orientation, and page size to the converted RTF,. Converted RTFo is an string only, Already i did these all to Excel, Code: If Orientation = 1 Then