newholyman
asked on
From MS Access 2007 use VBA to change column A to general formating in Excel worksheet
From MS Access 2007 open a Excel workbook. Then change column A formating to general.
Column A currently has [=1]"ONE";[=0]"////";Gener al
I'm going to do a filecopy of the Excel workbook, then change the copied workbook column A formating to general
The reason for changing the formating , when importing only th "ONE" is imported even if there is another value entered.
Column A currently has [=1]"ONE";[=0]"////";Gener
I'm going to do a filecopy of the Excel workbook, then change the copied workbook column A formating to general
The reason for changing the formating , when importing only th "ONE" is imported even if there is another value entered.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I've requested that this question be closed as follows:
Accepted answer: 0 points for newholyman's comment #a40346795
for the following reason:
This resolved my question. Thank you1
Accepted answer: 0 points for newholyman's comment #a40346795
for the following reason:
This resolved my question. Thank you1
ASKER
Will need to save work book for the change to be effective?
Again, Thank you.