Replies

Why not make column B contain zeros, and simply make F = D*E+B as suggested before?

Whenever you want to make a change you alter the value in B for the relevant rows.

Why not make column B contain zeros, and simply make F = D*E+B as suggested before?

Whenever you want to make a change you alter the value in B for the relevant rows.

I’ve amended the code after finding that opening any other spreadsheet on top of the open “*.txt” file asked me if
I wanted to use the Wizard again.

Edited to include error handler when opening Excel without an active workbook.

Option Explicit

Public oWkbk As Workbook
Public clsApp As New clsEvent

Function IsThereATextFile() As Boolean
  Dim bTxtfile As Boolean
 On Error GoTo ExitFunction
 
 Set oWkbk = ThisWorkbook.Application.ActiveWorkbook
    Select Case Right(oWkbk.Name, 4)
    Case ".prn"
      bTxtfile = True
    Case ".txt"
      bTxtfile = True
    Case ".csv"
      bTxtfile = True
    Case Else
      bTxtfile = False
    End Select
 ExitFunction:
 IsThereATextFile = bTxtfile
End Function

This now only asks for the file being opened.

PS change the file attributes of the OpenText.xls to ReadOnly and you’ll avoid the ‘already in use’
popup when opening another spreadsheet.

Once again, many thanks for giving me 95% of a solution and inspiring me to play about with the code.

I’ve amended the code after finding that opening any other spreadsheet on top of the open “*.txt” file asked me if
I wanted to use the Wizard again.

Edited to include error handler when opening Excel without an active workbook.

Option Explicit

Public oWkbk As Workbook
Public clsApp As New clsEvent

Function IsThereATextFile() As Boolean
  Dim bTxtfile As Boolean
 On Error GoTo ExitFunction
 
 Set oWkbk = ThisWorkbook.Application.ActiveWorkbook
    Select Case Right(oWkbk.Name, 4)
    Case ".prn"
      bTxtfile = True
    Case ".txt"
      bTxtfile = True
    Case ".csv"
      bTxtfile = True
    Case Else
      bTxtfile = False
    End Select
 ExitFunction:
 IsThereATextFile = bTxtfile
End Function

This now only asks for the file being opened.

PS change the file attributes of the OpenText.xls to ReadOnly and you’ll avoid the ‘already in use’
popup when opening another spreadsheet.

Once again, many thanks for giving me 95% of a solution and inspiring me to play about with the code.

You can also try Irfan View. Free (for non commercial use; $10 for single user commercial license) and can be run from the command line – in VBA create a text batchfile specifying the control commands and use the shell() command to run it.

You can also try Irfan View. Free (for non commercial use; $10 for single user commercial license) and can be run from the command line – in VBA create a text batchfile specifying the control commands and use the shell() command to run it.

Thanks guys, That looks like a good approach

However my version of Excel ( 97 SR2) didn’t seem to recognise the “xlDialogImportTextFile” Dialog name, so I got a “Variable not Defined” error whenever I opened Excel.

After a quick search through the Microsoft knowledge base, I’ve found that using “xlDialogOpen” gives the desired result

Many Thanks

Thanks guys, That looks like a good approach

However my version of Excel ( 97 SR2) didn’t seem to recognise the “xlDialogImportTextFile” Dialog name, so I got a “Variable not Defined” error whenever I opened Excel.

After a quick search through the Microsoft knowledge base, I’ve found that using “xlDialogOpen” gives the desired result

Many Thanks

Would it make more sense to think of the copy as the backup and keep the production file in the same folder? No need to update the shortcuts and the folder/files can be made read-only as soon as they are copied.

Would it make more sense to think of the copy as the backup and keep the production file in the same folder? No need to update the shortcuts and the folder/files can be made read-only as soon as they are copied.

I’ve quickly dropped the image into an OCR reader and produced the attached.

It needs some correcting as the OCR wasn’t perfect, but hopefully this’ll do for you.

I’ve quickly dropped the image into an OCR reader and produced the attached.

It needs some correcting as the OCR wasn’t perfect, but hopefully this’ll do for you.

in theory, if you press the Alt key when moving objects you can move things exactly where you want.

It looks as though the elbow connectors can’t be aligned in the way that other graphical objects can be.

in theory, if you press the Alt key when moving objects you can move things exactly where you want.

It looks as though the elbow connectors can’t be aligned in the way that other graphical objects can be.

From re-reading your post it looks like you want to have a number of email accounts available for use, so that your wife can use one from another machine, and you can use one for most of your mail and another to use when registering at internet shopping sites.

Although you’ll need to set up different accounts on OE to read these accounts, the main part of this question is concerned with setting up more than one account with your ISP.

My first ISP claimed to offer multiple email addresses, such that I could have owen@myname.myISP.com , nemo@myname.myisp.com etc, but downloading them from the mail server brought ALL the messages. If I only used the one machine I could have used rules to sort owen@ . . . into one folder and nemo@ . . . into another, but you want your wife to be able to receive hers on one machine and yours on another.

I have moved to another free ISP that does give proper separation of accounts.

My advice would be to check on the support / advice pages at your ISPs homepage and see whether they offer what you need. Probably you’ll have to use their homepages to manage the setting up of the new accounts, so make a note of the details of the username and passwords you are given. Often you end up with a page showing the settings that you can use to print off as a permanent record.

Then it’s straightforward to open OE, go to Tools / Accounts . . . and key the details of the account and server to be able to download your mail on your machine. Fill in the details of your wife’s account on her machine and you can each receive your own mail.

Hope this helps.

PS I would also thoroughly recommend Mailwasher it allows you to identify and delete spam and look out for virus infected mail BEFORE downloading anything nasty onto your machine.