xwb

HI, I have the code below and it was working fine (Open excel file from outlook) but suddenly getting this error: Compile Error: Method or data member not found (on the line below) Set xWb = xExcelApp.Workbooks.Open(xExcelFile) Complete code: Public Sub OpenVendorChartofAcounts() Dim...

I'm trying to write some code that will identify if a certain file is already open. If it is, then I want a msg box to appear. If it isn't, then I want some other code to run. I did some searching, and found some code that looks like it would work. I implemented that coding into my...

Morning all, I am using the code supplied below which works fine. When the code operates i am taken to the worksheet where i currently see the message "LEADERBOARD" of which i need to click OK What needs to be done so i dont have to click OK,i dont even need to see this message BUT i do need to...

Hello, I have a little problem. I want to import files to excel - different files to different sheets but I cannot manage to set two extensions at once. I like Excel to import chosen XLSX and CSV to separate sheets. I dont know how to set more than one extension. Im useing this code to import...

I'm trying to quickly check whether or not a project file is open so I can determine whether to open or getobject. Could this be adapted to Project? <code class="vb keyword" style="white-space: nowrap; padding: 0px !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New"...