Hi
I have a spreadsheet that I developed on a Windows 7 (64-bit) PC in Excel 2007 (32-bit) with the DTPicker control in a userform. This worked fine but I then shared the spreadsheet with a friend who has a Windows 8 PC (32-bit) and Excel 2010.
I am getting a "Compile error: unable to find project or library" error on my friend's PC linked to when running VBA code related to the DTPicker. I found that the control was missing when going into the spreadsheet > VBA > Tools > References. I later upgraded to Office 2010 (32-bit) myself and the spreadsheet still works. Looks like the control is stored in a different place on my Win7 64-bit PC.
I'd like to change the way I select dates moving away from the DTPicker. I need to use a control on a userform where I can select a dates within a 1 year range (e.g. a start date defined in a cell within the spreadsheet and then choose a date to any day from the start date to 1 year in the future) that can be used on Office 2010 and either 32-bit or 64-bit Windows PCs.
Can anyone suggest a few options that I they would recommend or that I can look into that will allow this flexibility and not be 32-bit or 64-bit Windows specific in terms of where the control is stored.
Thanks
Steve
I have a spreadsheet that I developed on a Windows 7 (64-bit) PC in Excel 2007 (32-bit) with the DTPicker control in a userform. This worked fine but I then shared the spreadsheet with a friend who has a Windows 8 PC (32-bit) and Excel 2010.
I am getting a "Compile error: unable to find project or library" error on my friend's PC linked to when running VBA code related to the DTPicker. I found that the control was missing when going into the spreadsheet > VBA > Tools > References. I later upgraded to Office 2010 (32-bit) myself and the spreadsheet still works. Looks like the control is stored in a different place on my Win7 64-bit PC.
I'd like to change the way I select dates moving away from the DTPicker. I need to use a control on a userform where I can select a dates within a 1 year range (e.g. a start date defined in a cell within the spreadsheet and then choose a date to any day from the start date to 1 year in the future) that can be used on Office 2010 and either 32-bit or 64-bit Windows PCs.
Can anyone suggest a few options that I they would recommend or that I can look into that will allow this flexibility and not be 32-bit or 64-bit Windows specific in terms of where the control is stored.
Thanks
Steve
