Shirly
04-16-2007, 02:17 AM
problem:
a .HTML file is writen in 'Arial' during the DoCmd.TransferText some chars are changed à becomes Ö ect. ect.
when i open the file in excel and change the font to 'Times New Roman' this doesnt happen !
Is it posible to change the font in the DoCmd.TransferText command ?
so the text isn't corupted !
code:
DoCmd.TransferText acImportHTML, "ListOfData", _
"Tbl_List", "C:\TEMP\List.thm", False
a .HTML file is writen in 'Arial' during the DoCmd.TransferText some chars are changed à becomes Ö ect. ect.
when i open the file in excel and change the font to 'Times New Roman' this doesnt happen !
Is it posible to change the font in the DoCmd.TransferText command ?
so the text isn't corupted !
code:
DoCmd.TransferText acImportHTML, "ListOfData", _
"Tbl_List", "C:\TEMP\List.thm", False