I'm having some difficulty using dde to Excel and the page.setup command with the "scale" paremeter. In the help for page.setup, I can see that the scale parameter can take one of three forms:
1. A number to scale by %, ie 55 = 55%
2. Logical True = fit to 1 by 1
3. 2-dimensional array indicating fit to X pages wide by Y pages tall.
Its this third option that I'd like to use and I've seen an example passing this third option as, for example...
{1,4}
Ideally, I'd like to get the {1,#N/A} scenario to work but am yet to be successful.
Has anyone attempted/solved for this?
TIA,
Jim
1. A number to scale by %, ie 55 = 55%
2. Logical True = fit to 1 by 1
3. 2-dimensional array indicating fit to X pages wide by Y pages tall.
Its this third option that I'd like to use and I've seen an example passing this third option as, for example...
{1,4}
Ideally, I'd like to get the {1,#N/A} scenario to work but am yet to be successful.
Has anyone attempted/solved for this?
TIA,
Jim