opening

Hi all, This is my first message on this community, I'm glad for having register. I'm trying to add a functionality to a program I've developed using Excel and VBA. I want to be able to open a PDF file and print as PDF in another file, all this automatically. Now you wonder "Why opening a PDF...

Hello everybody. In opening a file from an intranet, the following pop up is displayed: The file you are trying to open file.xls is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you...

I'm using a simple VBA code to open a PowerPoint file from an Excel file. Sub PPT() Dim myPresentation As Object Dim PowerPointApp As Object Set myPresentation = CreateObject("Powerpoint.application") myPresentation.presentations.Open "C:\Folder\Subfolder\F11_Blank.pptx" myPresentation.Visible =...

I can manually scroll using the scroll bar. If click out of excel and back into it, then mouse scroll will work. If I open up a userform and close it down, the mouse will then scroll. Upon opening/activating there is no code being executed. No forms are open when opening the document. All...

Hi All I have a shape that when i run the macro, the shape gets smaller so its like its sliding open for i = 500 to 1 step -5 DoEvents worksheets("mysheet").shapes("moveleft").width = i nexi i What i want to do is have that same effect on my shape named moveright but get the shape to move...

Hi all, I was wondering if there is any way to create a simple log in excel, that logs the date and time of opening and closing of Office files? Do any of you guys have any idea on how to do that? Thank you in advance Best regards

Hi All I hope there is an easy way of doing this as I have 30,000 cells I need to extract some information from. In a cell I have some information extracted from an invoice. For example BG12CF942RU, BG15CF96EFDI the information isnt consistent except for one part. Somewhere in the cells will...

Hi, I need your help with following task. I have shared file, for which few users have special right and can modify the data inside it. It works this way that Workbook_open recognise who is opening it by USERNAME and give special permisses or opening as read only. But I would like to modify...

Hello, I am getting a strange message when opening an excel file I am using MS office 360 and Windows 10, after a recent update to windows I upon opening an Excel file get the msg: Do you want to allow this program to make changes to this computer Does anyone know how to give Excel this...

Hi Friends, Is it possible to extract a particular range of cells, for example c1:c20 from a closed excel workbook (example - sheet1.xlsx) into an open workbook (example - sheet2.xlsx), when opening the workbook (sheet2.xlsx), probably using something like Private Sub Workbook_Open(), so it...

I have multiple text files that I want to open in Excel, but only one at a time. I can do this with a macro successfully for the first file in the directory, but how do I get the macro to open the next file each time I run It? Alternatively I could loop the macro to do them all in one execution...

I realize since I'm using VBA that this is code specific in a way, but I'm more or less trying to understand why Excel behaves differently based on how it's opened. Method 1: Opening a workbook from File-Open within an existing Excel application instance. Method 2: Opening the workbook from...

Hello, I am very confused. My macro was working perfectly opening files and consolidating and now it crashes every time I try to run it on the first line of code. Sub PerformAll() Dim wbSource As Workbook Dim wbDestination As Workbook Dim wbSource2 As Workbook Dim wbDestination2 As Workbook...

Hello: I wrote the following code: Private Sub cmbCareerPath_Change() With Worksheets("FindPath") .Sort.SortFields.Clear .Sort.SortFields.Add Key:=Range("D:D"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal With .Sort .SetRange Range("A1:E50") .Header =...

HI Guys I have just started getting this error had the file running 4 years with no issue. Error "An issue with the data model is preventing Microsoft excel from opening this workbook" I have tried that several times but it has not fixed it. Anybody any idea on how to trouble shoot this?

Morning all, In the last few days i have noticed that when opening an excel file it seems to take much longer than normal. I can click on the file but dont see anything so i then think i missed actually on the file so i then click it again. Because it takes some time opening i then see a...

I have a new laptop with Win10 and Office Standard 2013 installed. Frequently when I open excel from the desktop link or when opening a file it will open 2 windows, 1 is the normal window and the other is a greyed out window without a ribbon or status bar. The second window will flicker if I...

I'm just curious if I can put data into a different workbook without actually opening the workbook. I use Environ("Username") to create a list on a hidden sheet to monitor who accesses my projects. I use this method for multiple projects. Well I was thinking that maybe I'll start separate...

I have a document that is basically a big Table of Contents, with hyperlinks to helpful sites. I have 2 macros- the first is basically a keyword search, that hides all rows that don't include the keyword that the user enters into cell H2. The second is a simple command to unhide all of the...