Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Not able to setup all PageSetup's Properties

14 Jul 2011   #1
Johnraja

Windows 7 64 bit Enterprise
 
 
Not able to setup all PageSetup's Properties

Hi,

My VB application is using Excel objects for display the output. My application is working fine in Windows XP but Windows7 am facing a new problem while setting a pagesetup properties like as below

.PageSetup.LeftHeader = "&"Wide Latin, Normal"&14

I got an error 1004, "Impossible to define a property LeftHeader in PageSetup class." As like i can get an error for setting other pagesetup proprerties too.

Could you please suggest, how can i handle this issue?

Thanks in advance...

Regards
John


My System SpecsSystem Spec
.
17 Jul 2011   #2
Irene

Windows 7 Home Premium 64bit
 
 

Hello Johnraja, welcome to the forum.

VB is not one of my strengths, but maybe this will help:
Visual Basic :: Excel Run-Time Error 1004
My System SpecsSystem Spec
18 Jul 2011   #3
GEWB

Linux (Mint is primary) / XP, Win7 Home / Win7 Pro, Ultimate / Win8.1 / Win10 archived VM
 
 

Hello John -

My VBA is really rusty but some thoughts...

Do you also have "center" and "right" properties in the pagesetup? If so, perhaps "left" is competing for space.

Do you have a printer attached? Excel needs to communicate with the default printer when doing any page setup tasks. Also note that the printer driver will also come into play. For example, if you received the code from another person and their code references a Xerox printer driver but you use an HP printer driver, you could get an error.

Good luck tracking it down - please post if you find the solution!

Regards,
GEWB
My System SpecsSystem Spec
.

18 Jul 2011   #4
Johnraja

Windows 7 64 bit Enterprise
 
 
The problem has been solved

Hi All,

Due to the admin rights only i faced the pagesetup error. Now i have changed my users rights as like local admin. so i can able to set up all the available pagesetup properties.

Thanks for all your valuable support.

Regards
John
My System SpecsSystem Spec
18 Jul 2011   #5
GEWB

Linux (Mint is primary) / XP, Win7 Home / Win7 Pro, Ultimate / Win8.1 / Win10 archived VM
 
 

Hello John -

Yup, that would do it - sometimes the simplest is overlooked. Glad you posted the solution!

Regards,
GEWB
My System SpecsSystem Spec
Reply

 Not able to setup all PageSetup's Properties




Thread Tools




Similar help and support threads
Thread Forum
Why is there oftentimes a setup.exe AND a setup.msi in ONE inst packg?
When I download software from official webpages then I observe oftentimes a setup.exe AND a setup.msi within the just downloaded single *.zip installer package. Example: http://www.bctester.de/en/download.html Why are there TWO files? Shouldn't it be enough to provide only ONE (either exe...
Installation & Setup
Win7 Starter getting error on initial setup; locked in setup loop
I have several Asus Eee netbooks that I'm getting set up to use at my school. I had some parent volunteers helping me get them ready to deploy, and one of the netbooks was plugged in to initially power it up, but then hard-shut-down before Windows could run through its initial setup. Now when I...
Installation & Setup
Can;'t get into BIOS Setup or Program Boot Setup with DEL and F12
I am trying to get into BIOS Setup or Program Setup with the keys " DEL or " F12 " on my Acer Aspire M3450 - UR20P for the last few days. I am not sure why it won't happen after restarting the desktop then hit the key for BIOS or Display Boot Setup. After the desktop restarted and went right into...
General Discussion
folder properties says 2.67Gb, *.* properties says 6.41Gb
Hi; I have a folder of home videos that I back up to a USB key with Syncback. The key is nearly full and I'm trying to reduce the size of that folder. But here's the thing; If I right-click on my 'Home videos' folder and select 'Properties', it tells me I have 564 files in 85 folders, taking...
General Discussion
Tuner Setup - setup loops at accepting Channel Changer
have installed new Haupaugge HVR 2250 turner card and have to set up TV Tuner and confirm remote functions after some driver conflicts i got the card and remote working to control Shaw Digital Box via IR blaster and can see live TV when i'm on the "Test Channel Changing" page - I can see and...
Media Center


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 06:16.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App