Hi PH, I've used
Set MyXL = GetObject(, "Excel.Application")
Set MyXL = GetObject("c:\myFile")
to get the xls file. Now I have to select some cells in excel and to put them in a table in word.
Elena
Hi, I'm doing a macro starting form MS Word that open a given file xls and copy the content of some cells into a table in the Word document.
After I've opened the file Excel from the Word ile, how can I import the data?
Thanks in advance
Elena
Hi Ken, thanks for your advice.
I had never used before the Dir() method, it seems to be useful.
How can I do to use the standard file open dialog box? (I found the OpenTextFile method, but I think it doesn't work for non textual files).
This time I solved my problem using FileSystemObject...
Hi, I should open a folder from a mask. In the folder there will be one or more pdf files, so I should display the file selected calling it by my access mask.
How to do?
Thanks in advance,
Elena
Hi,
I'm trying to convert a mdb file in a mde. I've always done it before, but now there is an error message saying only that the mde file cannot be created.
I wonder why. Any help is welcome, thanks,
Elena
I'm quite new in Corel, forgive the question, is it possible to export a file created in Bryce (3ds) in another application like Dream 3D?
Thanks in advance,
Elena
I have a problem. When I try to open a form from my application it happens that an error "OpenForm Action Deleted" (or something like that) occurs. The strange thing is that this error occurs only when you use a particolar computer and not the others. I can't understand why and...
Hi,
is it possible to change dinamically the dimension of a textbox in a report depending on the size of the text each time my application inserts into it?
How to do it?
Thanks in advance,
Elena
I have an excel sheet. I don't know what has happened but the columns are put in reverse order (from Z to A) and everithing is ordered from right to left.
Does anyone know hot to put it in the correct order?
Thanks in advance,
Elena
Hi Jedi, mine is the same, but unfortunately the menus are greyed out only if I open a mask that is not associated to a table.
When I open a form that loads data from one of the tables in my db, there are some items that become clickable, like 'Delete record', 'New record', etc...
I fear I...
Hi, you can store the e-mail in your table and then, when you want to send the e-mail, you can select the address and send the e-mail through DoCmd.SendObject. Be careful with this method it's buggy.
Elena
Hi Jedi, I unchecked all the checkboxes in the startup mask but some menues still remain: 'File', 'Modify', 'Insert', 'Record', 'Window', '?'.
I begin to think there is no chance to eliminate them or at least some of them...
Elena
You could try creating a new empty database and importing all the contents (tables, queries, relationships, etc...) of your old db in it (file ->load external data ->import). So you should have a new db exactly like the old but now you should have all the permissions. Then cancel the old one and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.