open

Hey guyz, I am working on VBA environment, would like to keep my notepad open all the time without switching the active screen. Is there any way we can do this ? Dinesh S

Hi. I can open a file remotely but am trying to create an error handling routine where, if the file is closed, open and update the links. If the file is already open it gives a FileInUse error and gives you the option to open it as read only I have been messing around with some code and ended...

Hello All, I have an excel workbook which is linked to an Access Query via the Data>Get Data Essentially, each morning, as new data becomes available I right click and hit refresh and it updates for me. The past couple of days I have started to receive the following: "ODBC Microsoft Access...

I have a workbook that has a few outlook functions built in to it but outlook needs to be open the way the codes are written. How do I get Outlook to open when this file opens? I know the code has to go in the ThisWorkbook section of the objects. Thanks in advance

Recently and inexplicably any new workbooks that I open default to manual calculation. I read a few message boards and they said that the solution is to put a workbook in the XLSTART folder that s set to automatic calculation. This works, however any time I open an existing workbook it opens...

I know how to protect a worksheet in a macro and also protect a workbook in a macro. But I don't know if it is possible to protect a workbook in windows. Let me explain. When I open up say drive F:\... on my flashcard, I see my workbook which I will call book1.xlsm. I want to be the only...

I have used the following previously to open a query in Access and then copy the data to a holding sheetrsQuery.Open strQuery, cnConnection, adOpenKeyset, adLockOptimistic I now need to use the same but stop anyone else from getting any of the records that are in the recordset so effectively...

Hi all, I have have a code that will copy information from one workbook to the other. I have the Source workbook open, and it will show in VBA editor. When I check out a file (from a program at work) it will be saved in a local checkout folder on my computer and the file opens in Excel...

I am working on a scorecard and for a portfolio section of it I want to either calculate or lookup the most recent dollar amount of total open loans of the officer in cell C7. The table below (Located in a separate sheet) is named "Port". The expected result is $52,000,000 (Adam, most recent...

I have a small script that logs when a user opens an excel file. Currently the username and date/time are populated in the txt file. I would like to add filename to the txt file, but not sure how. Thanks Private Sub Workbook_Open() On Error GoTo errhandler: Open "D:\Reports-Service\Old...

I'm having problems understanding how to designate a specific file path on this line of code. This works as long as the file is one folder before \old reports..... As soon as the file is moved the code no longer works. I would like to be able to hardcode a folder such as...

I'm getting runtime error 1004 because someone else has a shared file open. When I open the file manually, it asks if I want to open it read only. But when VBA opens the file, it says Someone else is using the file. Please try again later. Then I get the 1004 error when I return to VBA. Why...

Hello All, How can we open this pdf file with VBA macro. C:\Users\i ' M\Desktop\PDF\test file 123-234.pdf Any help would be appreciated Regards, Humayun

Hi there, I'm wondering if anyone else uses the ignore DDE option the same way as I did, and have found a workaround to the issue I am facing, or if anyone can simply help with a solution/workaround. Previously when I checked the Ignore DDE option or used Application.IgnoreRemoteRequests =...

Hi All, I am looking for VBA code where following steps areperformed: Open website https://www.abs.gov.au/Price-Indexes-and-Inflation Click on link “Consumer Price Index” on that page. Click on “Download” tab on that page. Open .Xls file from that page (do not save that file). Copy...

I have several DSUM fields on a form. The fields are looking for values from a Query: =DSum("MONTH0_Active","qry_OnTimeDelivery_MetricData") But unless I have the query open at the same time as I have the Form open, I don't get values. How can I get this to calculate without having to open...

Good Afternoon, I have been searching through the forums, not found what I am looking for. If somebody knows of if this has been answered elsewhere, happy to go to that thread for the info. My conundrum! I have a worksheet that has a list of workbook names and locations. I need a piece of VBA...

Hi I am trying to put a code together into a command button which opens the userform1, but if someone else has the userform open already I want a msgbox pop up to say that ‘userform is in use’, I have put the following code togetherbut getting no joy. Hope you can help? Private Sub...

I ma trying to set my project so that when my userform is open, I can still select and edit cells. I have tried setting the model to false and using vbmodeless but when I do that the form just blinks and goes away. Any ideas?

hello all, can you help please , I want to sort all my data on my sheets , if I put a filter on row 5 for example and sort by a-z on the "totals" sheet (10 columns on each sheet) this works ok but I want to get it to do the same on all sheets, and not have to open each sheet and do a sort a-z...