Export Excel

[mattyboy2000]

Hello everyone,

I've been trying to export into an excel named range. The problem I am having is that it exports all values as text (with a ' infront of all numbers).

Has anyone had this problem before and if so is there a way around it?

Thanks



Matt

 

[mattyboy2000]

Hi,

Just to let you know if your having this problem, I've fixed this problem. What I did was to export to a hidden Tab and set each cell to reference the 'Value()' from the other page.

This also means that the from sheet's format can be changed without problems.

Thanks


Matt

 

[mattyboy2000]

Hi,

I now have another problem. The table that I am using for the base has a inconsistent amount of columns. Therefore if I try to export with more columns that are expected then I get an error. Is there a way that I can export to a Named range telling it just to follow the columns across?

I know this may not make sense, but below is an example of the problem.


Month 1
=======

Date | Month1 | Month2 | Month3 | .... | Month 123


Month 2
=======
Date | Month1 | Month2 | Month3 | .... | Month 124