Hey all,
I have an 'Excel Export' function in my current project. The only problem is that the last column wants to print on separate pages. In an attempt to automatically fit the columns on to one page, I tried using the following code:
oSheet.PageSetup.FitToPagesWide = 1
When I create the excel file through Access and view the 'Page Setup', there is a '1' in the 'Fit To: # Pages Wide' textbox, however, the radio button besite 'Fit To:' is not selected.
As such, there is no change to the way the file prints.
What am I doing wrong?
I have an 'Excel Export' function in my current project. The only problem is that the last column wants to print on separate pages. In an attempt to automatically fit the columns on to one page, I tried using the following code:
oSheet.PageSetup.FitToPagesWide = 1
When I create the excel file through Access and view the 'Page Setup', there is a '1' in the 'Fit To: # Pages Wide' textbox, however, the radio button besite 'Fit To:' is not selected.
As such, there is no change to the way the file prints.
What am I doing wrong?
