[VBA] vba σε ppc!

[ytsiak]

καλησπερα σας
εχω δημιουργησει μια εφαρμογη απογραφης στο excel..
αυτο που θελω να κανω ειναι να την περασω μεσα στο ppc που διαθετω και τρεχει wm5!
αλλα η macros απο το pocket excel δεν υποστηριζονται !γινεται να μετατρεψω καπως την εφαρμογη και να τρεχει κανονικα στο ppc?η υπαρχει κανενα προγραματακι για ppc το οποιο να αναγνωριζει κανονικα τις macros ?
δοκιμασα το ptab και το planmaker ..αλλα εχουν πολυ περιπλοκο προγραμματισμο για τις macro..

ευχαριστω πολυ!

[Tasos]

Καλησπέρα Γιάννη!

Δες τι δεν υποστηρίζεται στο Excel Mobile:

Unsupported features in Excel Mobile

Excel workbooks created on your PC can be opened and edited on your device. However, Excel Mobile does not fully support some features such as formulas and cell comments. Some data and formatting may be lost when you save the workbook on your device. Note the following regarding these Excel Mobile formatting considerations:

• Protection settings. Most worksheet and workbook protection features are disabled but not removed. However, support for password protection has been removed. Workbooks that are password-protected or workbooks in which one or more worksheets are password-protected cannot be opened. You must remove the password protection in Excel on the PC and then synchronize to open the file on the device.
• Zoom settings. Are not retained. Excel supports a per worksheet zoom setting, while the Excel Mobile zoom setting is applied to the entire workbook.
• Worksheet names. Names that reference worksheets within the same workbook are displayed accurately, but names that refer to other workbooks, arrays, for example, ={1;2;3;4}, array formulas, or intersection ranges are removed from the name list. If a name is removed from the list, it is left in formulas and functions, causing those formulas to be resolved as "#NAME?" All hidden names are not hidden.
• AutoFilter settings. Are removed. However, you can use the AutoFilter command in Excel Mobile to perform similar functions. If you have an AutoFilter applied to a worksheet that causes rows to be hidden, the rows remain hidden when the file is opened in Excel Mobile. Use the Unhide command to display the hidden rows.
• Chart formatting. All charts will be saved the way they are shown in Excel Mobile. Unsupported chart types are changed to one of these supported types: Column, Bar, Line, Pie, Scatter, and Area. Background colors, gridlines, data labels, trend lines, shadows, 3D effects, secondary axes, and logarithmic scales are turned off.

Worksheet features . The following features are not supported in Excel Mobile and are removed or modified when a workbook is opened on the device:

• Hidden sheets are not hidden
• VBA modules, macro sheets, and dialog sheets are removed and replaced with a place holder sheet
• Text boxes, drawing objects, pictures, lists, conditional formats, and controls are removed
• Pivot table data is converted to values.

πηγή:Windows Mobile powered Pocket PC Help & How Tos (Microsoft Windows Mobile, Windows CE, Mobile Computing, Mobile device

Διαβάζοντας τα παραπάνω, δε νομίζω ότι θα σ εξυπηρετήσει το PPC σε συνδυασμό με το αρκετά "φτωχό" Excel Mobile για να κάνεις απογραφή.

Θα πρέπει να χρησιμοποιήσεις κανονική έκδοση Excel και φυσικά ΗΥ (Notebook ή PC) με λειτουργικό Windows προκειμένου να μπορέσεις να εκμεταλευτείς πλήρως το πρόγραμμα σου.

Φιλικά

Τάσος