Dear all,

I have a main macro that opens some other excel files. The problem occurs
with only one book.

If we open the file with double clicking on it (no macros), the formats are
ok. But when we try to open it from another file, with the below code;

Sub a()
Set wb = Workbooks.Open(ThisWorkbook.Path & "\Bom_Zebom.xls")
wb.Activate
End Sub

The formats are being changed like;

3,97 changes to 3.970.000
40,68 changes to 40.680.000
0,61 changes to 0,610000

the last value, 0,610000 is in fact " 0,610000" which seems that the
values lower than 1 have around eight spaces within the new file while being
opened with the macro.

Just for your information;

1. The excel data is downloaded from SAP.
2. In Turkish, you use "." to show the multiplies of 1000, and "," to show
the decimal places. For example;

In English;
1,540.8 is written as 1.540,8 in Turkish. May be, the problem occurs because
of that, just an idea.

Could you please help how i can solve this problem ?

Thanks & regards,

Veysel

I think what is happening is when you double click the file the file is
opening with a different command line option then when you open the file
directly from excel.

Go to the following menu option
1) Right Click Start Button - Select Explore
2) Tools - Folder Options - Folder Types
3) Find XLS
4) Advance - Open - Edit

a) Post the Application used to perform Action. Include any slash options
like /e below

"C:\Program Files\Microsoft Office\Office10\EXCEL.EXE" /e

b) Is DDE checked?

c) What is the DDE message or other box info like: [open("%1")]

"SupperDuck" wrote:

> Dear all,
>
> I have a main macro that opens some other excel files. The problem occurs
> with only one book.
>
> If we open the file with double clicking on it (no macros), the formats are
> ok. But when we try to open it from another file, with the below code;
>
> Sub a()
> Set wb = Workbooks.Open(ThisWorkbook.Path & "\Bom_Zebom.xls")
> wb.Activate
> End Sub
>
> The formats are being changed like;
>
> 3,97 changes to 3.970.000
> 40,68 changes to 40.680.000
> 0,61 changes to 0,610000
>
> the last value, 0,610000 is in fact " 0,610000" which seems that the
> values lower than 1 have around eight spaces within the new file while being
> opened with the macro.
>
> Just for your information;
>
> 1. The excel data is downloaded from SAP.
> 2. In Turkish, you use "." to show the multiplies of 1000, and "," to show
> the decimal places. For example;
>
> In English;
> 1,540.8 is written as 1.540,8 in Turkish. May be, the problem occurs because
> of that, just an idea.
>
> Could you please help how i can solve this problem ?
>
> Thanks & regards,
>
> Veysel

Dear Joel,

Yesterday, when i was at home i tried to look what you have asked for
(Windows XP), but at work, i could not see the information you have asked.
There could be two reasons;

1. At work, we use Vista, not XP.
2. Maybe, we are limited users (IT departmants do not give whole control to
users...)

How can i see this on Vista? Or, what can i do without knowing the
information?

Thanks & regards,

Veysel

"Joel" wrote:

> I think what is happening is when you double click the file the file is
> opening with a different command line option then when you open the file
> directly from excel.
>
> Go to the following menu option
> 1) Right Click Start Button - Select Explore
> 2) Tools - Folder Options - Folder Types
> 3) Find XLS
> 4) Advance - Open - Edit
>
> a) Post the Application used to perform Action. Include any slash options
> like /e below
>
> "C:\Program Files\Microsoft Office\Office10\EXCEL.EXE" /e
>
> b) Is DDE checked?
>
> c) What is the DDE message or other box info like: [open("%1")]
>
> "SupperDuck" wrote:
>
> > Dear all,
> >
> > I have a main macro that opens some other excel files. The problem occurs
> > with only one book.
> >
> > If we open the file with double clicking on it (no macros), the formats are
> > ok. But when we try to open it from another file, with the below code;
> >
> > Sub a()
> > Set wb = Workbooks.Open(ThisWorkbook.Path & "\Bom_Zebom.xls")
> > wb.Activate
> > End Sub
> >
> > The formats are being changed like;
> >
> > 3,97 changes to 3.970.000
> > 40,68 changes to 40.680.000
> > 0,61 changes to 0,610000
> >
> > the last value, 0,610000 is in fact " 0,610000" which seems that the
> > values lower than 1 have around eight spaces within the new file while being
> > opened with the macro.
> >
> > Just for your information;
> >
> > 1. The excel data is downloaded from SAP.
> > 2. In Turkish, you use "." to show the multiplies of 1000, and "," to show
> > the decimal places. For example;
> >
> > In English;
> > 1,540.8 is written as 1.540,8 in Turkish. May be, the problem occurs because
> > of that, just an idea.
> >
> > Could you please help how i can solve this problem ?
> >
> > Thanks & regards,
> >
> > Veysel

I have tgo try it on my daughter lap top later today. I will get back. My
other thought would be to check the version of excel using help - about for
each of the two methods you mentioned. I was thinking you may have more than
one version of excel installed on your PC.

"SupperDuck" wrote:

> Dear Joel,
>
> Yesterday, when i was at home i tried to look what you have asked for
> (Windows XP), but at work, i could not see the information you have asked.
> There could be two reasons;
>
> 1. At work, we use Vista, not XP.
> 2. Maybe, we are limited users (IT departmants do not give whole control to
> users...)
>
> How can i see this on Vista? Or, what can i do without knowing the
> information?
>
> Thanks & regards,
>
> Veysel
>
> "Joel" wrote:
>
> > I think what is happening is when you double click the file the file is
> > opening with a different command line option then when you open the file
> > directly from excel.
> >
> > Go to the following menu option
> > 1) Right Click Start Button - Select Explore
> > 2) Tools - Folder Options - Folder Types
> > 3) Find XLS
> > 4) Advance - Open - Edit
> >
> > a) Post the Application used to perform Action. Include any slash options
> > like /e below
> >
> > "C:\Program Files\Microsoft Office\Office10\EXCEL.EXE" /e
> >
> > b) Is DDE checked?
> >
> > c) What is the DDE message or other box info like: [open("%1")]
> >
> > "SupperDuck" wrote:
> >
> > > Dear all,
> > >
> > > I have a main macro that opens some other excel files. The problem occurs
> > > with only one book.
> > >
> > > If we open the file with double clicking on it (no macros), the formats are
> > > ok. But when we try to open it from another file, with the below code;
> > >
> > > Sub a()
> > > Set wb = Workbooks.Open(ThisWorkbook.Path & "\Bom_Zebom.xls")
> > > wb.Activate
> > > End Sub
> > >
> > > The formats are being changed like;
> > >
> > > 3,97 changes to 3.970.000
> > > 40,68 changes to 40.680.000
> > > 0,61 changes to 0,610000
> > >
> > > the last value, 0,610000 is in fact " 0,610000" which seems that the
> > > values lower than 1 have around eight spaces within the new file while being
> > > opened with the macro.
> > >
> > > Just for your information;
> > >
> > > 1. The excel data is downloaded from SAP.
> > > 2. In Turkish, you use "." to show the multiplies of 1000, and "," to show
> > > the decimal places. For example;
> > >
> > > In English;
> > > 1,540.8 is written as 1.540,8 in Turkish. May be, the problem occurs because
> > > of that, just an idea.
> > >
> > > Could you please help how i can solve this problem ?
> > >
> > > Thanks & regards,
> > >
> > > Veysel

Hello,

I have tried on another computer, which has Win XP that is in our office.

When i try to see the properties, it seems that i do not have permission
(office rules). The picture is as below;


http://img222.imageshack.us/my.php?image=excelcs6.jpg


The data is downloaded from SAP... My computer has only one excel installed
(Office 2003 SP3).

Regards,

Veysel

"Joel" wrote:

> I have tgo try it on my daughter lap top later today. I will get back. My
> other thought would be to check the version of excel using help - about for
> each of the two methods you mentioned. I was thinking you may have more than
> one version of excel installed on your PC.
>
> "SupperDuck" wrote:
>
> > Dear Joel,
> >
> > Yesterday, when i was at home i tried to look what you have asked for
> > (Windows XP), but at work, i could not see the information you have asked.
> > There could be two reasons;
> >
> > 1. At work, we use Vista, not XP.
> > 2. Maybe, we are limited users (IT departmants do not give whole control to
> > users...)
> >
> > How can i see this on Vista? Or, what can i do without knowing the
> > information?
> >
> > Thanks & regards,
> >
> > Veysel
> >
> > "Joel" wrote:
> >
> > > I think what is happening is when you double click the file the file is
> > > opening with a different command line option then when you open the file
> > > directly from excel.
> > >
> > > Go to the following menu option
> > > 1) Right Click Start Button - Select Explore
> > > 2) Tools - Folder Options - Folder Types
> > > 3) Find XLS
> > > 4) Advance - Open - Edit
> > >
> > > a) Post the Application used to perform Action. Include any slash options
> > > like /e below
> > >
> > > "C:\Program Files\Microsoft Office\Office10\EXCEL.EXE" /e
> > >
> > > b) Is DDE checked?
> > >
> > > c) What is the DDE message or other box info like: [open("%1")]
> > >
> > > "SupperDuck" wrote:
> > >
> > > > Dear all,
> > > >
> > > > I have a main macro that opens some other excel files. The problem occurs
> > > > with only one book.
> > > >
> > > > If we open the file with double clicking on it (no macros), the formats are
> > > > ok. But when we try to open it from another file, with the below code;
> > > >
> > > > Sub a()
> > > > Set wb = Workbooks.Open(ThisWorkbook.Path & "\Bom_Zebom.xls")
> > > > wb.Activate
> > > > End Sub
> > > >
> > > > The formats are being changed like;
> > > >
> > > > 3,97 changes to 3.970.000
> > > > 40,68 changes to 40.680.000
> > > > 0,61 changes to 0,610000
> > > >
> > > > the last value, 0,610000 is in fact " 0,610000" which seems that the
> > > > values lower than 1 have around eight spaces within the new file while being
> > > > opened with the macro.
> > > >
> > > > Just for your information;
> > > >
> > > > 1. The excel data is downloaded from SAP.
> > > > 2. In Turkish, you use "." to show the multiplies of 1000, and "," to show
> > > > the decimal places. For example;
> > > >
> > > > In English;
> > > > 1,540.8 is written as 1.540,8 in Turkish. May be, the problem occurs because
> > > > of that, just an idea.
> > > >
> > > > Could you please help how i can solve this problem ?
> > > >
> > > > Thanks & regards,
> > > >
> > > > Veysel