Search results for query: *

Many thanks xlhelp but not the answer I need. In VB/VBA I have to use the scaling you provide to draw shapes to scale. My problem is that I can create shapes (either manually or programmed) in cm, but when user clicks on the shape and uses 'Format/Autoshape' the size is given in inches. Excel is...

When I add shapes to Excel the size units displayed by 'Format/Autoshape' are inches. In Word they are cm. I want Excel to measure shape size in cm. How do I do this? [Microsoft Excel 2000]

Thanks MJPPaba I agree. I think thats what I said in para 3 of my reply 3 Mar 05 6:45 [ponder]My question is not about what do I do with linked cells but can anyone repeat or explain how the links fail/fix by simply changing one of the directory names in the full path? To avoid any further...

[blush] Thanks Ken I've had a senior moment (again). Yes, I once knew that the full path was replaced by the workbook name when the links were re-made. This was one of the observations I made when I had first encountered link problems (many projects ago). Since I mainly use automation for...

Thanks for quick reply. The path is quite short C:\Program Files\Directory1\Directory2 The workbooks are in directory2 when they fail. Another factor: I always use VB6 to open Excel and load the workbooks. Several different VB6 programs can open the workbooks, but they all have the same...

[ponder] I have six Excel workbooks which are linked. All six workbooks are in the same directory. When Excel is opened and all six workbooks are loaded the links are OK. Except when I place them in a particular directory. When the full path is a certain path then SOME links are broken. It...

[ponder] I want to drag the ShapeSheet window out of the Visio window and onto the desktop. Thus make more room. (I use two VDU's so have a large desktop.) Does anyone know how to do this? Have I simply missed a checkbox somewhere? Visio Pro 2002 + WinXP Regards Stumped.

This method stops users from loading their workbooks into your Excel by forcing them to use a new instance of Excel. Dim oExcel as object ...... Set oExcel = CreateObject("Excel.Application") oExcel.IgnoreRemoteRequests = True .... The above is my method of opening Excel Regards Mike