open

Hi I have been periodically creating a stacked column chart. This now has been divided in 3 sections and so the chart has to follow! I'm sure this should be really simple but I just cant seem to manage it. I eventually got it split into 3 by transposing the data but now I am missing P6 from my...

It always happen when I closed the excel and open it again by clicking the assigned macro

Good Morning I have an end user that can't open a 5 meg file. The pertinents are excel 2013, 32 bit, windows 10 64bit it is a macro enabled sheet came in email the file has references to external data. a very small cluster of users can't open it, but a large majority of user CAN. it's not...

I have 4 macros in my ribbon, all located in my personal macro workbook. They are no longer running when I click the buttons. I get the error Macro may not be available or all macros may be disabled" I do have my macros enabled. When I open up the IDE I can see my modules under my personal...

Hi all, I have some code that runs and opens another sheet to pull data from it. (the code checks if the sheet is open first and opens it if not). The issue that I'm having is that occasionally when I open the second sheet it opens a new instance of excel and then it can't see it. Is there...

Hello, I hope i can get some help from people whom i regard as super smart. The code below (that i have managed to get from others) finds the username and computer name so that other users would be able to use the same code on their computers. I had hoped that the code would also open the...

I am trying to extract data in the table in this site. https://www.dw16.com/indicative-price-and-info/?dw=SAWA16C2001A Using various method, eg. web query, ie automation. I can't find a way to extract data. When open with IE, web page will say you need to use chrome or firefox to open the...

At some point, my hyperlinks (that use to open up in Excel) started opening up in a web page. I think this is due to a global change that IT made in at my company (not sure). I am looking for a setting to stop this from happening. I am using simple hyperlinks to open other Excel workbooks. I...

The following code will open the specific file I need: Sub OpenRoutingOpen12() Application.DisplayAlerts = False Application.ScreenUpdating = False Application.AskToUpdateLinks = False txtdate = Format(Now, "m_d_yyyy") & "%208am" Workbooks.Open...

hi can you help please I have the code below which once updated updates other workbooks as they are all linked together, but for example if book 17 and book 18 is open and someone updates book17 then book18 doesn't update and becomes a read only file and wont save, can you help please? Option...

Hello everybody. I've the following directory in my pc: R:\Users\john.smith\Downloads It contains two files, only one of them is a .csv. But, about it, I don't know the exact name. How can I open it exploiting the only information I have? (it is a .csv file). Thank's.

Fellas, I have 2000 service order by VIN's in column A (sheet1) with different closed dates (example, VIN# 111 service order completed on 1 Jun2019. In the sheet2 I need to find if VIN 111 when is next service order open after 1 Jun or next one (see example below: sheet1: <tbody> a b VIN...

I'm away from my office traveling, and trying to get some work done. Unfortunately, every time I open Excel I immediately get an error box that pops up saying, "There was a problem connecting to the server xxx," with xxx being the name of a server I sometimes connect to when I'm in the office to...

Hi I'm running Windows 10 and Excel 2002 (don't ask why). I like to be able to open multiple instances. At the moment, if I check the "Tools/Options/General/Ignore other applications" box I get separate instances when clicking on successive file icons (which is what I want), but the workbooks...

I want to be able to click a command button and the macro will open another work book and print the first 3 sheets in the new workbook This is what I got so far Private sub commandbutton_click() If Range("A1").value=4 then Workbooks.open "c:\work\april\ivan\dinner\reciepts.xlsm"...

I have an .xltm file on a shared network drive. I set it up as a template to enable multiple users to use the same document at the same time, opening each instance as a template page... but... when they open it, the macro goes to save the file as a generated name... a pop up occurs stating that...

Hi, I have a project where I am copying data from one workbook to another using VBA. The syntax has data copying from one workbook, opening another workbook, pasting, then save, and close. The thing is that the other workbook is visible when it opens, and saves then closes. I want it to be...

Hi All I am trying to open up a workbook from my existing file (that file is the latest workbook) but im having 2 problem 1) I want to disable any workbook open code for the new workbook so if opened by macro then disable but if that workbook is opened physically then the workbook open should...

Does anyone have any unbiased recommendations for an Excel Repair tool. I don't mind paying for a good tool but it seems like if you google Excel repair tool the results are mostly promoted reviews and not unbiased. I have some xlsm workbooks that crash from time to time so what I wanted to do...

Hello, Using VBA I need to open a zip file where the excel file is password protected and save it on a designated location. I am able to open the file but the issue right now is, each time I run the macro, I am being asked (via pop-op window) to locate the file and than once the file is...