| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell format change mess
I thought I had this worked out, but it still craps out. I have to cut and
paste selected data from a web table into excel and ultimately into MS Access. The problem is that Access insists on treating numeric looking data as numbers when it is not. Leading zeros are dropped and if alphabetic symbols occur I get data type conversion errors. So, I thought I figured out a macro to drop the web data into my clipboard then send it to Excel before transferring it to Access. I set the cell formatting in Excel to text, but when the clipboard data is pasted into Excel, again the formatting drops the leading zeros. Essentially I was doing this: Range("A1").Select ActiveSheet.Paste ActiveSheet.SaveAs ("...path\imported.xls") ClearClipboard How can I avoid this problem? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| Changing the cell format doesn't change existing cell content | Excel Discussion (Misc queries) | |||
| Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
| find word in a cell then change cell format | Excel Programming | |||
| How do i change the format of a cell based on the condition of another cell in same row? | Excel Programming | |||
Threaded Mode
