What is the easy way to create forms in different sheets.......
In Main Sheet (Sheet1) each row contains some informations about a particular item.
I want to create Forms in separate Sheets and datas for this Form 1 (Sheet2) should be datas of Row#1 of Sheet1 & datas for this Form 2 (Sheet2) should be datas of Row#2 of the Sheet1.......
Hi Guys,
Does anyone know of a web site which offers Excel tips and tricks.
Is there a free book which I can download that will give me tips and tricks.
Thanking you in advance,
Regards
J-O
Hello. I recorded the code below to convert pages of workbook to pdf. It works well on my computer but on a co-worker's computer the pdf produced has header and footer pictures shifted slightly down and to the right, showing small areas of white area on his pdf and I do not see this on my pdf produced.
-Any idea what might cause this situation?
-If I have pictures in the header and footer and the pictures are inserted from my desktop,
does this cause Excel issues with those headers/footers on another computer? Is a better
way to load and link the pictures somewhere in the Excel document?
-Is Excel not the best tool to convert to pdf? Would it be better to use Publisher
or even Powerpoint linked to Excel sheets? How about one of the many Excel to
PDF softwares out there?
Thank you.
Sub convpdf()
Sheets(Array("sheet1", "sheet2", "sheet3", "sheet4", "sheet5")).Select
Sheets("sheet1").Activate
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Documents and Settings\myname\Desktop\pdf_file.pdf", Quality:= _
xlQualityHigh, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=True
End Sub
Hy guys,
I still work with excel 2007, so, can someone tell me please if the 2010 version shows the formula tips, when we are tipping a formula in the "name manager box", and in the "conditional formating box".(when you use a formula to do conditional formating), like they are shown when we tipe a formula in a spreadsheet cell??
I think that would be a great help
Hey,
Has anybody noticed that all the help sections of the date/time help in excel tips is missing any information that's normally there?
just thought I would mention it.
oliver.
We have a batch file that will read a file, and with a couple of keystrokes
of <ENTER> a delimited text file is created.
Would there be a way I could run the batch file (i think its converter.bat)
from a vb script in excel, maybe sendkey the ENTER strokes? Then i would use
my (already made) script that opens the end resulting txt file and clean it
up of some unwanted characters.
Would this be possible at all?
Thank you for reading and answering
Mr BT
Dear guys,
i'm desperately trying to avoid excel - opened programmatically by a DLL I did not develop-to launch more than once. I need to open 3 excel files among them referenced, but right now code launch 3 different excel instances not 3 files inside one instance. This BLOCK auto updating among the 3 files. Is there a way to avoid this behaviour though some setting at excel or windows level?
My best
massimo (new here ..)
Hello Everyone,
I know there is some information available on the web regarding my question, but I have been unable to figure out how to successfully update code snippets to satisfy my requirement and I think I may be missing something.
I have the following code within Excel:
Sub LoginStateStreet()
Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")
With IE
.Visible = True
.Navigate "https://my.statestreet.com"
End With
Do While .ReadyState 4
Loop
'This is where I'm getting stuck. I would like to use VBA through Excel to review the HTML page of the web page to determine how to pass information from the spreadsheet to the web page. Viewing the page's source, I cannot seem to find controls associated with the web page form. Would anyone have any information on how to do this via Excel?
I certainly appreciate any information anyone may be able to offer.
Is it possible to launch Excel at a specified time without someone pressing a button?
I'm working on a network which has disabled Scheduled Tasks. The purpose of this request is to launch Excel in the early hours of the day so that a macro would run and update the data from a data source. The macro works brilliantly, but I without anyone in the office at 2am to open Excel, I need to find a way to launch it automatically.
Also, I don't have permissions to install programs or add-ins from the Internet. It doesn't leave me with many options, but I'm just wondering if there's a trick that has so far eluded me.
Thanks in advance!
Anyone know how to launch excel from a command line with a /switch that will cause excel to NOT launce personal.xls?
Thanks.
