![]() ![]() I have a word-template which is used to write invoices. The thing is that I need to run a Macro which is located in the Workbook as soon as a commandbutton from a Userform in Word is pressed. In the VBA-menu I have already activated the Object-Library for Excel but the problem is that even though it seems to know the functions (it shows all the options that I would need), it can't run them. Now I need to get some data from that Workbook for 2 different Userforms which are located in the new word document. ![]() XlPath = "OSX:Users:" & GetUserName.GetUserName & ":Documents:Rechnungen:"Īpplication.ActiveWindow = ActiveDocument Set oxl = CreateObject("Excel.Application") I have been searching for a solution for almost a month now (not constantly) but I couldn't find a way to make it work.įirst of all this is the code I have to open the Workbook, which works perfectly well: Private Sub OpenExcelDatabase()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |