run time error 70 issue

[Shaun29]

any one know how to get past this? using vba for AutoCAD

 

[xlbo]

nnnnnnnnnnnnn - nope telepathy not turned on

run time error 70 is a generic error message - please post the relevant portions of your code and indicate the line it is failing on - it will also be worthwhile mentioning what the code is trying to achieve

Seriously - we have no idea what your code is tring to do or where the error is - we can't see inside your head - you have to give as much relevantinfo as possible to get the best possible answer

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Shaun29]

Sub BOM()
Open (" C:\Users\spritchard\Documents\Bill of Material text transfer\New Folder\0704-189-4B.dwg ") For append As #1
Write #1, ("txt.C:\spritchard\Documents\Bill Of Material text transfer\BOM MACRO\bomtest.txt"); EOF(1)
Close #1
End Sub

this is the code witch is not letting me access the file I have an Autocad block i am trying to extract info every time new info is put in the block so when i go to run my code it debugs on my open statement giving me an error 70 or error 52

 

[PHV]

Isn't your dwg file already open by another process ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Shaun29]

yes I have it open in cad and using vbarun were my code is and when i run it from the vb it gives me the error.?

 

[PHV]

I have it open in cad
So, the Permission denied error is normal behaviour ...

 

[xlbo]

If it is already open, how are you gonna open for append?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Shaun29]

what I am trying to do is use enable a code to the block of this dwg so when ever the block information is changed it updates it to a text file automatically.

 

[Shaun29]

the vba program is run from AutoCAD I need to run the code behind my block so when ever i use the block in other drawings all infomation from with in the block will uplaod to a text file?