Summary: Hello, I have 'written' the following Excel macro. I have a .csv file that I want to import data from. The data within the .csv will change from time-...
Summary: Instead of just opening the csv file in Excel, create a new Worksheet. Then: Data Get External Data Import Text File Show All Files Browse to the csv...
Summary: Could you kick the file out to a .csv instead? When you import a csv file in Excel, it will give you an option to format that row as text, and as a re...
Summary: Can software automatically import and export VB modules in Excel? I want to circulate some spreadsheets which, upon opening, would automatically impor...
Summary: I want to play a .avi file in excel. Using Insert/Object/Create from File and then selecting the video file I want to play, I have an icon on the spre...
Summary: You use linking for the Word piece (look it up in the help files, theres oodles of useful stuff there. Essentially, the easiest way is to copy your so...
Summary: I don't use Access any more and never used it much to begin with but, try opening and saving the .csv in Excel as a .xls file. Then you can import it ...
Summary: Hi, 4 wot i can understand : u want some part of ur dbf file (a sum of articles i mean)to go to ur excel sheet. Import ur dbf in excel. Next have a p...
Summary: Also, if these are your own workbooks and your own macros, did you install the Digital Signing component of Office? Run Add/Remove Office again and ch...
Summary: Webpage content saved as .xls file has no problem while opening in excel 2003, excel 2000. but while opening in excel 2007 its giving the below warnin...
Summary: I dont understand your formula. It appaear to be adding two values and subtracting a third. To find the difference between two dates it is just date1...
Summary: Copy all to a text file and next import it in excel, usin conversion tool.If u open a .txt file with xl, conversion tool is auto launched, and u can d...
Summary: User has an excel spreadsheet created in Excel 2000. The spreadsheet is fairly simple, a listing of meetings with several filters inserted. The user t...
Summary: I'm trying to import a large text file into Access. The data is separated with commas, but there are no line breaks. Each line just runs together. ...
Summary: In Excel, each sheet has the 65536 lines limitation. Is there any simple way to remove or expand this limitation, or I have to split one file with ove...
Summary: Hello, I am experiencing the following scenario: I have a laptop with Win98 (American language version) and Outlook 2000 (American version) installe...
Summary: Hello people, When I try to open a file in Excel 97, I get a message that says, "Permission to use object denied." (Error 419). The folder where the...
Summary: How do I change short cut keys in excel? Will it create any configuratioin file? If for example Ctrl+A will select the entire work sheet. If I want to...
Summary: is it possible to open .xls files created in "Excel 2000", in a machine running "Excel 95" does it need any add-ons my signature does not look like th...
Summary: Hello, I have set up a simple timecard in Excel. There is a time field for clocking in, and another for clocking out. I want Excel to then calcul...
Summary: After saving a new file in Excell XP I can open it and find it in the explore. But when I try to use "search" function in excell it does not find it !...
Summary: When I open a monthly report in excel 2000, make changes to various cells in various worksheets, then save the file to the same name.....then open the...