View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Liedson31 Liedson31 is offline
external usenet poster
 
Posts: 42
Default 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