Replies

Never mind.
Path appearently is read/write.
Regaurdless that the docs say Read-only
piffle

Thanks Hans, that is a great idea.
However, it did not solve the problem. It did produce some interesting results thought.
A list of of the available procedure/function/object in vbaCBBT (created by vbaCBBT. ) shows some of what should be available and none from the mGlobals module. Interestingly, while the functions in mGlobals do not appear in the lists, they can be called from the other project.

Confusing. I will probably export and rebuild. It seems to help sometimes. But I would welcome any other imparted wisdom.

Thanks.
Still no luck on the public constants.
xla project is named (vbaCBBT)
The spreadsheet references the xla (Shows up in reference dialog and in the project folder references.
I can call the various public functions and subs included in the xla. However the project will not compile; stopping on the first constant with a ‘variable undefined’ error.

Could this be caused by the fact that there used to be a variable of the same name in the spreadsheet but it is now in the XLA?

that makes sense actually
thanks

or I could cut/paste the structure then add the FormFields…
just a bit slow sometimes
shesh

piffle.
I was hoping to use cut/paste to create my expanded data section. Creating the rather complex structure with code will be tedious.
Either that or figure out how to do the whole thing without rely on names
oh well. I guess that’s why I get the big bucks…

Thanks for the prompt response

I have just come across this problem. Specifically

So
Once you have formfields in a document with non-unique names, can you ever use .name to assign a name of a formfield?
If no this pretty much kills copy/paste of any range with fields in it.

Also, does this problem exist for code created fields

I am trying to make an form with section that can expand based on data entry. Working with out field names will require some serious rethinking

thanks

“Are you sure this is not a macro of the same name in another workbook ”
Very close to the actual problem.

Although the macros did not exist in other open workbooks, they did at one time. And that seems to be the problem.
I copied the worksheets to a new book, copied the one module (has _Open code) into the same new book. Closed the original file and everything now works.

Thanks for the ideas. They gave me some ideas on what was really going on.

The OnAction string contains the complete filepath/filename/macro. Similar to the following (The only difference being the text after the _)
‘C:Documents and SettingsAll UsersDocumentsCBBTAnnualInspection.xla’!Inspect_Bent

There are no arguments to the subs. The subs are explicitly listed as public.

Interrestingly, the macros that do not work, also do not run from the Tools-> macro. While the one that does work can be accessed in that manor.

Hey, I use onenote. Any one else?…?…? Class?
Onenote is one of those products if you have a use for you wonder how you ever got along without it. However, if you not need what is does, you just sit there and scratch your head.
If you have various stacks of paper in piles over your desk then onenote may be of use.

Onenote stores text, pictures, and ink (that tablet stuff) in a searchable, reorganizable notebook concept. It is tablet aware but you do not need a tablet PC to use it. However, if you have a tablet, it makes your notebook electronic (complete with the ink to text features). Also, it is very useful for dealing with research on the web.

I use to store information from the web, instead of piles of paper. I use it to store documents from many sources (project pictures with annotations, schedules, contracts, proposals, etc..) for projects for reference (instead of the paper). I also use it on a tablet PC to take note/minutes during meetings.

Another real world use was my son’s I-Search project he did at school. He was suppose to research the 1930’s at look at various political, social, economic, entertainment issues. Using onenote and the web, it was easy to search collect organized and properly referenced notes that could be searched at the end. Beat the heck out of the spiral notebook the teacher wanted him to use.

You do not need Office 03 to make use of it. Onenote does link with Outlook 2003 but I have not found much use for that. Other than that, the version of office doesn’t really matter.

Hope this helps a bit.

thanks. That worked.
Combined with ScreenToClient and PixelToInkSpace everything lined up. No more work around

Always amazed how I can never find things that should be rather obvious….

thanks. That worked.
Combined with ScreenToClient and PixelToInkSpace everything lined up. No more work around

Always amazed how I can never find things that should be rather obvious….

An alternate idea
You can set the combo box row source to be a named range.
The named range can grow/shrink and whatever on you and the control doesn’t care

An alternate idea
You can set the combo box row source to be a named range.
The named range can grow/shrink and whatever on you and the control doesn’t care

And now a completely different solution.
If I understand your problem, what about using the built in TextToColumns command? Select column of data, define how you want to parse it and away you go. You can record the options in a macro for later use. I use this all the time for parsing text files.
Sorry, if this isn’t what you are trying to do.