J
Joyce von Hammerstein
System Information:
Excel 2002 (10.2614.2625)
Microsoft Windows 98 4.10.2222 A
Background:
I can sync the Expenses in my Kyocera 6135 with my Kyocera
smartphone Desktop on my PC. Initially when I tried (in
the Desktop) to open the Expense report it wouldn't work
because the macros were not trusted. So I set the Macro
Security level to Low & set the Trusted Sources to Trust
access to Visual Basic Project.
Problem:
Now, when I open the Expense report (in the Desktop) the
macros are allowed to run and it creates an Excel
worksheet but it does not print all the fields from the
source file (expenses.txt or expenses.db). According to
the Help menu in the Desktop to see the fields I want I
need to click on the "Expense Report"'s Options button.
When I do this the following is reported and the worksheet
is not opened:
Run-time error '1004':
Unable to set the List property of the DropDown class
I've searched the Excel knowledge base but don't see
anything similar. Anybody know how to fix this or what my
problem is?
Excel 2002 (10.2614.2625)
Microsoft Windows 98 4.10.2222 A
Background:
I can sync the Expenses in my Kyocera 6135 with my Kyocera
smartphone Desktop on my PC. Initially when I tried (in
the Desktop) to open the Expense report it wouldn't work
because the macros were not trusted. So I set the Macro
Security level to Low & set the Trusted Sources to Trust
access to Visual Basic Project.
Problem:
Now, when I open the Expense report (in the Desktop) the
macros are allowed to run and it creates an Excel
worksheet but it does not print all the fields from the
source file (expenses.txt or expenses.db). According to
the Help menu in the Desktop to see the fields I want I
need to click on the "Expense Report"'s Options button.
When I do this the following is reported and the worksheet
is not opened:
Run-time error '1004':
Unable to set the List property of the DropDown class
I've searched the Excel knowledge base but don't see
anything similar. Anybody know how to fix this or what my
problem is?