You are not logged in.

Application.run

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

SFeldmann

Trainee

  • "SFeldmann" started this thread

Posts: 1

Date of registration: May 2nd 2012

  • Send private message

1

Wednesday, May 2nd 2012, 8:04am

Application.run

Hello

The following problem. I have PALO.DATAC formulas in my sheets. PALO.DATA is not, as too slow.
I must first let the macro “Companydruck_pdf “run and after Macro “Region_SWE_pdf”. In between, the data must be calculated fresh (F9) are.

How does it work with Application.Run. For me it does not work! Please help.

The Code:
Sub Companydruck_pdf()

Dim Pfad As String
Sheets("KEY DATA").Select

ChDir "C:\Users\Feldmann_S\Desktop"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
Pfad, Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _
True

Sheets("KEY DATA").Select
End Sub
-----------------------------------------------------
Sub Region_SWE_pdf()

Dim Pfad As String
Sheets("KEY DATA").Select

ChDir "C:\Users\Feldmann_S\Desktop"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
Pfad, Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _
True

Sheets("KEY DATA").Select
End Sub

Similar threads

Used tags

PALO.DATA

Rate this thread