Replies

It didn’t work.

thanks anyway

Thank you very much for your excellent and detailed explanation. Its just what I needed!

I have PPT v.97 at home. Do I need VBA code / macros to make this work?

Thank you very much for your excellent and detailed explanation. Its just what I needed!

I have PPT v.97 at home. Do I need VBA code / macros to make this work?

GREAT: hold down the right mouse button on the item and drag it to the folder. positions appoint in same place in the calendar.

, is not that good. Places appointment in your selected day in the calendar.

do you know why right click / copy and paste is not enabled in Outlook?

thank you!

Good workaround!!!

Checking Lock aspect ratio, and typing 100%, brings the size height and width data again.

I accept. However, when I bring the autoformat properties again, I get blank spaces …!!!

Anyhow, this last tip was excellent, and since this is happening only in only file, I’m happy right now.

Thank you

It has to do with a particular file. When I create a line, or arrow , or rectangle, and go to Format Autoshape, it doesnt display the height or width.

If I create the object in another window and another file, it works. If I copy that object to the “defective” file. Its odd. Seems like somehow I changed the default for new objects to another thing than the common line, rectangle polygon or whatever.

(I cant send you the file)

Thank you!

It was just what I needed!

Guillermo

Lounge is GREAT!!!

The Lounge beats any source of information about excel and other (several) products. I feel bad for posting questions that are very basic. I should study more!

Thanks!

Excellent!!

Know any www site that has related tips on similar subject (excel & dates)?

Thank you.

REALLY DUMB!!!!

the answer is

Set objWB = objXL.Workbooks(text16.value)
Set objWS = objWB.Worksheets(text19.value)

Your help has been excellent!

Your code works fine!!! (the one in your first answer too!!!

The problem was that I tried…:

Set objWB = objXL.Workbooks(text16)
Set objWS = objWB.Worksheets(text19)

where text16 and text19 contain the reference in text to the filename and sheet name , that is stored in the access table. what is wrong with that syntax?

(my questions must by very very dumb for access and excel experts like you… sorry!!!)

Thank you

Hans:

I inserted the code , and I get: Type mismatch (Error 13)

any idea of what could be happening?

thank you for the help

Great help!!

how would you check for blanks, and input a “0” if blank?

is there any control like TextBox, but for numbers (NumBox?) so I dont have to go through all the extra code?

THANK YOU!!

Should I be using another control for storing numbers?

Or format it the right way?

Application.EnableEvents=False gave me a clue about other problems I was having with my code

THANK YOU

Excellent help!!!

My question was more oriented towards the use of arrays.

Thank you

Guillermo