opens

Hi, my path for Sharepoint opened in Windos Explorer is: \\q13-example.wmi@SSL\DavWWWRoot\TestDocument\Test01 If I click on this link, I get the Sharepoint folder in Windows Explorer with the same path. But my VBA code opens this path as https:// link. I don't know why?

I run this code two different ways. First way is by clicking on the workbook icon itself and when the workbook opens the code excutes perfectly. I also have a another workbook with a form button that when pressed opens this workbook and this code runs. When the workbook opens the code errors in...

Currently I have some code that opens IE manipulates it in the way that I want, and then closes it at the end of the sub. I have IE.Visible = False, so that it all happens in the background. I was just curious about something. Can I open the IE as invisible when the workbook opens, and then...

I have a process where it loops and opens thousands of excel files and then copies each tab to a blank spreadsheet. At some point when it opens the file, it prompts for a sharepoint login. How can i disable it so that it does not prompt me for that info?

Hello I need some expert assistance with VB ! I want to execute some code so that when a person opens a specific Excel file it does so with READ/WITE access. This will prevent a file being opened as READ/ONLY

Hi There I received this file from someone, please see the screen shot below. What are these arrows, when i click on them, it opens up with a text box on left and it says its a diagram. how do you get this, is it done in excel or somewhere else like Visio and imported in excel. its not a...

I added a password to my spreadsheet by going to "Save As", Tools, General Options and added a password to "Password to modify". What I am encountering is when someone opens the file in Read Only, it is locking me out from editing. What I am looking for is when someone opens the file in read...

https://www.dropbox.com/s/u1h5kie2ygi79xy/N%20Plain%20Disappearance_7JUL18.xlsx?dl=0I've copied worksheet array formulas to new sheet and pasted formulas. Modified arrays on worksheet fine with no problems. Replicated that process to 3rd worksheet. First half of worksheet allowed me to modify...

I recently created an excel workbook that contains a user form that opens as soon as the app opens. This works fine on my desktop app but it appears to not be working when it opens in the excel online version. I basically have VBA code: Private Sub Workbook_Open() ufmTripSignup.Show End Sub...

Hi everyone I have workbook that i want to protect with a password and when it opens ask for the password. i want to use vba code. Does anyone know how to do that? Sincerly Christian

I've created a splash screen that opens when the workbook opens as planned, but does not unload after the required 3 seconds, it just stays open and does not seem to call the Sub that should close it. I'm using the code Application.OnTime Now + TimeValue("00:00:03"), "UnloadSplash" , and...

I need to delete row(s) if the row is 0 (blank). I see some code the looks up the whole sheet, but not what I need. Here is part of the instructions that I need to make a macro. <colgroup><col width="45" style="width: 34pt;"><col width="117" style="width: 88pt;"><col width="501"...

I am running some old code, and during the programme , it opens a window for one of my folders, as if it is looking for data or saving , if i press cancel on the window the code continues to run and completes. All the data is correct so if clearly does not need whatever may have been in that...

So I have this code below. It is opening a text file and pasting its contents into excel. Simple. This particular workbook loops through around 1000 text files and compiles them into a single sheet. The problem is that the code has been stopping at the code below when it opens the file...

Hi, I have the following code that opens an internet window from Excel using vba, however the IE window never opens up 'maximised' - how can I adapt my code to achieve this? Dim IE As Object Set IE = CreateObject("internetexplorer.application") IE.Visible = True IE.navigate...

Hi, I am trying to select a cell from another workbook. I have the following code, a new workbook opens but is greyed out and I cannot select the cell. Once I close the inputbox, then i see the target workbook open up. Please suggest If condition is true Then Workbooks.Open...

I promise Im proficient in Excel but I cannot figure this issue out. When in excel and I press 1 on the far right number pad, Powerpoint opens. This doesn't happen in any other program aside from excel. Any thoughts?

Hi guys, is there a way that Excel automatically opens a certain excel file (example file B) when I open for instance excel file A?

Hi, I have created a UserForm1 and i have put as show when workbook opens and close. But sometimes it runs and sometimes not. I want to make compulsory run the UserForm1 when when workbook opens and close. Your support would be appreciated.

Hi all I've written a module that runs through a table column of workbook paths It opens each workbook Refreshes the data connections Then refreshes the the pivot caches Then closes the workbook However, once the second workbook opens I get 1004 application defined or object defined error...