Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel Macro ActiveSheet.PageSetup
Name: Erik48 Date: May 25, 2005 at 07:38:38 Pacific OS: Windows 5.0 CPU/Ram: 1500 Mhz 655 Meg Ram
Comment:
I am having a problem with a macro executing the ActiveSheet.PageSetup function. It works when used in a macro triggered within Excel. However, I am using a call routine from DataEase to run a macro and everything works except the ActiveSheet.PageSetup. The objective is to set the margins, go to landscape and have some rows repeat at the top of each page. The following is the start of the macro: Private Sub Workbook_Open() .... With ActiveSheet.PageSetup .PrintTitleRows = "$1:$5" .PrintTitleColumns = "" End With With ActiveSheet.PageSetup .LeftHeader = "" .CenterHeader = "" .RightHeader = "" .LeftFooter = "" .CenterFooter = "Page &P of &N" .RightFooter = "" .LeftMargin = Application.InchesToPoints(0.25) .RightMargin = Application.InchesToPoints(0.25) .TopMargin = Application.InchesToPoints(0.75)
Etc.
All the other formating/calculations in the macro works.
Summary: I'm looking for some help running an excel macro as an automated task. The macro is supposed to create a data connection, import some data from a particular database, apply some formatting and formul...
Summary: Well see, the CSV is from the university database. It's the info on all the classes for the semester. Currently the university has no was to make postable schedules for each room. Thus, this excel mac...
Summary: I am new to Excel macro and I need your help. I have the following input data in Sheet 1: a1 b1 (a1 in cell A1, b1 in B2) a2 b2 (a2 in cell A2, b2 in cell B2) I need a macro to create the following ...
