Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA scripting in Excel
I rarely if ever use Excel. I need to change the format of a row of data
from a Date field (data is imported incorrectly from an Oracle Database) to a long integer. Can I use VBA in Excel like we do in Access or SQL? If I can a small example of how to go to the script when I open the spreadsheet would be helpful. Thanks in Advance! Len |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA scripting in Excel
How are you getting the data into Excel?
Data | Import External Data + Import Data normally understands the Date date type. If you are using the CopyFromRecordset function, that too understands the Date format. ELSE: 1. Change the SQL to CAST the date columns as string or, simply: select the columns in Excel, click Format | Cells | and then choose Date or Custom and specify/select the format you want. "Len" wrote: I rarely if ever use Excel. I need to change the format of a row of data from a Date field (data is imported incorrectly from an Oracle Database) to a long integer. Can I use VBA in Excel like we do in Access or SQL? If I can a small example of how to go to the script when I open the spreadsheet would be helpful. Thanks in Advance! Len |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA scripting in Excel
The data is coming in from the Teachers Association Credit Union. I have no
control on how the data is formatted. I am using the TransferText in an Access Macro. It will not let me save it in access with a CSV extension unless I use TransferText, but opens fine in Excel. The problem is that the column is not suppose to be a date formatted field, but for some reason it comes accross that way. Thanks Again Len "AA2e72E" wrote: How are you getting the data into Excel? Data | Import External Data + Import Data normally understands the Date date type. If you are using the CopyFromRecordset function, that too understands the Date format. ELSE: 1. Change the SQL to CAST the date columns as string or, simply: select the columns in Excel, click Format | Cells | and then choose Date or Custom and specify/select the format you want. "Len" wrote: I rarely if ever use Excel. I need to change the format of a row of data from a Date field (data is imported incorrectly from an Oracle Database) to a long integer. Can I use VBA in Excel like we do in Access or SQL? If I can a small example of how to go to the script when I open the spreadsheet would be helpful. Thanks in Advance! Len |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA scripting in Excel
Select the Row/Column, Click Format | Cells and select General
"Len" wrote: The data is coming in from the Teachers Association Credit Union. I have no control on how the data is formatted. I am using the TransferText in an Access Macro. It will not let me save it in access with a CSV extension unless I use TransferText, but opens fine in Excel. The problem is that the column is not suppose to be a date formatted field, but for some reason it comes accross that way. Thanks Again Len "AA2e72E" wrote: How are you getting the data into Excel? Data | Import External Data + Import Data normally understands the Date date type. If you are using the CopyFromRecordset function, that too understands the Date format. ELSE: 1. Change the SQL to CAST the date columns as string or, simply: select the columns in Excel, click Format | Cells | and then choose Date or Custom and specify/select the format you want. "Len" wrote: I rarely if ever use Excel. I need to change the format of a row of data from a Date field (data is imported incorrectly from an Oracle Database) to a long integer. Can I use VBA in Excel like we do in Access or SQL? If I can a small example of how to go to the script when I open the spreadsheet would be helpful. Thanks in Advance! Len |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA scripting in Excel
Can this be done using VB Script? I know I can do it manually, but they want
it done via VBA if possible? Thanks Again "AA2e72E" wrote: Select the Row/Column, Click Format | Cells and select General "Len" wrote: The data is coming in from the Teachers Association Credit Union. I have no control on how the data is formatted. I am using the TransferText in an Access Macro. It will not let me save it in access with a CSV extension unless I use TransferText, but opens fine in Excel. The problem is that the column is not suppose to be a date formatted field, but for some reason it comes accross that way. Thanks Again Len "AA2e72E" wrote: How are you getting the data into Excel? Data | Import External Data + Import Data normally understands the Date date type. If you are using the CopyFromRecordset function, that too understands the Date format. ELSE: 1. Change the SQL to CAST the date columns as string or, simply: select the columns in Excel, click Format | Cells | and then choose Date or Custom and specify/select the format you want. "Len" wrote: I rarely if ever use Excel. I need to change the format of a row of data from a Date field (data is imported incorrectly from an Oracle Database) to a long integer. Can I use VBA in Excel like we do in Access or SQL? If I can a small example of how to go to the script when I open the spreadsheet would be helpful. Thanks in Advance! Len |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA scripting in Excel
Len,
Record a macro whilst performing the manual steps. Clean up the results. NickHK "Len" wrote in message ... Can this be done using VB Script? I know I can do it manually, but they want it done via VBA if possible? Thanks Again "AA2e72E" wrote: Select the Row/Column, Click Format | Cells and select General "Len" wrote: The data is coming in from the Teachers Association Credit Union. I have no control on how the data is formatted. I am using the TransferText in an Access Macro. It will not let me save it in access with a CSV extension unless I use TransferText, but opens fine in Excel. The problem is that the column is not suppose to be a date formatted field, but for some reason it comes accross that way. Thanks Again Len "AA2e72E" wrote: How are you getting the data into Excel? Data | Import External Data + Import Data normally understands the Date date type. If you are using the CopyFromRecordset function, that too understands the Date format. ELSE: 1. Change the SQL to CAST the date columns as string or, simply: select the columns in Excel, click Format | Cells | and then choose Date or Custom and specify/select the format you want. "Len" wrote: I rarely if ever use Excel. I need to change the format of a row of data from a Date field (data is imported incorrectly from an Oracle Database) to a long integer. Can I use VBA in Excel like we do in Access or SQL? If I can a small example of how to go to the script when I open the spreadsheet would be helpful. Thanks in Advance! Len |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Dashboards Without VBA Scripting? | Charts and Charting in Excel | |||
Excel Dashboard without VBA Scripting? | Excel Discussion (Misc queries) | |||
Scripting in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel scripting,programming | New Users to Excel | |||
is excel by itself enough to do scripting? | Excel Programming |