Replies

AMD, Intel, sure one is probably better at running business apps than the other, while the other is superior for gaming. Keep in mind, though, that with the budget you have you’ll be able to buy lots of power in either chip, and difference you might (might!) notice will be negligible, anyway. With a processor running around 2 GHz, you’ll be able to work (and play) hard.

Besides, once you have your computer built, you probably won’t look back and wonder, ‘what if I’d purchased an Intel…’.

Have your friend help you, and when all’s said and done, buy him a beer , and enjoy your new computer!

Good luck!

I’ve often wondered if this is possible as well. If it is possible for me to write code to disable the macro warning, why couldn’t someone else use similar code in a malicious document? I don’t think there is a way, programmatically, around this.

I haven’t done any reading about digital signatures.
Good luck!

Excel 97 limit: 65,536 rows.

Do you know the history of the 2 Meg floppy drive? This is the first time I’ve every heard of or seen one. How long were they popular, or weren’t they EVER popular?

Thanks.

This is a delimiter issue. Apparently, when the information is being imported into excel, the fields are delimited with specific characters – numbers are preceeded with a ‘. I recommend selecting the problem area(s), and clicking Data > Text to Columns… Click Delimited, click Next, and change the Text Qualifier to {none}. Then Finish up. I think it’ll solve your problems.

I don’t know of a way to get around this at the initial import, but I’ll take a look into it.

–What a frustrating situation. I was lucky to stumble on your solution (http://support.microsoft.com/default.aspx?scid=kb;en-us;Q127132). It, however, is one of those ‘How can I fix it if I don’t know what’s wrong?’ scenarios.

Good luck!

Try doing a Find for the file, and temporarily move it to a different folder – say – on your desktop. Then start Outlook to see if you get the same issues.

If you DON’T encounter the problem, then keep working for a week or two. If you still don’t encounter any problems, I’d say you’re safe to delete the file.

If you have access to Access (sorry), a standard table will do what you want. If you’re unfamiliar with Access, and your project is time-critical, though, just live with creating a header row in Excel.

Best of luck!

Try this:

Sub Button1_Click()
‘Copies the workbook to a separate file
Dim FileName As String
Dim thePath

thePath = “C:YourDirectoryHere” ‘ That last ” is important
FileName = “New File ” & Format(Date, “mm-dd-yyyy”) ‘Suggested Filename

Application.Dialogs(xlDialogSaveAs).Show thePath & FileName ‘ Save As box
Application.DisplayAlerts = False ‘—–=====—–
ActiveWorkbook.Close ‘ Comment these out to leave the new file open
Application.DisplayAlerts = True ‘—–=====—–
End Sub

Thanks; I’ll pass this information on.

Click the chart to select the plot area, then click Tools > Options. Click on the Chart tab, and make sure you ‘Plot empty cells as:’ Interpolated. This ignores zero values.

My first thought is to check for the presence of an AUTORUN file on drive C. If there is one there, temporarily rename or move it, and see if that helps.

What an excellent idea for documents/presentations/text-type documents! I’ll pass that on to my user.

Now… any ideas what to do if it’s not a document like that? Well, if your suggestion DOESN’T solve my problem, I’ll post back and inform you.

Thanks.

I understand how you’d like to implement a date/time nomenclature for the files, but apparently my user doesn’t want his customers to archive the files he gives them. If, for instance, the files are PowerPoint presentations (I’m not sure that they ARE..), he doesn’t want the customers to claim – once they have a final product, “but in your presentation 2 years ago, you said, ‘blah, blah'”.

I recommended to him just to post the files to a secure web page; he could at least control the availability of the files. The customer, however, could still archive a copy of the file, either by right-clicking and ‘Saving Target As’ or by opening the file in the current location, and Saving As from the parent program, right?

Thanks for your prompt reply.

I’d prefer to have something that takes care of itself. I’d rather ask the users to delete the file in question before I ask them to install/run some other program that will do the same thing.

If there was, however, a program that I could attach an ‘expiration date’ to, I would recommend it. Whatever it is, it would have to realize that the file is more than x days old, so it should not be opened.

Yes, Dave, I believe I would want a time bomb of some sort.

I’ve had similar problems with my network and ICS at home, too. I believe that when the client computer does its startup routine, it checks for network drives, and also for a connection to the Internet (you do have it set to connect using a LAN, right?).

Well, when the server receives this, it says, ‘hmmm…you want an Internet connection? I’ll create one for ya!”

In response to the random dial-outs – its probably some TSR that is trying to update itself. Of course, I can’t talk about the Internet without mentioning today’s Scary Internet Buzzwords. It might be some spyware trying to send an update to the mothership.

If you’re tired of all of this extraneous dialing, and if it isn’t too difficult for the ICS client’s user, just set the ICS client’s connection (Tools > Internet Options… Connections Tab) to ‘Never dial a connection’, and just change it back when you’re ready to surf.