Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Fortisdragon
- Order by date
-
VBA Excel - Paste Special (Transpose)
Well... I feel myself like Dobby (Harry Potter)... Stupid! My goal is not to denigrate the HelpFile but sometimes it takes me hours to correct myself the synthax inside the "Help File Examples". So Thanks a lot to avoid me loosing too much time! FD- Fortisdragon
- Post #3
- Forum: Microsoft: Office
-
VBA Excel - Paste Special (Transpose)
Hi everyone! I've got another problem in excel vba (Excel 97)... I want to (simply!) paste data from one sheet to another one in the same workbook. The famous so-called "HelpFile" show me this code for the "paste special format" function: <expression.PasteSpecial(Paste...- Fortisdragon
- Thread
- Replies: 3
- Forum: Microsoft: Office
-
How to open an excel file (7.0) from access 97
Thanks a lot Baggie! In fact the answer was between both solutions... because Access 97 doesn't recognize "New" in your first Line But... I've wrote the following and it works pretty well! Dim MyXls As Object Set MyXls = CreateObject("excel.application") MyXls.Visible =...- Fortisdragon
- Post #3
- Forum: Microsoft: Office
-
How to open an excel file (7.0) from access 97
Hello, I'm new here and I'm starting to "play" with VBA Access. Despite the Microsoft Tips, I'm able to open a new instance of excel (like an activeX object) but obviously the same command cannot open an xlfiles on a server. Is someone can help me? Thanks a lot, Emmanuël- Fortisdragon
- Thread
- Replies: 2
- Forum: Microsoft: Office
