Hi Ashish,
This is great, but doesn't meet my need. Allow me to explain:
The workbook will have certain "hidden" sheets that the user does not need
to interact with. That is why I'm hiding the *.* So, I need a
"Navigation Pane" that would allow the user to move only to the 8
worksheets where th
Also if u want to add worksheet navigation button on right click try this
*Add below code to workbook open module*
Private Sub Workbook_Open()
On Error Resume Next
'Delete the new button if already exists
' name of the new button is "New Button"
Application.CommandBars("Cell").Co
try this
Sub test()
Application.CommandBars("Workbook tabs").ShowPopup
End Sub
On Wed, Oct 2, 2013 at 11:26 AM, Jewel Sharma wrote:
> Hi,
> I have a workbook with 8 worksheets; wherein I anticipate the user would
> move to and fro between them in the course of using the workbook. To
> simplif
Hi,
I have a workbook with 8 worksheets; wherein I anticipate the user would
move to and fro between them in the course of using the workbook. To
simplify navigation, I intend to do the following:
1. Create a Userform that has labels for all worksheets.
2. Such userform should be always vi
try this
Sub import_word_table_to_excel()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
Dim fldpath
Dim fld, fil As Object
Dim appWord As Word.Application
Dim docWord As Word.Document
Dim tableWord As Word.Table
Dim sdoc As String
' use to choose the folder having word doc
Sub tests()
Dim I As Long
Dim J As Long
With Sheets("sheet2")
.UsedRange.Clear
.Range("a1") = "Date"
.Range("b1") = "CLOSE"
End With
J = 2
For I = 8 To Sheets("sheet1").Range("C65356").End(xlUp).Row
If IsDate(Sheets("sheet1").Range("C" & I).Value) Then
If VBA.Weekday(Shee
please share the sample file and the output u like to see in which column
On Tue, Oct 1, 2013 at 3:00 PM, noodnutt wrote:
> Hi all
>
> I actually posted this in a different group a few weeks ago and didn't get
> any results so I am trying my luck here.
>
> What I would like to achieve is:
>
> O
try to run the macro which add the data table first and then add
wait or load statement at the end ( before end sub) and call the web query
macro to download the data
or try these macros
http://dailydoseofexcel.com/archives/2006/11/29/html-tables/
http://stackoverflow.com/questions/12989687/fetc
can u add any example too in the worksheet
On Tue, Oct 1, 2013 at 7:58 PM, Chandra Shekar wrote:
> Hello,
>
> am trying to get lowest date based on condtion please find attached file
> for the same. Is there anyway to get this without using =min(if(...).
>
>
> Regards,
>
> Chandra
>
> --
> Are
can u explain how what logic you have used to mark them as PR1 - PR -2
On Wed, Oct 2, 2013 at 3:09 AM, Avinash wrote:
> Hi all,
>
> can anyone please help me to get periodic calculations.
>
> attached is the sheet for your better understanding. i want same value
> highlighted in yellow by form
can u add some values in cells to show us what wll be the output like
On Sun, Sep 29, 2013 at 11:12 PM, wrote:
> Good evening,
>
> I'm attaching a worksheet where I have explained what I'm trying to figure
> out, but, haven't been able to do it yet.
>
> Thank you in advance!
>
> Jiten
>
> --
>
try this
Sub deleteline()
Dim rngRange As Range
Dim rngCell As Range
Dim rngUnion As Range
Dim strvalue As String
Dim intcolumn As Integer
Set rngRange = ThisWorkbook.Worksheets(1).UsedRange
intcolumn = InputBox("Please enter the Column Number,where you have
t
try the attached file
On Tue, Oct 1, 2013 at 10:19 PM, maksood alam <786maks...@gmail.com> wrote:
>
> Hi All,
>
> if we covert a macro file to the a different language file, let's say in
> Spanish. will the macro work in that converted laguage file?
>
>
> Thanks,
> Maksood Alam
>
> --
> Are you
try the attachement
On Tue, Oct 1, 2013 at 10:29 PM, maksood alam <786maks...@gmail.com> wrote:
> Hi All,
>>
>> if we covert a macro file to the a different language file, let's say in
>> Spanish. will the macro work in that converted laguage file?
>>
>>
>> Thanks,
>> Maksood Alam
>>
>
> --
>
Hi all,
can anyone please help me to get periodic calculations.
attached is the sheet for your better understanding. i want same value
highlighted in yellow by formula.
Regards,
Avinash
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join o
>
> Hi All,
>
> if we covert a macro file to the a different language file, let's say in
> Spanish. will the macro work in that converted laguage file?
>
>
> Thanks,
> Maksood Alam
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official
Hi All,
if we covert a macro file to the a different language file, let's say in
Spanish. will the macro work in that converted laguage file?
Thanks,
Maksood Alam
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of
Hi Experts,
I am trying to split my Access data base using split option which is around
1.99gb. after splitting size is reduced to 1.01Gb. creating backup of
tables in New database and Orginal database remained with links to tables
and queries.
i am using MS Office 2007 version
can any one ple
Hello,
am trying to get lowest date based on condtion please find attached file
for the same. Is there anyway to get this without using =min(if(...).
Regards,
Chandra
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook pag
Dear All
When I open workbbok I used to receive following message
Please let me know how to find uot the link
v[image: Inline image 1]
Thanks in Advance
--
Shrini
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of
If I record the macro, I'm getting as below but I have few steps before
that, I want to merge the both can u pls help me on that.
I want to copy the values from the excel to the webpage and the result
table I should paste in the excel sheet. Below i have mentioned the details
Recorded Macro :
Hi all
I actually posted this in a different group a few weeks ago and didn't get
any results so I am trying my luck here.
What I would like to achieve is:
One of the Distribution Centers (DC - A) I send stock into also unloads
stock for another DC on the same site (DC - B). Many trucks arriv
22 matches
Mail list logo
