Run-time error 1004

  • VPillay
  • Topic Author
  • New Member
  • New Member
More
12 Jun 2012 11:42 #1 by VPillay
Run-time error 1004 was created by VPillay
Hi,

Firstly thanks for the great software! Many functions which can save a lot of time.

The problem that I am facing is that when trying to import a WinQS file, the following error pops up:

Microsoft Visual Basic

Run-time error 1004

Method 'OpenText' of object 'Workbooks'failed


Any ideas as to what may be wrong.

Please Log in or Create an account to join the conversation.

More
12 Jun 2012 16:53 - 12 Jun 2012 16:54 #2 by Ian
Replied by Ian on topic Re: Run-time error 1004
Hi there,

Thank you for the thank you. I'm really glad you're finding benefit from using the software. B)

In order to narrow down the possible causes, please answer the following questions:
  1. Does the same error occur with that specific file when opened on other workstations?
  2. If the ASCII file is copied to a different location, e.g. a different folder or drive, does the problem still occur?
Kind regards,
Ian
Last edit: 12 Jun 2012 16:54 by Ian. Reason: Better formatting

Please Log in or Create an account to join the conversation.

  • VPillay
  • Topic Author
  • New Member
  • New Member
More
18 Jun 2012 11:26 #3 by VPillay
Replied by VPillay on topic Run-time error 1004
Hi,

We managed to resolve the run-time error, after creating the file again and running the program everything ran smoothly!

Just a quick suggestion, would it be possible to retain the following columns when converting the file:

Section
Bill
Page No.

Thanks again.

Please Log in or Create an account to join the conversation.

More
18 Jun 2012 20:59 #4 by Ian
Replied by Ian on topic Re: Run-time error 1004
Glad to hear you got it sorted out. :)

I'll definitely keep your suggestion in mind for future releases.

Regards,
Ian

Please Log in or Create an account to join the conversation.

Powered by Kunena Forum
We use cookies

We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.