[AccessD] FW: Issues with Report Download

Use late binding.

Dim obj as...

instead of

dim sht as excel.sheet

etc.

Then it will work regardless of the version they have.

John W. Colby
www.ColbyConsulting.com

On 11/9/2010 11:19 AM, Rocky Smolin wrote:
> Dear List:
>
> The client below is using my E-Z-MRP system, but had me develop a fairly
> elaborate export of some of the data into a spreadsheet in a format that
> they were used to using.  While he agrees that using this spreadsheet is not
> the best solution, at the moment it was easier than trying to effect change
> among the users.
>
> However, he has now run into a problem: the 256 column limitation of Excel
> 2003, a limitation which apparently is greater in 2007.  The app is in 2003
> and, because it's a standard distributed product it is impractical to
> upgrade to 2007 (also, I'll be dipped if I'm going to be forced to develop
> and support a product in 2007 which runs like a spotted dog in 2003).
>
> So the question is how to reference the Excel 2007 library in the app
> instead of the 2003 Excel library?
>
> MTIA
>
>
> Rocky Smolin
>
> Beach Access Software
>
> 858-259-4334
>
> Skype: rocky.smolin
>
> www.e-z-mrp.com<http://www.e-z-mrp.com/>
>
> www.bchacc.com<http://www.bchacc.com/>
>
>
>
>
>
>
>    _____
>
> From:
>   Sent: Tuesday, November 09, 2010 1:24 AM
> To: 'Rocky Smolin'
> Subject: Issues with Report Download
>
>
>
> Rocky,
>
>
>
> Sorry for not being in contact regarding  the download of the product
> structure that I mentioned before, I have been hard at it correction and
> inputting data into the system, for now I think we should not spend any more
> time on this download as I seem to be managing okay using the Database
> itself.
>
>
>
> I do however have a minor problem with the MRP download report. We have now
> inputted all of our products into the system, there are now 221 assemblies
> being used.
>
>
>
> On the MRP Shortage sheet in Excel there are a number of columns giving Part
> details, Stock, Shortages etc. Then the BOM's for all parts is cross tabbed
> to the right of the sheet and the where used qty updated against each item.
>
>
>
> Problem is we now have so many assemblies we have run out of columns in
> Excel, as we are using Excel 2003 version for the download and the column
> numbers go from A to IV this is 256 columns out of this 66 columns are taken
> up with data before you get to the assemblies then 221 assemblies that's 287
> columns required with only 256 available in excel, the download creating an
> error at this point.
>
>
>
> We could of course economise in the first 66 columns as some of the old date
> columns could be taken out (Jan 2010 to Sept 2010 for example) but it would
> be better if we could run this download into Excel 2007 file rather than
> 2003 version as Excel 2007 has thousands of columns available.
>
>
>
> Currently we can not select an Excel 2007 version file from the front end.
> Can this be amended?
>
>
>
> Regards
>
>
>
> Howard
>