Solved

Formatting Excel sheet in VB.net 2008

Posted on 2012-12-24
3
573 Views
Last Modified: 2012-12-24
I used to have the following code in VB 2005, but it does not work in VS 2008:

        Dim ExcelOpt As New ExcelDataOnlyFormatOptions ' this line gives an error in VS 2008

            ExcelOpt.MaintainRelativeObjectPosition = True
            ExcelOpt.ExportObjectFormatting = True
            ExcelOpt.MaintainColumnAlignment = True

Any ideas how to fix it ?

Thank you
0
Comment
Question by:crcsupport
  • 2
3 Comments
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 500 total points
ID: 38719169
Did you install Office Primary Interop Assemblies?
0
 
LVL 1

Author Comment

by:crcsupport
ID: 38719297
I've requested that this question be deleted for the following reason:

i think solve the problem
0
 
LVL 1

Author Comment

by:crcsupport
ID: 38719232
yes , i did
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now