Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting non numeric characters.
Is there away while using a template that I could override the update prompt
and replace it with code that would allow me to check the incoming data for nonumeric characters before an update is attempted. I tried getting an answer 4/27 Check File Before Updating Template. Soiuld I be getiing advice from Mainframe users and not this site? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting non numeric characters.
Hi Cyndy,
<<Is there away while using a template that I could override the update prompt... I assume that this means that you have "Ask to update automatic links" checked on the Edit tab of the Tools|Options dialog box and that you are using links from the template to the PickList.XLS file. I have couple of questions about your application: 1. Are you saving the template as an Excel workbook (*.XLS) after each update? Is each update supposed to be a static copy (snapshot) of the data at that point in time? 2. If you are saving the template as a template file (Compare.XLT) each time, then why not just use a regular workbook file (*.XLS)? It sounds to me like the number of serial numbers in the PickList file does not always match the number of lines of data in your template. You might need to develop an add-in that has a macro(s) to check the contents in the PickList.XLS file first, then copy the data into the Compare workbook, then prompt the user for a filename to save the resulting workbook to (like "Compare mm-dd-yy.XLS"). This is definitely the newsgroup to answer Excel programming questions. (Although it is generally assumed that you already have some code that you need help with.) -- Regards, Bill "CyndyG" wrote in message ... Is there away while using a template that I could override the update prompt and replace it with code that would allow me to check the incoming data for nonumeric characters before an update is attempted. I tried getting an answer 4/27 Check File Before Updating Template. Soiuld I be getiing advice from Mainframe users and not this site? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting non numeric characters.
My data ius coming from a mainframe file. I need to remove the end of file
character in the picklist.xls file before I open my template file which has other specific code it in for a scanning process. The template file is then saved as an .xls for for the date scanning was done. The .xlt file is updated with the information that was downloaded to the picklist file. Yes, they are linked. The end of file character will always be at the end of the data. I have code to open and update the .xlt file. just can't get rid of character 127 which is the end of file character. "Bill Renaud" wrote: Hi Cyndy, <<Is there away while using a template that I could override the update prompt... I assume that this means that you have "Ask to update automatic links" checked on the Edit tab of the Tools|Options dialog box and that you are using links from the template to the PickList.XLS file. I have couple of questions about your application: 1. Are you saving the template as an Excel workbook (*.XLS) after each update? Is each update supposed to be a static copy (snapshot) of the data at that point in time? 2. If you are saving the template as a template file (Compare.XLT) each time, then why not just use a regular workbook file (*.XLS)? It sounds to me like the number of serial numbers in the PickList file does not always match the number of lines of data in your template. You might need to develop an add-in that has a macro(s) to check the contents in the PickList.XLS file first, then copy the data into the Compare workbook, then prompt the user for a filename to save the resulting workbook to (like "Compare mm-dd-yy.XLS"). This is definitely the newsgroup to answer Excel programming questions. (Although it is generally assumed that you already have some code that you need help with.) -- Regards, Bill "CyndyG" wrote in message ... Is there away while using a template that I could override the update prompt and replace it with code that would allow me to check the incoming data for nonumeric characters before an update is attempted. I tried getting an answer 4/27 Check File Before Updating Template. Soiuld I be getiing advice from Mainframe users and not this site? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract first numeric characters only??... | Excel Discussion (Misc queries) | |||
determinant with non-numeric characters | Excel Discussion (Misc queries) | |||
Removing Non-Numeric Characters | Excel Discussion (Misc queries) | |||
Converting numeric characters | Excel Discussion (Misc queries) | |||
"combo box- numeric characters" | Excel Discussion (Misc queries) |