Serious problem in saving file

[aviadht]

Hi,

I have developed a macro for my users, the macro contains a form with an active X control of "datepicker" that i installed a long time ago.

after few days i have noticed that some of the users can save the file and some of them not becouse of the datepicker (all the users have excel 2010).

How can i help my users to save the file ?
I must install the control in each computer ?

Urgent!!
Thanks,
Aviad

 

[bensonsearch]

Hi,

I have developed a macro for my users, the macro contains a form with an active X control of "datepicker" that i installed a long time ago.

after few days i have noticed that some of the users can save the file and some of them not becouse of the datepicker (all the users have excel 2010).

How can i help my users to save the file ?
I must install the control in each computer ?

Urgent!!
Thanks,
Aviad

Hi,
What is the differance between the people that can and can't save?
if its the controls not being installed then yes, install them. could be anything.

Cheers

 

[aviadht]

OK, but they the users are not going to develop anything.. how can i be sure that the user have all the controls installed ?

Is there any package of "All controllos" that i can download and install ?

Thanks,
Aviad

 

[bensonsearch]

OK, but they the users are not going to develop anything.. how can i be sure that the user have all the controls installed ?

Is there any package of "All controllos" that i can download and install ?

Thanks,
Aviad

maybe i should have asked what controls are we talking about.?

If you mean controls needed to make it work, then all users need this. if a referance libaray then they need this. if its something embedded into your code they have this.

What does date picker do? any sample code?

 

[aviadht]

when the user open the form he can see a calender and then he can choose "The day of something that he did".

 

[bensonsearch]

when the user open the form he can see a calender and then he can choose "The day of something that he did".

did you use the calendar object in VBA on the form or some third party coding/control? if third party maybe try where you got it or see how the variable for collecting the date is handled/saved.

again code example would be awesome

 

[aviadht]

i cant add a code becouse it's a control box, after the user choose the date form the calender i'm doing that:

calday = DTPicker1.Value
If calday = "01/07/2011" Then
DTPicker1.CalendarBackColor = &H8080FF
check = "1"
End If