I have a single spreadsheet that I save as multiple web pages [the sort and total options differ].
Is there an easy way to include a javascript snippet in the saved page without having Excel mangle the code by &ing the "<" and so on?
Excel 2000 on XP
Currently I'm using excel 2000. Can't hide hidden column when save as webpage?
View 2 Replies View Relatedam using Excel 2010 and having issues trying to save a worksheet to a specified file location with the save date....
I have tried several posts form this forum and elsewhere and can't seem to get the macro to do what I want.....
I want to save a 'worksheet' from an open workbook that I use for updating information to the same file path as the workbook with the date the file saved...
I want o write a vba code for below: I want to download and saves a list of webpages (and contents like images, animated GIFs, sounds, videos,...) as MHT Files (1 MHT file for each link from the list). In the below files there's an example of how it should look like.
Links
[URL]
I am familiar with the URLDownloadToFile function, but it doesn't download the webpage's contents. What I need is something like a URLDownloadToMHT function that downloads the entire webpage and its contents and packs it into a MHT file. The MHT file, obviously, needs to link the content files locally for offline browsing (I don't know exactly how a MHT file works, but what I mean is that src="http://www...file.jpg" should be replaced by src="file.jpg", something like that)
I am also familiar with softwares like WinHTTrack, that do something similar(with HTML files), but I think the downloaded files get too messy and disorganized, that's why I need something simple like MHT files saved in a folder of my choice. I need this Excel file to work in any Windows XP/Windows 7 computer, without dependencies from other files like third-party dll's or any other files.
Using excel 2000 on windows XP (home). When saving data as a web page the grids do not show despite having the page setup "show grids" box ticked. It makes reading the file on line hard to follow.
View 2 Replies View RelatedI have a workbook with 4 worksheets the first is called "input" which I use to enter information which goes to the other worksheets which arecalled engine, gearbox, doors.
I am stuck on the following; after inputting the information. I want to save as pdfs in various locations.
Is it possible to have 4 buttons on the input sheet which automatically :
Button 1 - Save "engine" worksheet as a pdf to a specified folder
Button 2 - Save "gearbox" worksheet as a pdf to a specified folder
Button 1 - Save "doors" worksheet as a pdf to a specified folder
Button 1 - Save the sheets as multiple excel files to a specified folder
I want to write a macro with which i can click on a particular hyperlink in that website.
For example...the website is [URL]...In this websote I want to click on the particular country (Let say "Gabon")...but I want to click it by using vba from excel.
I have a number of macros which i use to open up a web page in IE, copy the data and then paste it into excel. however i have a problem which i cant solve.
The issue is that the web page is a link to a pdf. So while i can open the page i cant seem to copy the data.
Note that the data that i am trying to copy out of the pdf is a table of data
I've developed a workbook with macros in Excel 2007 (Compatibility
Mode), Windows Vista Operating System. The purpose of the Macos
is to allow auto complete on a validated data entry field.
The macros run fine on this platform. I then copied the workbook
to my desktop, Excel 2000, Windows 2000 Professional Operating
System. One of the macros is killing Excel on this platform.
I copied some columns of dates form a website into an excel workbook. Unfortunately excel does not recognise the text and therefore I can't sort the columns from oldest to newest.
I have tried the operations here [URL] as I though spaces might be the problem but with no success.
I am trying to prepare macro to navigate web page and click on some tasks to complete it. As this web link is not access-able from outside or remotely. I am trying to work on it in bits. I have came across with a first problem of clicking on one of the link of this web page, below is the web page html source code. I want to click on last link "Total Outstanding Tasks".
HTML Code:
<td width="29%" nowrap>
<a id="A6" href="FindTask.aspx?StatusID=1,2,5,3&SLAhour=10&pageMnuOpt=4&mnuOpt=1|4&OtherMenu=true&SortOrder=1&CreatedBy=485&PreDefinedFilter=6&IsAssign=0" class="bodylink">Total Outstanding Tasks</a> </td>
<td width="29%" nowrap>
<a id="OutTasklnk" href="FindTask.aspx?StatusID=1,2,5,3&SLAhour=10&pageMnuOpt=4&mnuOpt=1|4&OtherMenu=true&SortOrder=1&AssignedTo=485&PreDefinedFilter=6&IsAssign=1" class="bodylink">Total Outstanding Tasks</a> </td>
<td width="29%" nowrap>
[code]....
I have been asked to create a spreadsheet that will contain three fields;
Date of placement (the day the person arrived)
Date of release (the above + 60 days)
Billable days for the current month
The first is simple, the clerk will enter the current date when the person arrives.
For the second field I am using:: =SUM(H5+(60),) (H5 is todays date, and will display the results in I5). When H5 is blank, I get the " #VALUE!" error in I5? Is there a more effective function to use?
For billable days, I am using; =SUM(J2 - (H5),) (J2 is simply the last date of the month; 12/31/09, and H5 is the placement date). I want to show the number of billable days in the current month. This will be repeated on 12 sheets (one for each month).
color tabs for Excel 2000 add-on
Any freeware (or shareware if necessary) program that will allow you to change tab colors on spreadsheets in Excel 2000. Later versions do have that ability built in, but 2000 does not.
I am having a problem finding the right javascript function(s) to use in my macros. Use Google homepage as an example. The line
.Navigate "javascript:_dlsetp('ss=2')"
will open the page for customizing your Google page. But what is the function you fire on in the macro to execute the general search? I can send text to the search input box, but I can't find the function that runs the search.
Is there some way to quickly identify the function and the correct syntax without having to learn how all the source code in the web page works? Finding the right URLs, links, and input boxes is fairly straight forward. But not the functions.
I need the values that are copied from the template to copy over in text form from the "Data" Tab. Secondly, the master sheet has multiple lines for each vendor. For the area highlighted in red I'd like for it to copy all cells in column C for the vendor and search the vendor by name. Then, move to the next sheet.
View 10 Replies View RelatedI am creating a chart with more than 2000 dates (each day). How can I format the axis so it only displays the 1st day of each quarter (01/01/2010, 01/04/2010, 01/07/2010...).
At the moment I cannot format the axis and minor/major units remain numbers.
I am using Excel 2010 and European date format.
I record all jobs that come into my department. Column A contains the Job reference. Column B Contains the date that the job arrived and Column C contains the date that the job was complete.
The job can be split into several sections and can arrive on different days and the sections can be completed in different days.
I am looking to create a table that will show how long the complete job took to complete, so I am looking for the earliest date and the latest date for specific job reference numbers.
An example of my data is:
Column A Column B Column C
Ref No Date In Date Out
2013-0055 01/03/2013 25/03/2013
2013-0061 01/03/2013 03/03/2013
2013-0061 02/03/2013 20/03/2013
2013-0055 07/03/2013 28/03/2013
2013-0061 08/03/2013 19/03/2013
From the above data I am looking to create a table that will show
Ref No First Date Last Date Number of Days
2013-0055 01/03/2013 28/03/2013 28
2013-0061 01/03/2013 20/03/2013 20
I am using Excel 2000.
the macro works fine until it executes the paste values. At that point, the macro jumps to the "CountThem" function which is located in another workbook. The data that I am copy/pasting is in no way connected to any cells that are using that function. Although, other values in the workbook are passed down from data that uses that function.
I am still in the dark ages using Excel 2000.
This is the code for my macro.
Code:
Sub Current_to_Raw()
'
' Current_to_Raw Macro
' Macro recorded 2/12/2014 by
'
'
Range("N14").Select
[code]....
I am using the following
xlrng.cells(5,1).resize(5,5) = myarray
If my array contains a text column with any text cell element > 900 bytes
office 2003 and greater blow up
in office 2000 it automatically truncates it without blowing up
if i write my own load loop, and load each cell individually
it works great no-poroblemo, its just extremely slow!
Is there any magic way to get this working correctly without truncation
and without blowing up?
How do i share parts of my spreadsheet on the board?
View 1 Replies View RelatedHow to modify this code so that it actually adds to the list of results rather than replace:
Code:
Sub EncID_IP()
'.:: Extract EncID
'
Dim lRow As Long ' East to West
Dim bCount As Byte '1,2,3
[Code] .......
I would like to see a snippet code for adding two simple cells, I would like to write a number in A1 and another in A2 and get the result in A3
View 9 Replies View RelatedI'm trying to put together a script, a snippet of which is below; which applies formatting to a given array of sheets.
In the code below I'm trying to merge B5 across three columns and B38 across 5, but I can't get this to work, depsite all the internet searching.
[Code]....
VBA snippet for the following:
Code:
If an instance of outlook is running then
bind to it
Else
Create new instance and bind to it
I am working with Excel 2007 and have an occurring problem when I resize a table. Some of my forumlas copy to the new rows, while others do not. How can I ensure all my formulas copy to the newly created rows. Also sometime when they do copy to the new row an #REF! in the formula where the range should be , yet if I copy and paste the formula from the above row it works.
Here is an example of one of my Formulas Note Sheet1!$J$3:$J$500 is also a table Called Data
=SUMPRODUCT((Sheet1!$J$3:$J$500)*(Sheet1!$A$3:$A$500=$A14&DP$4)) and this is how it is inserted into a new row
=SUMPRODUCT((Sheet1!#REF!)*(Sheet1!#REF!=$A15&DP$4))
I have an expense report, which was originally done in Excel 2003. It still prompts users to open as read only however if they select no, they are not prompted for the password, and it has allowed them to save, so when the next person opens it, they have the previous person's report instead of the clean workbook. I have tried everything to put a password onto it. I know this is really basic stuff, but maybe I am missing a step? I want the end user to be able to make all the changes they want in read only mode and then do a save as, but if the select No when prompted "Open as Read-only?" they should have to put a password in.
View 4 Replies View RelatedWhat I am trying to do is that I have an excel file with macros and it is a read-only file. In order for the user to save, I want them to only be able to save as a .xlsx file as it disables all macros. If for whatever reason, the user wants to save the file as another .xlsm file, they should be allowed but before they save, a "are you sure you want to save as .xlsm?" message should pop up.
All the options in the save as box should still be available in case they want to save in that particular format. Just that the .xlsx should be the default.
Using Microsoft Access to pull from a database work orders. Some of those are what we call "dummy" work orders and have a letter in them, real work orders are signified by a 10 digit number. I would like to sort and eliminate the letters to find appropriate data. I am assuming I will need to copy into excel and do some sort of formatting but not sure where to start.
View 1 Replies View RelatedI have never worked on workdays before so I do not know most of the available formula and play around. I googled across and found this one: [URL] .......
Where Bob has given an ARRAY formula.
Following is my layout in A1 to C3 grid (for testing purpose):
Start Date11/1/2011HOLIDAYEnd Date11/30/201111/3/2011NETWORKDAYS2011/22/2011
The formula resides in B3.
Is there any other development in 2007+ versions of Excel which can handle 6 working days in a week?
I'm trying to change the colour palette to include patterns (for charts). Is this possible? We use Excel 2003.
View 1 Replies View Related