Help with MACRO Conversion
Anyone who can help me convert this VBA Marco to the one the Zoho understands? Thanks :) Here's a link to the original file: http://sheet.zoho.com/public/uplbapsim/papsim-dec2009-a001-3 Sub WritePrn() ' ' Macro4 Macro ' Macro recorded 8/6/2001 by Tirso B. Paris, Jr. ' ' Keyboard Shortcut: Ctrl+p ' Sheets("HHModule").Select Range("A1:J30").Select ActiveWorkbook.SaveAs Filename:="C:\Apsm20\hhmodule.prn", FileFormat:= _ xlTextPrinter, CreateBackup:=False Sheets("Options").Select
When a owner of the shared sheet opens the public URL can you automatically open it in Edit mode?
I have shared a public sheet. When I open the public URL and choose Edit it is creating a duplicate copy right? Can this be avoided by automatically opening the sheet in normal edito mode when the owner is the one accessing and opening it? ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
FORMAT BUTTON
Is it possible to edit the font and/or background colours on a button? Philip Chambers
BUTTONS
Is there a way of changing the font or background colour on a button? Philip
How to insert an image into the spreadsheet?
Dear zSheet Team, Please guide me how to insert an image into my spreadsheet? ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
How do I increase the number of decimal places shown?
Hi, How do I increase the number of decimal places from 2 to 4 and prevent rounding? For that matter how do I access the formatting for a cell such a font, type, etc. I tried right clicking nothing except removal of formatting. When I click on a cell the proper number shows in the status line but within the document it is truncated to 2 decimal places. Thanks
Can not import a 40 mega byte excel sheet
Dear zSheet Team, I am trying to open a 40 mega byte excel sheet into Zoho Sheet account so that I can easily manage through my account. I am not able to import because of the following stingy restriction: Note:- - Supported file formats: xls, xlsx, sxc, ods, csv and tsv - Maximum file size allowed is 10 MB - Only unprotected files will be imported Viewer also does not support this. For your info, this is the excel sheet I am trying to view: http://rbidocs.rbi.org.in/rdocs/content/docs/68774.xls
When you close a sheet by (X) button a blank screen is presented
When you close a sheet by (X) button a blank screen is presented as in the attachment. It would be great if you could create a new sheet by default. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
How to Convert VBA to Zoho Macro
Anyone how knows how to convert this? Thanks Sub ClearSummary() 'This macro clears the summary sheet for recording purposes' Sheets("Summary").Select Columns("H:IV").Select Selection.EntireColumn.Delete Sheets("Options").Select End Sub
Zoho and Huddle
Hi I use Huddle workspace and when I create a online spreadsheet from huddle i do not get the full features of Zoho WHY? Can I create a Zoho spreadsheet, save it and link it ot my huddle account? Cheers Mel
SaveAS XLS and HTML
I need to versions of the submited spreadsheet - an XLS and a HTML File. Is it possible to post both versions? Best regards, Andy
SEARCH function in spreadsheet
How do I search for text in the spreadsheet? Example, we have a job number register. We list the job number (1000) and the customer name (ABC Company). We need to be able to search for job numbers or customers in this spreadsheet. We have hundreds of jobs listed and it would be much faster to be able to find the names with a search. Please let me know asap. Thanks,
Help creating a spreadsheet
How do I get this sample brief report to work for me Zoho spreadsheet? Date: May 20, 2011 Buyer: John Rutger Item: Rado Automatic Price: $3,100.00 USD Commission 5%: $155.00 USD Fees: $135.00 USD Forwarded to Jennifer Jorgensen: $2,810.00 USD Reference Numbers for Jennifer Jorgensen: 645-333-8907
Where did all my Edits go??
https://public.sheet.zoho.com/public/rm2dance/cosmetics-industry-map "I saved to my account" so where is the most recent edits??
row selection error
my spread sheet is selecting the row two rows below my selection point. How can I fix this? Sapoty
Unknown function: Goto
I imported an excel file with macros in it. I believe that Zoho supports macros and as i was trying to assign a macro to a button with the macro coming from the excel file i upload it does not execute and says that Unknown Function: Goto. How can i resolve this? Does zoho support goto or it has another function for it? thank you. Here's the link: http://sheet.zoho.com/public/uplbapsim/papsim-dec2009-a001-3
Goto Function
I have this excel sheet imported from microsoft 97-2003. It has macros in it and the buttons have been removed upon importation. So i made button(base-titles) and was trying to assign the imported macro (Gototitles). But i received this error. Unknown function: Goto here's the link to the zoho sheet:http://sheet.zoho.com/public/uplbapsim/papsim-dec2009-a001-3 Thank you for your help.
unable to view the shared sheets in office plugin
Dear sir, I found this is very intresting tool for online geeks.But you can make this still more interesting by adding few more options i sent in previous mails. this time I got with one more requirement. I shared the excel sheet with Avinash ( my close fiend) in zoho online sheets. I was surprised that avinash was not able to open the sheet with zoho office plugin. I worked out and found that shared excel sheets are not viewable with office plugin. Aviniash found out something in zoho that is create
Sorting problems!
Very simple sheet, no formulas. First row labels (DATE, NAME, ETC) which I've "set as text" so it won't sort along with the data. I only sort by column A (DATE), I select the column, right click sort descending, I'm SURE to answer OKAY to "expand selection?", and yet.... my dates have gotten hopelessly fucked up. Sorted without the rest of the data in rows. Or, sometimes the column just WON'T sort-- data seems frozen. Only been using this for about a week, I'm afraid to keep using it for fear of
#NAME?
I've been editing this spreadsheet i imported from excel 97-2003. I changed a value of a cell and it keeps coming back to #NAME? what does this mean thanks. Need reply asap.
font color and background color
we cannot change the font or background color-- it's not allowing us to select.... we're using from China, Guangzhou?
Allowing Shared Users to Export Workbooks with Hidden Sheets
I've read through the blogs and found out that once you hide at least one sheet from a shared user, they no longer have access to the export functionality to save a local copy of the sheet. Is this correct? Is there anyway to override this and still allow users to export the workbook even though there are hidden sheets (without having to set the hidden sheets to Read-Only)? If not, is there any plan to perhaps allow the ability to export the workbooks and not include the invisible sheets? (i
Wrap text button deleting data
Sometimes when I hit the wrap text button after I've entered a long(er) list, my data disappears. I can't retrieve it with the back button - it's just gone. This is becoming frustrating. Am I using the button correctly? Mostly it works fine - the problem seems to occur when I've entered more than three items. Please help.
Format issues with downloaded public sheet
I would like to download/import a public sheet into Excel, however when I do it places all the information into one column. I would like the Excel sheet to stay the same format as I see on the website. So I don't have to spend tons of time formatting data. I have the link of the sheet (for example: http://public.sheet.zoho.com/sheetview?do). I have installed the latest plugin into my computer and am using FireFox 3.2 Please help. I have tried everything.
Link External Data
'Link External Data' allows you to periodically sync up the data in your spreadsheet with data available on the web in the form of CSV files, HTML web pages (tables) and RSS feeds. This is quite powerful if you want to make use of live data in your spreadsheet. Learn more about this feature from the blog posts we wrote as it evolved: blogs.zoho.com/sheet/link-external-data-comments-and-more blogs.zoho.com/sheet/sync-up-remote-data blogs.zoho.com/sheet/rss-feeds-into-your-zoho-sheet-plus-new-charts
IE8 Script Warning "Stop running this script?" during Macro Code execution
I am seeing a prompt in IE8 while executing a macro for a ZOHO Sheet. The prompt is as follows: "Stop running this script?" "A script on this page is causing Internet Explorer to run slowly. If it continues to run, your computer might become unresponsive." An example of the code causing this is pasted below: Sheets("Sheet1").Cells(3,2) = 1 Sheets("Sheet1").Cells(3,3) = 2 Sheets("Sheet1").Cells(3,4) = 3 Sheets("Sheet1").Cells(3,5) = 4 Sheets("Sheet1").Cells(3,6) = 5 Sheets("Sheet1").Cells(3,7)
sheetについて
オートフィルタの機能を付けてください。
セルの結合について
セルの結合、現在は横にしか出来ません。これではGoogleスプレッドシートと変わりありません。 セルの縦結合が出来る様にして下さい。 バージョンアップしたら使います。
Upload and Replace existing file?
Hello, I am working on my Excell sheet on my desktop and I upload it then here on Zoho but every time I upload I get a different file. How can I upload and replace the existing file on my Zoho? Thanks in advance.
uploading complete folder
how can i upload complete folder. if i edit it online, do it leaves any traces to the hard disc on my computer or any other place
Auto-Sorting
I love the webdata auto updating feature, but there is 1 part that I still have to manually do -- sorting. I have the webdata set to get me a list of numbers that change continually. It is a scoresheet so I like to have it sorted so the highest numbers are on top. It's not a huge deal to manually update it, I have been doing it that way for many months now. Just figured I might as well suggest it here and see what happens.
Creating an audio alert in Sheet
Is there a way to create an audio alert in Sheet?
Copy a zoho spreadsheet
Hi, I created a zoho spreadseet and i want to make a duplicate of that file. But zoho doesn't allow me to make a copy of that file. How can I make a copy of the file so the new file contains all the formatting and formulae of the original file?
auto save each field imediatly when is eneter in Survey
i have a survey with 8 pages and a lot of questione i need a solution to save each field when is enter by the operator
Is it possible to track what exactly was changed in a spreadsheet?
I am looking for a solution that provides me with general project management tools as well as an online spreadsheet that allows us to create and edit different information customised for our project. We've previously had problems with different people changing different cells in "normal" Excel with-out other people realising what was changed and who changed it. Hence we need to see when and who has changed the spreadsheet as well as who exacly changed it. In Zoho sheets I discovered the functionality
Monthly Exp Report
Monthly Exp Report June + July 2011
New in Zoho Sheet: Image support in Export and in Remote API
We have been supporting images in spreadsheets since Sep 2007. However, when you export the spreadsheet from Zoho, the images were not retained in the exported spreadsheets. We are glad to announce that we now retain the images when you export your Zoho spreadsheets. Remote API users will also be able to view and insert images to the spreadsheets opened using our Remote API. Images are also now supported in the spreadsheets uploaded directly to Zoho Docs. The 'View in Zoho Sheet' functionality available
Linking external data -- Please provide valid dataurl.
I do have a valid data url. It was linking external fine using this url until I decided to make a change. It lets you go through the entire wizard. Provide data (HTML with URL) select data (the tables appear fine with the correct data and let you select the ones you want) select location (no issue) schedule (now or schedule both have issues) When you select DONE I get the error 'Please provide a valid dataurl.' I never use to receive this error for this same URL. Here is the URL. Again,
Zoho Sheet Crashing Too Often Today
Dear zSheet Team, Today I am seeing to much of the message as in the attachment. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Broken Grammar in Zoho Sheet
Dear zSheet Team, One of the recent error messages that I encountered with Zoho Sheet was: The server has encountered a problem. We are sorry! We recommend that you copy the data that you entered till now, paste it elsewhere and then create a new document and try again The second line seems to be too much fragmented and/or using the 'and' in a way bit not-so-desirable way. Can you rephrase and correct the same please? ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Next Page