Excel Borders

pkelly — Mon, 20 Sep 2010 11:35:04 GMT

Hi...

The vb macro shown below copies a chart from QlikView, pastes into Excel then puts the borders on....

The issue I have is that I need to specify the Excel range in advance.

Is there a way of determining the range which has been output?

Thanks for any help...

Paul

sub ExcelCH510

Set chart = ActiveDocument.GetSheetObject("CH510")

XLrange = "A1:T34"

Call OutputToExcel(chart, XLrange)

end sub

Function OutputToExcel(chart, XLrange)

chart.CopyTableToClipboard true

Set XLapp = CreateObject("Excel.Application")

XLapp.Visible = True

Set XLdoc = XLapp.Workbooks.Add

Set XLsheet = XLdoc.Worksheets(1)

XLSheet.Paste

XlSheet.Range(XLrange).Select

XlSheet.Range(XLrange).Borders.ColorIndex = 0

XlSheet.Range("A1").Select

End Function

pkelly — Wed, 06 Oct 2010 11:07:38 GMT

Can anyone help me on this?

Wed, 06 Oct 2010 12:48:58 GMT

I haven't had the time to try it out myself, but i guess you should be able to use" xlDown" and "xlToRight", to select the output area.

/Martn

topic Excel Borders in QlikView