Question on Excel automation in VB ... cant input page count.
Posted on 2005-04-20
I am trying to input automatically a page count in a footer of an excel speadsheet.
I am using the following code :
xlsSheet.PageSetup.RightFooter = "Page &[Page] of &[Pages]"
However it doesnt work. The code actually puts in this string in the footer but when I open the excell speardsheet it wouldnt show page count but the string itself.
I need to go to page setup/footer and I dont even have to change the string, only click ok and page starts showing.
Any ideas ??