Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
page setup with Excel4 & Waiting Form
Hello all
I have 2 questions (i hope) simple questions: 1 - i have a application that was running with the normal "with ......pagesetup" but it was very,very slow.in order to increase speed i change it to the Application.ExecuteExcel4Macro XXX in fact it increases very much the speed but i have a little problem...with the other pagesetup with the fittopage function it fill all the page,but now it dont´t do that...the left margin is ok but the right one is very far from the end... here is the code i wrote: xxx = "Page.Setup(" & Head & "," & Foot & ",.393,.236,.433,.629,,false,,false,,false,1,9,{1, 1},,,,,.276,.354,false)" 2- the second one have a relation with the first one.i have a form that is show when the code begins.but when i do the form_waiting.show the macro stops until i close it.i think this is resolved with the form_waiting.show vb?????? but i don´t know what it is. Thanks in advance Miguel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FORMAT EXCEL WORKBOOK (PAGE SETUP) ALL AT ONCE INSTEAD OF BY PAGE | Excel Discussion (Misc queries) | |||
HOW DO I SETUP A PAGE IN EXCEL TO GIVE TOTALS TO ANOTHER PAGE | Excel Worksheet Functions | |||
Under Page Setup the page option of Ledger - for Office XP | Excel Discussion (Misc queries) | |||
Modeless but waiting form | Excel Programming | |||
Excel4 Call to get Function String | Excel Programming |