ilcapocamorra
asked on
VisualBasical 2010 w/Excel 2007
Hi All,
I have a visual basic program that copies data from a text file puts it in a worksheet and makes a graph from the data. For some reason the exe works fine on my machine but does not well on another.
Particularly it is failing on:
metricWorkbook.Worksheets( filename). copy(after :=XLSXWork book.Works heets("She et1"))
XLSXWorkbook.ActiveSheet.N ame = MetricType
MetricType is defined as "PSNR"
filename as "DL1"
The issue is it works fine on all other machines except this one. I do not see any dependencies except .net 4.0 which is installed. :(
I have a visual basic program that copies data from a text file puts it in a worksheet and makes a graph from the data. For some reason the exe works fine on my machine but does not well on another.
Particularly it is failing on:
metricWorkbook.Worksheets(
XLSXWorkbook.ActiveSheet.N
MetricType is defined as "PSNR"
filename as "DL1"
The issue is it works fine on all other machines except this one. I do not see any dependencies except .net 4.0 which is installed. :(
ASKER
Hi Zack, thanks for the feedback, so something like:
metricWorkbook.Worksheets( filename). copy(after :=XLSXWork book.Works heets(inde x(1)))
Thanks!
metricWorkbook.Worksheets(
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
it seems to be an environmental issue:
Does the target machine has Excel 2007 installed?
If so:
Are the Excel 2007 service pack/updates the same on all machines?
How are you interfacing to Excel? (Interop, open xml)
Is th user opening the target workbook?
Does the target machine has Excel 2007 installed?
If so:
Are the Excel 2007 service pack/updates the same on all machines?
How are you interfacing to Excel? (Interop, open xml)
Is th user opening the target workbook?
Regards,
Zack Barresse