Viewing XLSM On Android Tablet?

Aug 9, 2012

I'm trying to open a .xlsm on an Android tablet with only OfficeSuite installed. Initially, that didn't work. After installing a DocumentsToGo application, it shows me my spreadsheet, but none of the .jpg's that are visible in the original file. I copied all .jpg's to the tablet; both the .xlsm and the folder with the pictures are in the same parent folder, to simulate the original folder structure in Windows. Still the pictures will not show.

View 1 Replies


ADVERTISEMENT

Excel 2007 :: Run VBA / Macro On Android Tablet

Jul 2, 2012

Run an xlm Excel file VBA / macro code on Adriod tablet, during a job interview situation, in order to showcase my work. Is this technically feasbile ? I don't want to bring a lap-top, for fear of the hassle the interviewer wants me to modify the code on the spot during interviews.

View 1 Replies View Related

Importing Several Tablet From Different Websites

Aug 5, 2014

im trying to import several tablet from different websites.

Is it possible to import to import the same table just by changing the website.

For instance:

[URL]

View 1 Replies View Related

Email XLSM As CSV

Apr 11, 2014

I have some code which works perfectly and emails the active workbook (which the code is within) as an xlsm to a email address. All is well.

However - how do I change my code so the workbook is sent as a CSV?

[Code] ....

I thought putting the following would work after 'ActiveWorkbook.FullName' but it did not:

[Code] .....

View 1 Replies View Related

Save As Xlsm

Aug 23, 2008

My office just converted to 2007 and I am running into a problem with code used to save a workbook. I need to use a dialog box as the file could be placed in several different locations which the user needs to choose.

When the save as dialog box opens it defaults to being saved as the xls type. I would like to modify the following code so the file type drop down defaults to the xlsm type. Below is my code.

Sub SaveFile()

Dim Fdate As String

myDate = Range("HeaderPage!B13")
myFile = Range("HeaderPage!b8") & "_" & Range("HeaderPage!b9")

Application.Dialogs(xlDialogSaveAs).Show myDate & "_" _
& "_" & myFile & ".xls", 1, , , , False
End Sub

View 9 Replies View Related

Running Vblookup Between Two .xlsm Documents

May 19, 2009

I have two workbooks one names "Quote" other named "product supply". In "Quote" i would like to have somthink like a Vblookup that on a givin line can enter price's, disciptions and other data automaticly on that line, From the "Product Supply".

Example:

"Quote" A:1 Dropdown list. Select product, Then refers to "product supply" of that product, then trasphers data into "Quote" A:2

View 8 Replies View Related

Slow Vba Running With Xlsm Files?

Aug 29, 2013

i have a simple question regarding vba code involving opening/eleboration/closing of different excel workbooks' format. I saw that with xls/xlsx the macro works with relatively high speed, but it is very slow when it comes to xlsm file. Is there an explanation? Does a command which enhance speed for xlsm file exist?

View 8 Replies View Related

Save XLSM As PDF And Mail To Recipients?

Sep 22, 2013

I know there are plenty of examples on how to do this at a basic level but I am looking at making it a bit more custom.

I would like to put some variables on a sheet in a workbook and use those to drive the behavior of the code.

EG I would like to specify the save-as-pdf path (eg c:users.etc), the email addresses to be emailed TO (specify a range eg A1:A14 where each cell has a different email addy in it), like wise for CC and then BCC (new ranges), also be able to specify subject of email (EG Cell F1.value is email subject).

View 2 Replies View Related

Cannot Open XLSM File Properly

Feb 16, 2014

I made the excel file with the VBA source code, saved it, opened it many times, and all at sudden I cannot open it anymore. When I try to open the file I get the following screen:

actually, Excel asks me if I want to enable macros or not, but this window is different than usual window:

when opened file with macros works fine.

So, in my case I click the Enable Macros button of the first picture and my file seems to open in some hidden instance, because the file name isn't writen in the title of the Excel window.

When I close the Excel window it asks me if I want to save changes to my file, and that proves that it was opened in some hidden instance of the Excel.

I have to say that I was not playing with the security options of hiding any part of the file that I want to open, and which doesn't open properly.

View 1 Replies View Related

Vlookup Using 2007 And Extention .xlsm

Feb 19, 2010

Im currently using excel 2007 and have my workbook saved with the extention .xlsm. I have put a vlookup formula in a cell and have placed $ constant sign se the formula will look in the same column but different rows. However, when I copy and paste the formula down the rows, the formula captures the same data.

View 9 Replies View Related

Excel 2010 :: XLSM Password Remover

Aug 6, 2014

I have an MS Excel 2010 xlms file which is password protected. Unfortunately, the person who has the password has left the company!

Which is the best tool to remove the password / recover the file?

View 2 Replies View Related

Vlookup To .xlsm Macro Is Incredibly Slow

Jul 23, 2009

This is designed to be run on bid proposals, to calculate special discounts. My idea was that whoever was designing the bid would open this file, which has the discount information and the macro, and then run the macro on the file containing the bid.

This macro works. It worked really fast when it was in my personal.xls and referenced an .xlsx file for the vlookup. It was slower, but still tolerable, when I moved it to the .xlsm file and it still refenced the .xlsx file (an oversight on my part). Now that I fixed the vlookup reference to the .xlsm file, the same one that the macro itself is in, it has slowed to a crawl. What is going on?

View 2 Replies View Related

VBA To Check Version Of Created XLSM File?

Jun 21, 2013

I'm creating a template xlsm file that has built in marcos. This file will be used by the Engineer as a template, where they fill in the data, and then send it to the team. when the case in finished, they will use clear data macro.

The Problem I want the template to have a macro runs with startup of the file that checks for the lastest template in a network folder (shared folder where they will have read only access). If the used file is the latest one, OK. If not, give a custom msg with the location on the network.

View 6 Replies View Related

Universal Viewing Preferences....

Sep 24, 2009

Is there a way so that on his computer he can tell Excel that each sheet to be viewed should have a standard/automatic view set to 100% or another percentage?

View 3 Replies View Related

Lock Project From Viewing

Oct 22, 2008

I've done the following steps so far:

Tools
VBAFormatProperties
Checked the "Lock Project from Viewing"
Applied a password
and clicked Ok

View 3 Replies View Related

Protect Sheet From Viewing?

Jan 18, 2012

I have a workbook with several worksheets. I need to prevent users from viewing worksheet mgrview unless they have a password for it.

View 1 Replies View Related

Restricting Viewing Of Particular Cells

Oct 23, 2007

I do not want to send each rep a file only with their own sales figures as this will be very time consuming. If I could send one file to all representatives but restrict their view to their own figures only, this would make life much easier. If necessary I can set up passwords for them.

View 9 Replies View Related

Viewing A .csv File In Excel

Feb 17, 2010

is it possible that when i open a .csv file in excel i can make it only display some of the columns? The program i am using exports more info then i need and it gets very tiresome to delete each column manually.

View 9 Replies View Related

Viewing A Hidden File

Jan 23, 2007

I am not sure why but when I opened a particular file, the file hides somewhere in Excel. I am unable to view the file but when I try to open the same file again, Excel prompts that the file is already open but I can't see the file.This is an important file at work and I am not sure how to actually get to view the file. I tried copy and pasting the file in another location and then trying to open in Excel. However, the same thing happened.There is no error message.The file is opened but I am unable to view, as it seems to hide from view.Is there a solution?

View 7 Replies View Related

Excel 2010 :: Save As Cell Name In XLSM Format

Jan 28, 2013

I am looking for a vba to use a button to save a file using the cell as its name and save the file in xlsm format. I am using Excel 2010.

View 12 Replies View Related

Saving XLSM File From Excel 2010 To 2003?

Aug 1, 2013

I'm trying to save an Excel file to be opened on Excel 2003, but with some VBA formulas. What is the compatible format? 2003 doesn't open in .xlsm format.

View 1 Replies View Related

VBA Code To Open Any Excel Extension (XLS / XLSX / XLSM)

Apr 22, 2014

I am using the following code to open a woorkbook:

Workbooks.Open Filename:= "C:UsersDesktopExcel.xlsx"

I am running into an issue were a file may be saved as .xls or .xlsm instead, but I still need to have the macro open it. Is there a way to adjust the above code, or other code for that matter, that will allow my macro to open any of these extensions?

View 3 Replies View Related

Using XLSM Spreadsheet As Mail Merge Data Source?

May 13, 2014

I have a database that uses a few basic macros that I would like to use as part of a mail merge ---> Form Letter. Word does not seem to support the use though of xlsm files as a data source though.

Full disclosure - I am using a mail merge form letter to automate the creating of a report that has a LOT of place holders. I 100% realize that there are ways to do this within Excel that would be much cleaner and much easier, but truthfully, I DO NOT have the skills to write the code for it. (The macro I am using was wrote by a wonderful member of these forums. (Snakehips))

Do I have any work arounds to the xlsm / mail merge debacle? Is there a method that I could do that doesn't require years of VBA experience?

View 2 Replies View Related

Excel Crashing When Viewing VBA Code

Dec 27, 2012

I have a semi-large macro which I have been creating on and off for a few months now. The file will fundementally be used by people with little knowledge of Excel, hence I force the user down certain alleyways depending on what they have previously done with the aid of veryhidden sheets and such like.

Upon opening the file, some code is ran to hide all of the sheets in the file apart from the home page. This is a pain when I am still working on the code though, so a portion of it is commented out. When I uncomment the "on error.. - next sheetIn" so that the file runs as it would be used, the code itself works perfectly and hides all of the sheets apart from the home page. Unfortunately, I can't then view the VBA code as it instantly crashes Excel (and any other Excel file I currently have open). This happens whether I click the Visual Basic button in the Excel ribbon, whether I try and access it through the design mode on a control, pressing Alt+F11 or even opening up another spreadsheet containing code and attempting to click on the broken macro after viewing the VBA code for the working spreadsheet.

VB:
Sub workbook_open()
'stop screen flickering whilst running the code
Application.ScreenUpdating = False

[Code]....

The only way currently to get back into the code is to open the spreadsheet up with macros disabled and recomment the code, but obviously this loses the function of the code.

View 3 Replies View Related

Viewing Worksheets In Full Screen?

Oct 30, 2011

I have large workbook with various sheets. In my first worksheet I have some command buttons that call each sheet as needed. However, I would like each sheet to be displayed either as a web page or in a way that the user does not see all of the menus, bars and so on.

View 1 Replies View Related

Viewing And Printing Selected Worksheets - VBA

Sep 3, 2009

I have a workbook containing a number of spreadsheets. Some of the spreadsheets are user inputs. The results of the user inputs drive a number of final reports. The final reports (i.e. spreadsheets) are hidden from the user (I don't want the user to be overwhelmed with so many tabs when they open the excel spreadsheet).

I created on the main input tab spreadsheet the following:

1. Check boxes - so that user can select after making his/her inputs the reports that he/she wants to view or print.

Say there are 4 reports (call them Sheet1, Sheet2, Sheet3, Sheet4 - therefore, 4 check boxes. Through the Format Control, the checkboxes have cell links that yield TRUE (if selected) or FALSE if not selected - linked to cells A1, A2, A3, A4 respectively.

2. Option buttons - one for view and another one for print. Through the Format Control, the View and Print option buttons have cell links to cell A5 yielding 1 for View and 2 for Print.

3. Command button - that will clear the check boxes

Issue
I would like to know if there is a way to code in VBA to:

1. Unhide the spreadsheets corresponding to the check boxes if selected;

2. Print the spreadsheets corresponding to the check boxes if selected for printing; and

3. Clear the checked boxes to unchecked if the Command button is clicked.

I'm struggling with coding to perform the above tasks.

View 9 Replies View Related

Password Protect Sheets From Viewing

Sep 12, 2006

I have a excel file with around 8 sheets in it and this file puted in the network to be shared with 8 persons So i need to make an individual password for each one to enter to his specific sheet and have full authorization to make anything in it and this done using userform where each one when open the file in the network , a user form open in first stage to select his name and put his own password with the ability to let each one to make his own password or change it from the userform

this file is shared so it may more one user open it and it may be there an save funtion at same time ( same time & same activities )

View 9 Replies View Related

Stop Formula Viewing Without Protection

Dec 13, 2006

I am looking for the code to keep certain cells from being rested on, they can be clicked on but in order for you to view the formula in the cell you have to hold down the mouse button otherwise it will move you over to the cell next to it. I was using another worksheet a while ago and was trying to view the formulas but when I clicked on the cells holding them it would move me to the next cell, the only way I could view them was to hold the mouse button down as soon as I would release it it would be gone! I do not want to protect the sheet, if there is another way to hide formulas I am open to all ideas!

View 4 Replies View Related

Password Protect Worksheets From Viewing

Jan 3, 2007

Here is what I try to achieve:

- I have a "Menu" worksheet with basic Hyperlink to Sheet1, Sheet2 etc.

- When I click on a link (or on the tab), I want a prompt asking for a password (different for each tab). I do not anyone who doesn't have the correct password to see the content of the worksheet.

(I don't know VBA and I couldn't modify the code to fit my needs)

Here is the code posted

Dim sLast As ObjectPrivate Sub Workbook_Open() 'Ensure Sheet1 is not the active sheet upon opening. If Sheet1. Name = ActiveSheet.Name Then Sheet2.SelectEnd

View 9 Replies View Related

Protect Workbook From Editing / Viewing

Feb 14, 2008

I have placed a workbook on a network drive. This workbook contains sensitive information and I would like to protect it to a "feasible" degree. I have written the following code

Private Sub Workbook_Open()
Dim userid As String, valid_userid As String
Dim i As Integer
valid_userid = "MISI01/"
userid = GetUserName()
userid = UCase(userid) & "/"
i = InStr(1, userid, valid_userid)
If i = 0 Then
MsgBox ("You are not authorised to use this workbook")
ActiveWorkbook.Close False
Exit Sub
End If
'create menu when workbook opens
Call Module1.CreateMenu("")
Call Modul1.check_filedate("")
' This will disable the user from moving, renaming etc the sheets
ActiveWorkbook.Protect Structure:=True, Windows:=False
End Sub

As can be seen from the above code, I check if the current userid is one of those that are valid to open the workbook. If not the idea is to tell them and close the workbook immediately (this bit isn't tested yet). This code is not supposed to be hacker proof, but to prohibit the casual user from reviewing the the data.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved